Hi Leo,

Although LabKey SQL allows ORDER BY clauses, primarily for inner queries, the outermost sort is usually determined by explicitly passing in a sort parameter instead of using the ORDER BY. Ideally, we'd use the ORDER BY in the query as the default sort, and allow further sorting based on sort parameters, but for now I'd recommend removing the ORDER BY and using the config.sort property. I assume you're using LABKEY.Query.executeSql().

Thanks,
Josh