Hello, I am trying to do a filter the data of an entity and to then aggrega

Hello,
I am trying to do a filter the data of an entity and to then aggregate that data in a report. Below is the code and its result, please advise:

a!queryEntity(
entity: cons!cons_HRES_EmployeeSatisSurvery_DSE,
query: a!query(
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(field: "EMP_DEPARTMENT", operator: "in", value: { " HR", "IT","Legal" })
}
),
aggregation: a!queryAggregation(
aggregationColumns: {
a!queryAggregationColumn(
field: "EMP_LOCATION",
isGrouping: true
),
a!queryAggregationColumn(
field: "PID",
aggregationFunction: "COUNT"
)
}
),
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: -1,
sort: a!sortInfo(
field: "PID",
ascending: false
)
)
)
)

Output:
Could not display interface. Please check definition and inputs.

...

OriginalPostID-195705

OriginalPostID-195705

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data