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.
Discussion posts and replies are publicly visible
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.