Use javascript to apply filter to collection report

[arman_...@icloud.com]

Hi Team,

I have a requirement to have an interface with two lists (one for customer, the other for description) and based on the selection of these lists, filter the collection report underneath.

The problem I'm having is that I keep getting an #NA error when running the script in the Test Console window.

I'm using:
id_report.addFilter('supplier', 'EQUAL', 'test supplier');

I've tried several different values instead of 'EQUAL' based on other posts in the boards, yet I keep getting the same error. I've also tried using 'addMeasureFilter' with the same problem.

Can someone please advise how to resolve this?

I've attached some screenshots with the problem.

[arman_...@icloud.com]

Hi Team,

Any assistance on this issue available yet?

[Gunjan Rajgure]

Hi There,

You can use query parameter of report to filter report. Have you tried with it? 

eg. you can use query as {"supplier":"test supplier"}

This will shows only test supplier records. Please check attached screenshot.

Pardon me if I misunderstood your requirement and do not hesitate to contact us for any further query you have.

Thanks & Regards,

Gunjan Rajgure

Fujitsu RunMyProcess Support

On Thu, Oct 4, 2018 at 9:44 AM arman_chaser via Fujitsu RunMyProcess Developer Community <suppor...@runmyprocess.com> wrote:

Hi Team,

Any assistance on this issue available yet?

--
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 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/b95332fb-5f8e-4777-9ecd-7e5c2cd84736%40runmyprocess.com.
For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

--

Thanks & Regards

Gunjan Rajgure

Fujitsu - RunMyProcess Support

[Gunjan Rajgure]

Hi There,

Could you please give us feedback on this? 

Awaiting for your response.

Thanks & Regards,

Gunjan Rajgure

Fujitsu RunMyProcess Support

[arman_...@icloud.com]

Hi Gunjan,

Unfortunately no. This would require my query to be set before opening the page. The reason I'm looking to use the apply filter methods is because I want to be able to filter the report dynamically within the page without the user being able to see the columns being used to filter on (in this instance, being pulled from a drop down list).

Regards,

Ben Jones