Report filter condition
Hi,
My report definition have 3 filters. Ex: A, B, and C. I have a requirement to filter the report based on any one of the filter( A or B or C) or by using any two(A and B or A and C or B and C) or by using all three(A and B and C).
Can anyone please suggest how to write this logic in one report?
Pegasystems Inc.
IN
Hi @MEERAP37,
Have you tried updating the filter logic as per the requirements? The below articles may help.
https://docs-previous.pega.com/reporting/84/editing-filter-logic
https://docs-previous.pega.com/reporting/87/adding-filter-conditions
You can also update the same using DEV Studio > Report Definition > "Edit filters" section.
Hope this helps!
Thanks
Dipti Aggarwal
NCS Pte. Ltd
SG
Hi @MEERAP37: Can you help to understand whether your condition will be always AND if you need to search with more than one filter? If so you just pass the respective filter values and make sure use null if not empty is unchecked in the filters. In this case if a filter value is not passed, the filter condition itself will be ignored. So if 1 filter is passed it will use only 1, if both A and B is passed it will use both, and so on. This will workout only when your condition in logic is fixed.
If you want to change filter logic condition itself, you need to give the repot access to users so that they can use edit report to change conditions.
Thanks