Questions and discussion about developing processes and programming in PHP, JavaScript, web services & REST API.

Moderators: ArturoRobles, ArturoRobles

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.
By pawansaxena
#828551
Hello all,
Hope you are safe and doing well.

I am trying to solve a problem where i need some reporting and for that i need to fetch all the case variables and their values sorted by tasks involved.
For example let's say i have a :
Process P1
For that process P1 i have 1000 cases in database.
That process have 3 Tasks T1, T2 and T3.

I need to get the case variables data for specific tasks ( T1, T2 and T3 ) separately.

It would be good if there's some sort of mysql query that i can run on database and use case_id and task_id to fetch the variables ( dynaform data ) and data associated with them.

I know there's APP_HISTORY table and APPLICATION tables but in the APPLICATION table there's one row for each case and the data gets updated once the case moves to next task in it's flow so i cannot identify which task had which variables associated with them and what was the data.


Any help would be highly appreciated.


thank you
Pawan
#828552
Hi,
You can create report table from your process and then get report from your fields and cases data:
https://wiki.processmaker.com/3.1/Report_Tables

http://pmlearning.info/plugin.php?t=Advanced-Reporting-Plugin-ProcessMaker
Thanks
#828553
Thanks for the answer @programerboy, but thing is i don't want to create the extra overhead by creating reports tables.
I want to get a sql query which i can run on database and get task specific data grouped over cases.
#828564
Please visit here The Home Depot Guest Experience Survey also provides its customer’s a good opportunity to voice their thoughts about the products and services they experienced at their latest visit to Home Depot.

check here https://mysurvey.onl/
By benkloti
#828565
The approved clients and people utilizing the Consumer Value Stores are revealed to you keep your own certifications yet this is private. Not to stress over it simply read this to guarantee CVS Employee Login Benefits.
<a href="https://httpcardactivation.com/">Click here</a>
Install in ubuntu

Nov 8, 2014 — You can install applications d[…]

Hi, The form.setOnchange() method does NOT work w[…]

design

Hi, You can easily change your forms like this eve[…]

Dear All Please help me I have installed process[…]