aggregation without grouping

I need to create a chart based on a count of OR condition 

I SQL the query is 

 

SELECT count(*)
FROM
v_deco_all
WHERE
predevelopment_specification='TRUE'
OR
subproject_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

Parents Reply Children
No Data