Multiple Sorting Columns for lookups

Discussion created by Stephen_W on May 20, 2011
Latest reply on May 31, 2011 by Chris_Hackett
Is there a way to have multiple "Sorting Columns" when we are creating a new lookup? We have created the SQl and NSQL into Clarity but our issue lies in the layout of the results when we have it as a lookup. In our regular sql, we have the end an ORDER BY ex. level1, level2, level3, level4.

In the newly created lookup though we are forced to specify a default sorting column but we are limited to only select 1 column (level 1, or level2 etc..) which throws off our results layout. We cannot use ID either since we do not want it sorted by the creation date of each row. So how can we do multiple order by/sorted columns when we create a new lookup?