Hi All,
When trying to filter using a dropdown, getting below error:
Do not see any error in the backend, data store is published successfullyalso there are less than <10 records in the database so dont think of performance issue. please advise in which logs can I check this error to debug:
Expression evaluation error [evaluation ID = abc7a:61357] in rule 'rmo_rule_getticketqueueview' (called by rule 'rmo_frm_ticketqueue') : An error occurred while retrieving the data. Details: Unexpected error executing query (type: [RMOVWticketQueueDT29056], query: [queryentity expression], order by: [[Sort[implementerStatusPriority asc], Sort[isSameDayImplReq desc], Sort[cutOffTime asc], Sort[urgency desc], Sort[ticketTypePriority asc], Sort[slaDateTime asc], Sort[ticketId asc]]], filters:[((status in TypedValue[it=103,v={RS20}]) AND (isWithdrawn is null) AND ((isGLConfirmed is null) OR (isGLConfirmed = TypedValue[it=1,v=1])) AND ((isConfidential = TypedValue[it=1,v=0]) OR ((isConfidential = TypedValue[it=1,v=1]) AND (submittedBy = TypedValue[it=4,v=manakumar])) OR ((isConfidential = TypedValue[it=1,v=1]) AND (roleAssigned = TypedValue[it=3,v=ET27])) OR ((isConfidential = TypedValue[it=1,v=1]) AND (submittedBy = TypedValue[it=4,v=manakumar]) AND ((roleAssigned = TypedValue[it=3,v=ET25]) OR (parentRoleAssigned = TypedValue[it=3,v=ET25])))))])
Discussion posts and replies are publicly visible
Hi Manam,
Sounds like a timeout which is unusual with the number of records in your view.
How long does the query take to execute before you see that error?
How many tables are included in the joins of your view?
How many rows do the source tables have for your view?
If your source tables have many rows you may have to evaluate the indexes you have/don't have in order to optimise the query filters you have.