How do I use multiple where conditions in X++?

Question

Answer 1

SSunny Vasty75 reputation · answered Aug 13, 2026

Use && when all conditions must be true.

SalesTable salesTable;

while select salesTable
    where salesTable.CustAccount == 'US-001'
       && salesTable.SalesStatus == SalesStatus::Backorder
{
    info(salesTable.SalesId);
}

Keep the filtering in the query whenever possible instead of returning a bunch of rows and filtering them afterward in X++.

1 answer

Know the solution?