Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
+2
person also asked this
people also asked this
Replies
8 replies
Answers
1 answer
Subscribers
9 subscribers
Views
10544 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
achieving 'select DISTINCT'
paolos1
over 7 years ago
Hello everybody,
I have a CDT/Table 'assets' with the following structure:
idasset (primary,unique)
typeofasset : text
manufacturer : text
model : text
Now I would realize the following query (to be used in a form):
select distinct typeofasset from assets
But in documentation I did not find any connection to clause 'distinct', nor in query rules, neither in querySelection()
I have tried the following workaround (!!!) in file attached:
/* workaround to get unique values */
local!uniqueAssetsAvailables: union(
local!assetsAvailables.data.typeOfAsset,
local!assetsAvailables.data.typeOfAsset
),
Could someone please suggest a better solution? (we are using ver 7.1.0)
Thank you in advance for your help, best regards.
Paolo
OriginalPostID-265665
forum_distinct.txt
Discussion posts and replies are publicly visible