Scenario: I have 8 parameters defined in report definition, and used the parameters in filter condition with AND between all. Same parameters are passed from data page to report definition.
data page is called from decision tree. In multiple if conditions of decision tree, can I skip passing parameters to data page(and hence to report definition)? if I skip passing paratmers, how does the AND filter condtiion work in report definition?
will the query search for skipped parameters = NULL when querying database or just wont be included in the query filter conditions?
***Edited by Moderator: Pooja Gadige to move from Pega Academy to Product, add product details tag, add capability tags***
If you configured as "Use null if empty" then skipped parameters will be executed as Where ColumnName = NULL if "Use null if empty" is unchecked then execution wont include columns in where clause if passed empty.