Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everybody
At this moment i am working designing a Dashboard for some process in a company, the processes were made in Processmaker that is a popular BPM, the database is MySql and the idea is process that information in Qlikview in order to define some KPI to be measure on real time.
My problem is that the information that i need to process, is included in only one field of the database, in the picture below you can see the information in the APP_DATA field.
Someone knows how can i process that information?
Sorry for my english.
B.R.
Hi Wilmar,
The information stored in the APP_DATA is an array, you have to obtain the APP_DATA, inside ProcessMaker, for example with a trigger and then unserialized (i.e., converted back into an associative array of associative arrays). Check the defintion of the PHP function PHP: unserialize - Manual, it will help you.
If you have more questions I invite you to register to the official ProcessMaker forum, ProcessMaker.com • Index page, a lot of people will be willing to answer your questions.
Regards,
Hi Liliana.
Thanks a lot for your answer, was sol helpful, we chevk your example and we applied and Works so Good.
Thanks for your great help.
BR