what is the use of "Search using report definition parameter" option in cell property
what is the use of "Search using report definition parameter" option in cell property.
I added report as source of a drop down and i see this option. Can i know the use of it?
Please see the screen shot attached.
***Edited by Moderator Marissa to update categories***
Accepted Solution
JPMorgan Chase & Company
US
Hi,
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.
BUPA
AU
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.
IN
Hi,
Thanks for the reply but i didn't understand the purpose and diffrenece . We pass params to Report in layout properties as in attached screen shot always. But what is the advantage of this new field.
Can u please explain with screen shot.
IN
Hi Team,
Can i get some detail information on this option.
Most of the time we are not able to find help on new options or features given by Pega. Please provide us support.
Regards
Pavani
Accepted Solution
JPMorgan Chase & Company
US
Hi,
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.
IN
Hi Sudhakar,
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 ?
JPMorgan Chase & Company
US
Yes Pavani, you can pass .Project property, it will be included in where condition and will return only matched records from the database.
Pegasystems Inc.
IN
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.