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...

Discussion posts and replies are publicly visible

Parents

0 Chasity Davis over 10 years ago

Well, it doens't appear to be working within my paging grid. I'm doing the following and nothing appears. However when I remember the union I get results, but with my duplicates. Thoughs?
=union(rule!SO_CA_GetHoldingsBySecurityByCADetailsID(pv!caEventDetails.caDetailsId,data!pagingInfo),rule!SO_CA_GetHoldingsBySecurityByCADetailsID(pv!caEventDetails.caDetailsId,data!pagingInfo))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Chasity Davis over 10 years ago

Well, it doens't appear to be working within my paging grid. I'm doing the following and nothing appears. However when I remember the union I get results, but with my duplicates. Thoughs?
=union(rule!SO_CA_GetHoldingsBySecurityByCADetailsID(pv!caEventDetails.caDetailsId,data!pagingInfo),rule!SO_CA_GetHoldingsBySecurityByCADetailsID(pv!caEventDetails.caDetailsId,data!pagingInfo))
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data