Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
16 replies
Subscribers
8 subscribers
Views
5276 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hello, I am trying to do a filter the data of an entity and to then aggrega
Adel Ammari
over 9 years ago
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
0
Sidhant Behura
over 9 years ago
@narasimhaadityac - No problem...happens to all...cheers...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Sidhant Behura
over 9 years ago
@narasimhaadityac - No problem...happens to all...cheers...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data