how to customize filter when user search keyword search bar in Record .

Certified Senior Developer

Hi All,

We have entity backend records based out of DB view and using a!recordData in the grid to display the record list

When a user uses a record search bar to search a keyword, we are getting errors ""An error occurred while retrieving the data for "Record Name". Details: unexpected error executing query" . Looking at the logs, we figured out keyword searches against all columns defined view it impacts query execution time. This issue occurred recently as the volume of data increased.

  Is there any way to customize or pass a minimum number of the query filter in the record on the search bar? Currently, we are also working on the DB view optimization.

  Discussion posts and replies are publicly visible