Filter a report by value in a collection

[emisu...@gmail.com]

Is there a way to filter a Web Interface Report by a value in a collection?
For instance,

Report:

Color | Created Date | Updated Date
=====================================
Red | 1/1/2015 | 1/5/2015
-------------------------------------
White | 1/2/2015 | 1/3/2015
-------------------------------------
Red | 1/5/2015 | 1/10/2015
-------------------------------------
Blue | 1/10/2015 | 2/2/2015

Collection:

Color | Status
================
Red | NG
----------------
White | OK
----------------
Blue | OK

Based on the "Status" in the collection, I'd like to filter the report so that I see the report as below (where Color's "Status" is "OK"):

Color | Created Date | Updated Date
=====================================
White | 1/2/2015 | 1/3/2015
-------------------------------------
Blue | 1/10/2015 | 2/2/2015

Can I do this without saving all the Web Interface data to a Collection and creating a report from Collection data?

[Pankaj Kumar]

Hi,

No direct feature is available to filter the Web interface report data based on collection data, though if you have "status" ( value is OK/NG) variable is available in your process as measure, you can directly filter the record from report configuration using filter. If "status" is not available in process, you can follow the below approach:-

Please create a Composite API (CAPI) to get data as per your specific requirement. Please refer to "Process Reporting API". Once you get the data, based on the data fetch from the collection, you can use freemarker method and loop to filter the record.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/0cdc9c50-a7c3-49f6-84f3-04e8ac704303%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[emisu...@gmail.com]

Thank you for your help.

>Please create a Composite API (CAPI) to get data as per your specific >requirement. Please refer to "Process Reporting API". Once you get the data, >based on the data fetch from the collection, you can use freemarker method and >loop to filter the record.

"Process Reporting API" looks like something I may be able to handle. Could you elaborate the second part: "Once you get the data, based on the data fetch from the collection, you can use freemarker method and loop to filter the record.", a little more?

[Pankaj Kumar]

HI,

As shown in "Process Reporting API", you can get the report data in xml format and as per the freemarket script given on this link, you can parse the xml to an array using

<#assign entries = P_to_array(P_result.feed,"entry")>

 From collection, please get the colors whose status is "OK", once you get colors, you need to filter the report data by writing the free-marker script and looping through the array using "list" keyword of free-marker. 

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum+unsubscribe@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.

To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/584e56e2-2bfe-40f0-ac1d-e1a26e320a5b%40runmyprocess.com.