How do I use `order by` in an X++ select statement?

Question

How do I use order by in an X++ select statement?

Answer 1

SSunny Vasty75 reputation · answered Aug 13, 2026

Use order by before the where clause.

SalesTable salesTable;

while select salesTable
    order by salesTable.CreatedDateTime desc
    where salesTable.CustAccount == 'US-001'
{
    info(salesTable.SalesId);
}

You can order by multiple fields too:

while select salesTable
    order by salesTable.CustAccount, salesTable.CreatedDateTime desc
{
}

If you do not specify asc or desc, X++ sorts ascending.

1 answer

Know the solution?