I need to create a chart based on a count of OR condition
I SQL the query is
SELECT count(*)FROM v_deco_allWHERE predevelopment_specification='TRUE'ORsubproject_type='PRED'
But I can't because it is mandatory to add the grouping field ...
I am using
aggregationColumns: { a!queryAggregationColumn( field: "ID", /*alias:"ID",*/ aggregationFunction: "COUNT" ),
and the filter
logicalExpression: a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter( field: "PredevelopmentSpecification", operator: "=", value: "TRUE" ), a!queryFilter( field: "SubprojectType", operator: "=", value: "PRED" ),
Discussion posts and replies are publicly visible