Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filtering with list variable

Hi,

I know I can use list variable in OnOpen script to set the months I want to have selected with

LET vMonthList = '(1|2|3)';

And using

='$(vMonthList)'

In OnOpen trigger

But I can't seem to get this to work when using filters in NPrinting. I have tried

=$(vMonthList)

='$(vMonthList)'

But I just can't figure the correct syntax to make the list variable work as filter value.

What syntax should I use?

1 Solution

Accepted Solutions
rong
Contributor II
Contributor II

You have to repeat the dimension you need to filter on in the value field.

Here's what I use to filter on the current Posting Quarter (fiscal quarter):

=[Posting Quarter]=vThisFQ

View solution in original post

11 Replies
Stephen_Jasionowski

NPrinting does not support triggers.

In fact the latest release will disable them entirely.

Not applicable
Author

Hi Stephen,

Yes I know I can't use the trigger with NPrinting, it's only used for people viewing the document the reqular way.

I'm using NPrinting filters when creating an HTML report of the document. List variable works as an OnOpen field select trigger, but not as a NPrinting filter.

sunny_talwar

Have you tried this (without dollar sign expansion)?

=vMonthList

avinashelite

Since you have the OnOpen triggers , when the NPrinting open the QVW by default it will apply the filter rite ?? then whats the need to apply it again ??

Not applicable
Author

NPrinting doesn't support triggers, so I need to use the Nprinting Filters functionality.

Not applicable
Author

Doesn't work

I'm using

=$(vDefaultYear)

To select the correct year, and that syntax works for selecting a single year.

avinashelite

You mean triggers will not work when opening the QV document from NPrinting app ??

Not applicable
Author

They will not

harishkumarg
Creator III
Creator III

Hi Mika Lindman

Document OnOpen trigger is working in NPrinting for me. I am using v16.3

As Avinash said NPrinting NSQ will open the QVW and the OnOpen trigger will be set to QVW.

Please let me know if need my sample NSQ and QVW.

Regards

Harish