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
As already mentioned here, in most of the cases this is caused by a timeout.
Yes, we found the timeout in our situation, we manage to make the processing time smaller on the view, from 22 seconds to 0.5 seconds, but the error message is the same.