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
5277 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
0
sikhivahans
over 9 years ago
@adela Not a problem.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Adel Ammari
over 9 years ago
Guys, what does this translate to in English?
if(rule!APN_isBlank(times!input),{},a!queryFilter()) its my 1st time to see the type times!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Sidhant Behura
over 9 years ago
@adela - I also had that doubt ... But I guess its a typo or auto-correct may be ..
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 9 years ago
@adela/@sidhantb It isn't times! but it's ri!. And it's a typo. @narasimhaadityac is trying to say with his example that you can define query filter(s) based on the availability of input. That is, if the value of the input is null, the filter won't be applied.
Also just to let you know, there isn't any context such as times!.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
narasimhaadityac
A Score Level 2
over 9 years ago
Hi Adela, sorry I did not realize that the ri! Translated as I was tying that message in mobile.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
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
<