MySQL queries for ProcessMaker

Imekamilika Ilichapishwa Nov 28, 2012 Kulipwa wakati wa kujifungua
Imekamilika Kulipwa wakati wa kujifungua

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

Kitambulisho cha Mradi: #3994603

Kuhusu mradi

8 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Imetuzwa kwa:

TayyabAlibin

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

$105 USD kwa siku 1
(Maoni 7)
3.5

8 wafanyakazi huru wanazabuni wastani wa $149 kwa kazi hii

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 kwa siku 4
(Maoni 58)
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 Zaidi

$140 USD kwa siku 5
(Maoni 29)
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 kwa siku 4
(Maoni 4)
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 kwa siku 5
(Maoni 1)
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 kwa siku 7
(Maoni 0)
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 Zaidi

$100 USD kwa siku 1
(Maoni 0)
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 kwa siku 2
(Maoni 0)
0.0