Creating JSON Report

104 views
Skip to first unread message

sagar....@flowian.com

unread,
Sep 2, 2015, 1:03:53 AM9/2/15
to Fujitsu RunMyProcess Developer Community
Hello Support,

I am creating a JSON report. I also want to implement the filters on the report. In the documentation there is mention of one API call. Can you provide me the details of the API. And how can we implement the filters on the report.

Regards,
Sagar

Murali

unread,
Sep 2, 2015, 6:17:23 AM9/2/15
to Fujitsu RunMyProcess Developer Community, sagar....@flowian.com
Hi Sagar,

Could you please elaborate your requirement and let us know the documentation link that you are referring to, so that we can suggest further.

Regards,
Murali

sagar....@flowian.com

unread,
Sep 2, 2015, 6:46:15 AM9/2/15
to Fujitsu RunMyProcess Developer Community, sagar....@flowian.com
Hello Murali,

Here is the link of the documentation I am referring to- http://docs.runmyprocess.com/Developer_Guide/Web_Interface/Design/JavaScript_Report

We have done with the reports. WE want to implements filters on the Javascript reports. In this documentation there is one API call, But no any further description of the API.

Could you please guide me on how can I implement the "filters" on the Javascript reports.

Regards,
Sagar

Bidisha Das

unread,
Sep 2, 2015, 9:39:50 AM9/2/15
to suppor...@runmyprocess.com
Hi Sagar,
You can't add/implement filter on javascript report.



Thanks & Regards
Bidisha

sagar....@flowian.com

unread,
Sep 8, 2015, 1:06:09 AM9/8/15
to Fujitsu RunMyProcess Developer Community
Hi Bidisha,

I refer to the documentation provided by RMP and in that there is something API call and also there is something about the filters on JSON.

Please see the below link.
http://docs.runmyprocess.com/Developer_Guide/Web_Interface/Design/JavaScript_Report

Regards,
Sagar

Pankaj Kumar

unread,
Sep 8, 2015, 3:39:43 AM9/8/15
to Fujitsu RunMyProcess Developer Community, Sagar Wadekar
Hi Sagar,

On java script report configuration, you can select which filter operator should be available in your report to filter the data like "=", "!=" or "contain" for string column filter.

You need to pass the filter operator selected by the user in report to the CAPI. you can get the same by using the method "id_report.getFilters()". the structure of filters is a array of josn object like "[{"filter":"lastname","value":"rr","operator":"CONTAINS"},{"filter":"creationdate_num","value":"10","operator":"LT"}]".

Once any filter is added or change, it will trigger the code written by you on "Load Data Script"


On CAPI, either the third party service you are integrating or created by you should handle the business logic of implementing the filter query of the data.. you need to get the filter info from the input parameter that is sent to the CAPI and apply that info to your business logic. Currently there is no tutorial available on RMO docs as a complete example. I will suggest you to create your own CAPI first to implement a single filter like "=" and gradually make it complex as per your need.

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...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at http://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/ae0d0ddb-ef5a-4654-bd99-b42ac78b77fa%40runmyprocess.com.

Reply all
Reply to author
Forward
0 new messages