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
Unexpected error executing query... is mostly due to query timeout. The error is thrown when the query takes more time to retrieve data from database.