Question
OCBC
SG
Last activity: 1 Jul 2024 2:49 EDT
Guardrail Warning in Report Definition
Can anyone help me how to fix the below warning:
I have a parametrized Data Page sourced from a report definition which has filters. If no filter is being passed I need to get all the values. However for that I need to uncheck "use null if empty" but that will again add a moderate warning. So I should let it be or create additional report definition and use it as a second source with condition to trigger only if params are empty. There will be no filter in the report definition so no warning, however I will have to create an additional rule.
Accepted Solution
Updated: 1 Jul 2024 2:49 EDT
Rulesstack Private Limited
IN
Hi @Priyanka_Konda,
We have to enable "Use if empty" check box.
Ensure that all filters utilizing a parameter without the "Use null if empty" option selected are provided with the necessary parameter. Otherwise, the filter will be excluded entirely, potentially leading to significantly degraded report performance. To avoid this outcome, opt for the "Use null if empty" option if you prefer a different behavior.
Regards,
Mohd Qizer Uddin
Maantic Inc
IN
Creating another rule only for passing params and keeping the old record without param would still mean the old report will have the warning in both cases, so it makes less sense.