How to set bool_filter (Filter By Logic) to make only one out of 2 filters to apply in Reports

Question

Currently I have 2 filters in Report but according to business logic I have to navigate to report from a visualforce page and have to apply only 1 filter out of 2 based upon some logic.

So, as bool_filter in URL is not accepting only 1. Like if there are two filter 1 and 2. bool_filter needs to have both 1 and 2 in logic. if we write simply 1 it will not take it.

So, currently I have written bool_filter as 1 OR (2 AND NOT(2)) and vice versa for 2.

But this does not sound appropriate to end client.

So, is there any other method to do so by URL parameters?

Marko Lamot · Answer

You want to apply filter to be   1 and not 2   or    2 and not 1  ?   Well then it could be something like   OR(1 AND NOT(2),2 AND NOT(1)).

How to set bool_filter (Filter By Logic) to make only one out of 2 filters to apply in Reports

Reports & Dashboards

関連学習

さらにヘルプを表示