3 Replies Latest reply on May 13, 2013 12:29 PM by Eric Munisteri

    How do I sort by group then by date (oldest date first)?

    Eric Munisteri

      I have a direct connection to a SQL DB View.  I need to display the data (and export to csv) so that it is sorted by the name of a device, then by the date it was accessed and by whom.

      Device B      2/6/2012     Person A

      Device A     1/1/2012      Person A

      Device B     12/12/2011  Person A

      Device A     3/2/2012      Person A

      Device A     1/29/2013    Person D

      Device B     12/10/2010  Person C

      Device B      1/16/2013   Person F

      Device A     12/6/2011    Person B

      etc.

       

      Need the output to be in this order:

      Device A     12/6/2011    Person B

      Device A     1/1/2012      Person A

      Device A     3/2/2012      Person A

      Device A     1/29/2013    Person D

      Device B     12/10/2010  Person C

      Device B     12/12/2011  Person A

      Device B      2/6/2012     Person A

      Device B      1/16/2013   Person F

       

      I can sort by the Device Name Alphabetically, but I have not been able to then sort by the date with the oldest date for each group at the top.