Facing an issue regarding queryentity in expression rule

Question

In a queryentity function, in an interface, I'm getting an error like "Unexpected error executing query (type: [CPVAccountsStatementTrackerDT8331], query:[queryentity expression], order by: [[Sort[FinancialInstitutionOther asc]]], filters:[(firmId = TypedValue[it=1,v=-1)])". How should I resolve this error. In one of filters, we are filtering based on -1 but this is working in some environment while failing at some.

Mike Schmitt · Answer

Then it's definitely timing out when you try to query everything. 
 Also, when a data set is big enough to cause this timeout, you are almost guaranteeing a miserable user experience when anyone tries to use that dropdown. 
 You will likely need to implement at least one of the suggestions mentioned above: either implement a 2-dropdown cascading system (where a first dropdown selects some sort of subset/category, and the second dropdown queries only those items to show), or implement a Custom Picker Field. I don't use Custom Picker Field all that much, but this is one of those times where I almost certainly would.

Stefan Helzle · Answer

This error message typically points towards a timeout issue. 
 And ...

Facing an issue regarding queryentity in expression rule

Top Replies