We have one record type on database View.
Record type is configured with Filter applied to 3 columns only i.e. "Limit search to selected fields"
GRID with Record type source is showing Data with paging=50 in UI and able to see data in next page as well.
User sees data with some mandatory Input filter on selected column.
GRID is configured with showSearchBox option. Now if user is entering some value in default searchbox(this value is applied with the record filter configuration which is again on 3 columns) with record type then getting below error-
An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit.
I need to understand the sequence of the search value applied to the data-
1- Will this apply to whole data(10000 rows) available to view without any User mandatory filter or only to the data coming in the Grid(with user filter applied) for e.g. 2000 rows(with pagination 50 per page)
Discussion posts and replies are publicly visible
Any search is always applied including any selected filter. In combination with a view in the database, this is a notoriously known scenario to cause performance issues. You will have to find a way to speed up that database view.
Hi piyusha6151 Did you apply indexes on your database columns? If not, Could you create indexes on your columns and try them?