MySQL queries for ProcessMaker

Completed Posted Nov 28, 2012 Paid on delivery
Completed Paid on delivery

I need the following three MySQL queries to be created against the latest version of processmaker ([url removed, login to view]). The database schema for processmaker is reasonably well documented but it is not a simple schema.

1) All open cases with: case number, task title, date last updated, the username currently assigned to the task, and the case variable 'bizdev'

2) All open cases with: case number, task title, and the case variables 'budget' and 'bizdev'

3) All open cases with: case number, task title, the 'bizdev', 'date_proposal_due' and 'codename' custom fields

You should either have experience with processmaker or be able to quickly understand the processmaker schema. If necessary I can provide shell access to a processmaker instance, but I'd really prefer not to, so clarify if your bid requires access to an instance of processmaker that I set up.

MySQL

Project ID: #3994603

About the project

8 proposals Remote project Active Dec 5, 2012

Awarded to:

TayyabAlibin

hello sir, please see pmb...details are provided there........................... thanks, waiting you

$105 USD in 1 day
(7 Reviews)
3.5

8 freelancers are bidding on average $149 for this job

gopalvora

Hi I am ready to work with you from now. we have lots of experience of HTML , CSS , PHP , My SQL. Wait for start new work with you. so lets start work. Thanks

$150 USD in 4 days
(58 Reviews)
6.0
linuxfreak1985

We are experts in PHP Open Source (any kind of PHP/MySQL work), Javascript Framework (Jquery) and Ajax/Web 2.0 technology. Some of the projects we completed for php are mentioned below https://www.freelancer.com/pr More

$140 USD in 5 days
(29 Reviews)
5.2
AccuPro

Hello, I can help you with this. I have included more details in the PMB. Kindly review and revert with any questions you may have.

$250 USD in 4 days
(4 Reviews)
3.3
diegogarcia0531

Hi, I can do the job, I am SQL, PL/SQL developer, Experienced in MySQL, ORACLE, MS Access, SQL Server, Firebird databases Please check PMB for more details

$150 USD in 5 days
(1 Review)
2.0
AmrElDegwey

It's easy to understand a new schema, and i'm very experienced in making new queries like that, so trust me in completing this task with the best performance.

$100 USD in 7 days
(0 Reviews)
0.0
johnflash

Hi, i see you need some customized queries on the processmaker database schema. I could achieve this by writing a php script which would run the desired queries and show the results in a table/grid. All in less than More

$100 USD in 1 day
(0 Reviews)
2.0
Saravananshc

I've got 2 years of experience in ProcessMaker with more than 5 process implemented. Also I have good knowledge in MySQL to complete the job asap.

$200 USD in 2 days
(0 Reviews)
0.0