a!queryEntity() how to select distinct

satyaprataps over 4 years ago

Is there any property in the a!queryEntity to select distinct values from a DB table.

Discussion posts and replies are publicly visible

Top Replies

Timo over 4 years ago +2
A Score Level 2

a!queryAggregation( aggregationColumns: { a!queryAggregationColumn( field: "distinctColumn", isGrouping: true ),
Stewart Burchell over 4 years ago +1
Appian Employee

Just to follow up on Mike's comment...there are a number of set-processing functions that you can use in Appian to post-process the retrieved data. fn!union() is the one that would de-duplicate your data…

Parents

0 Timo
A Score Level 2
over 4 years ago

a!queryAggregation(
aggregationColumns: {
a!queryAggregationColumn(
field: "distinctColumn",
isGrouping: true
),
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Timo
A Score Level 2
over 4 years ago

a!queryAggregation(
aggregationColumns: {
a!queryAggregationColumn(
field: "distinctColumn",
isGrouping: true
),
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data