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 Mike Schmitt over 4 years ago

What's your use case? There are fairly easy ways to de-duplicate data post querying, or to aggregate data during a query, but importantly, Appian queries don't really work like SQL statements.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Reply

0 Mike Schmitt over 4 years ago

What's your use case? There are fairly easy ways to de-duplicate data post querying, or to aggregate data during a query, but importantly, Appian queries don't really work like SQL statements.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel

Children

No Data