Question
Populating a dynamic Operator(greater than,less than ,equal,etc..)
Hi all,
i have two question
1.can we select the dynamic operator :
for eg : if(1 ri!operator 2,"if true","if false")
where operator will belike {">=","<","=",etc..} . which user select from site
2. can apply a query filter on an aggregated column
eg:
a!query(
aggregation:
a!queryAggregation(
aggregationColumns:
{
a!queryAggregationColumn(
field: "zipcode",
isGrouping: true
),
a!queryAggregationColumn(
field: "caseId",
alias: "caseId_count",
aggregationFunction: "COUNT"
)
}
),
logicalexpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "caseId_count",
operator: "<",
value: 3
)
},
ignoreFiltersWithEmptyValues: true
)