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
7 replies
Subscribers
7 subscribers
Views
3898 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
How do get back only unique results from a query rule? For example, I'm usi
Chasity Davis
over 10 years ago
How do get back only unique results from a query rule? For example, I'm using a query rule to return back a list of all types of products ordered today. So I query the ORDER table for today's orders, and want to display only the product types. getOrdersByDate(today(),date!pagingInfo) Lets say this query rule returns the following results: Widget, Toy, Shoe, Toy, Widget
How do I get it to only return: Widget, Toy, Shoe...
OriginalPostID-97362
OriginalPostID-97362
Discussion posts and replies are publicly visible
Parents
0
helmuta
over 10 years ago
We always run them separately in two statements like:
Union(abc,abc) stored into !pv
display !pv
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
helmuta
over 10 years ago
We always run them separately in two statements like:
Union(abc,abc) stored into !pv
display !pv
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data