cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Can multiple report filters be used for one report?

I have a DocGen that is run from the account page using multiple Salesforce reports, each with a filter on the <<Account_External_Reference>> (using pv0=), is it possible to add an either/or filter? ie filter on <<Account_External_Reference>> or <<Account_Parent_External_Reference>>

Labels: (1)
0 Kudos
Reply
3 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: Can multiple report filters be used for one report?

@Lou Yes this is possible, below is a couple useful parameters and an example.

  • To set filter logic use bool_filter= (can use AND/OR logic to apply to filters)
    Use "%20" instead of spaces.
  • To set filter values use pv0= (or pv1, pv2, ...)
  • To set filter operators use pn0= (or pn1, pn2, ...)
  • Arguments for pn#:

eq = equals
ne = not equals
lt = less than
le = less than or equals
gt = greater than
ge = greater than or equals
co = contains

For example: bool_filter=1%20and%20(2%20or%203%20or%204)and%205&pn1=gt&pn2=gt&pn3=gt&pv1=>&pv2=>&pv3=>&pv4=!param1

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: Can multiple report filters be used for one report?

Hi Leigh, this helps but unfortunately I am hindered by the way the data is structured as there are lots of blanks. Not every case has both the account or parent account reference fields populated so I also need to eliminate blank records.
0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: Can multiple report filters be used for one report?

@Lou You should be able to add filtering to the report to remove blanks. Alternatively does it need to be a report, you could look at using a relationship and that may be easier to filter.

0 Kudos
Reply