3 Replies Latest reply on Jun 26, 2012 2:44 AM by Sorbsbuster

    Omitting duplicate values during search or sorting

    PeterThorton

      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?