Pega has provided this option to display reduced data set if RD parameter values are provided while configuring the layout properties. System will execute the RD with the parameter values provided underlined.
Search using report definition parameter should we used when you want the filtering in the grid to be done by the query rather than in memory. The filtering value specified will be passed to the underlying query and the SQL WHERE clause is modified to add this explicit condition and a reduced result set is returned to be displayed by the grid.
Thanks for your reply. So my understanding is as below.
Lets say i have a report which displays employees and their Projects. Now a user can filter on the repeat grid on Project field. So when he select a project by using this new option "search using report param" i can query in DB and get only That specific project details right?.
If yes, user filters on a property ".Project" then should i pass this as param ?
Lets say this option "Search using report definition parameter" is unchecked and "Use for search" checkbox is checked for fields in Search results configuration. In this case, we get all the results of report definition(with parameters passed if any) from database and results are filtered while they are displayed based on whatever is entered in input.
Whereas in other configuration if "Search using report definition parameter" is selected, results are filtered from database. The value typed in the input is passed as param to the field for which "Use for search" is checked.