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
  • @narasimhaadityac, i didn't quite understand what you mean, please elaborate.
    @sikhivahans, i think its just 'my bad', the result "Could not display interface. Please check definition and inputs." is normal as i have not defined any sail components, that explains why i got the answers above. Thanks for your help guys, but i think there is no issue to discuss here.
Reply
  • @narasimhaadityac, i didn't quite understand what you mean, please elaborate.
    @sikhivahans, i think its just 'my bad', the result "Could not display interface. Please check definition and inputs." is normal as i have not defined any sail components, that explains why i got the answers above. Thanks for your help guys, but i think there is no issue to discuss here.
Children
No Data