Hi I have written this query to fetch result based on two filter criteria. When I am passing either of employeeId or Created by it throws the following error. But if I pass both employeeId and CreatedBy it works properly. Can anyone help as in what is wrong in this?
The error:
The code:
rule!NGS_queryEntityRefresh( dataStoreEntity: cons!NGS_DSE_QPP_PERFORMANCE_TRACKER, returnType: ri!returnType, executeWhen: ri!executeWhen, queryLogicalExpression: a!queryLogicalExpression( operator: "OR", logicalExpressions: { a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "employeeId", operator: "in", value: ri!employeeIds, applyWhen: not(rule!NGS_isBlank(ri!employeeIds)) ), a!queryFilter( field: "discussionTopicRefId", operator: "in", value: ri!discussionTopicRefIds, applyWhen: not(rule!NGS_isBlank(ri!employeeIds)) ), a!queryFilter( field: "discussionSubtopicRefId", operator: "in", value: ri!discussionSubtopicRefIds, applyWhen: not(rule!NGS_isBlank(ri!employeeIds)) ), a!queryFilter( field: "date", operator: ">=", value: ri!startDate, applyWhen: not(rule!NGS_isBlank(ri!employeeIds)) ), a!queryFilter( field: "date", operator: "<=", value: ri!endDate, applyWhen: not(rule!NGS_isBlank(ri!employeeIds)) ), a!queryFilter( field: "isActive", operator: "=", value: true, applyWhen: not(rule!NGS_isBlank(ri!employeeIds)) ), a!queryFilter( field: "followUpStatusRefId", operator: "in", value: ri!followUpStatusRefId, applyWhen: not(rule!NGS_isBlank(ri!employeeIds)) ) }, ignoreFiltersWithEmptyValues: true ), a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "discussionTopicRefId", operator: "in", value: ri!discussionTopicRefIds, applyWhen: not(rule!NGS_isBlank(ri!createdBy)) ), a!queryFilter( field: "discussionSubtopicRefId", operator: "in", value: ri!discussionSubtopicRefIds, applyWhen: not(rule!NGS_isBlank(ri!createdBy)) ), a!queryFilter( field: "date", operator: ">=", value: ri!startDate, applyWhen: not(rule!NGS_isBlank(ri!createdBy)) ), a!queryFilter( field: "date", operator: "<=", value: ri!endDate, applyWhen: not(rule!NGS_isBlank(ri!createdBy)) ), a!queryFilter( field: "isActive", operator: "=", value: true, applyWhen: not(rule!NGS_isBlank(ri!createdBy)) ), a!queryFilter( field: "followUpStatusRefId", operator: "in", value: ri!followUpStatusRefId, applyWhen: not(rule!NGS_isBlank(ri!createdBy)) ), a!queryFilter( field: "createdBy", operator: "in", value: ri!createdBy, applyWhen: not(rule!NGS_isBlank(ri!createdBy)) ) }, ignoreFiltersWithEmptyValues: true ) } ), pagingInfo: ri!pagingInfo, fetchTotalCount: true)
Discussion posts and replies are publicly visible
This points towards a performance issue resulting in a timeout. The tomcat stdout log file will get you the details.