Skip to main content
July 23, 2021
Question

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

  • July 23, 2021
  • 3 replies
  • 0 views

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.

    3 replies

    selvakumark
    Participating Frequently
    July 23, 2021

    Hi [mention:387e07c4d183480aa651167ffd17235f:e9ed411860ed4f2ba0265705b8793d05],

    This thread might help you to get some insights

    community.appian.com/.../search-filter-for-textbox-field

    gayathris111098
    July 23, 2021
    stefanhelzle0001
    Brainy
    July 23, 2021

    That is a typical problem with views. You will need to either optimize the view, create a materialized view or create a separate physical table to support he record and search. In Appian you can not do much about that.