How to use "Search using report definition parameter" option in cell property.
I am trying use Search using report definition parameter can u please help me in the configuration. Please see the attached screen shot.
Pegasystems Inc.
US
Hi Pavani,
I had created a sample use case regarding your requirement with an explanation and you can have a look into it. Hope it might be clear to you about this concept.
Regards
Mahesh
IN
Hi Mahesh,
Thanks for your clear explanation, but i was trying to understand the use of "Search using report definition" option in section. I could not see that option in the document you shared. Please help. Did i miss anything
Pegasystems Inc.
US
@Pavani, i had re-implemented the your use case with the report definition rule with a sample use case and you can look into it.
IN
Thanks for your time and efforts mahesh.
Just want to understand a little more about this feature. So when we use this option dont we pass any param value? Is it like it pulls everything from DB . No use of where clause? As we are not passing any value to Param.
Also can you please explain what you meant "Here I am using the auto complete field value to Name parameter for the report definition" in the document.
Pegasystems Inc.
US
@Pavanir, if you look into the Auto complete field properties screen shot in my document for Name parameter in the report definition "Use for SEARCH" checkbox is selected which means the Autocomplete field value will be passed to the Name parameter in the report definition. That is the reason the results are being filtered based on the where clause. Try to do the similar configuration and enter the specific record field value then list will be filtered to display only that record, in my scenario i use Starts with filter criteria hence it is showing all the records which are started with the entered text. Let me know if you still has any doubts.
JPMorgan Chase & Company
US
Hi,
The attached document Autocomplete using Report Definition.pdf has clear steps to implement, do you have any questions on this ?. Results are filtered by entered value in autocomplete box, you can trace it and try to extract the database query.