AnsweredAssumed Answered

Omitting duplicate values during search or sorting

Question asked by PeterThorton on Jun 24, 2012
Latest reply on Jun 26, 2012 by Sorbsbuster

Title

Omitting duplicate values during search or sorting

Post

Hello,

is there a way to chuck away records with duplicate values during sorting or searches?

I'm making a report that should contain all the products ordered within a given month. I have a found set of ProductIDs from all the OrderItems in all Orders executed in the month. I want to get a list of products. For example, the set could look something like this

 

7, 9, 4, 1, 2, 9, 3, 4, 2, 5

and the result I need to achieve in a script, either by sorting or searching, or by combination of thereof, would be:

1, 2, 3, 4, 5, 7, 9

Should be pretty easy, right?

Outcomes