I have create a record type using a view, Which has more than a million data.But in performance im getting the below error "Expression evaluation error [evaluation ID = a8853:4ed82] at function a!recordList_ui_design: An error occurred because the record types source is currently unavailable, or the query reached a timeout or memory limit.. (APNX-1-4198-000)"
Discussion posts and replies are publicly visible
Ant the question is? Seems that you are having a timeout or memory problem with that query......
Your view is too slow. Make it faster
That could mean adding indexes on the some of the underlying tables. You could also consider doing a materialized view:
community.appian.com/.../use-database-and-materialized-views-in-appian
Hi I had created a materialized view on top the same view which i used, this solved my issue.im refreshing MV every 15 min.