Search using data page parameter for Multiselect property
Hi ,
We have a requirement to attach multiple case I'ds to a case. The property is multi select. So when we are trying to do so , its searching from a huge chunk of data resulting in poor performance.
We don’t have the option to select the value, which the user types in the form, to be passed as a parameter to our DataPage/Report Definition.
This results in very poor performance, as the search is done over the set of all users in the system.
We would like the value that the users types to be passed as a parameter, just like in the Autocomplete control where the option Search using data page parameter exist.
Any suggestions?
virtusa
IN
@AnanyaA2 Apply a 'Starts With' or 'Contains' filter within the report definition and index the searchable database properties to enhance query performance
HCA Healthcare
US
@AnanyaA2 To improve performance for your multiselect property, configure it to filter results dynamically based on what the user types. Use a pxAutoComplete or pxDropdown control and enable the "Search using Data Page parameter" option. Pass the user-typed input as a parameter (e.g., SearchText) to the Data Page or Report Definition, which should be configured to filter data using conditions like CaseID LIKE :SearchText. Ensure the CaseID column is indexed for faster searches. Limit the number of records retrieved by setting a Max Records value in the Report Definition or using pagination in the Data Page. To further optimize, enable caching on the Data Page for frequently accessed data. These steps will reduce the amount of data fetched and processed, improving the search performance for large datasets.