How do I use `select firstOnly` in X++?

Question

How do I use select firstOnly in X++?

Answer 1

SSunny Vasty75 reputation · answered Aug 13, 2026

Use firstOnly when you only need one matching record.

CustTable custTable;

select firstOnly custTable
    where custTable.AccountNum == 'US-001';

if (custTable.RecId)
{
    info(custTable.name());
}

If you only need one row, say that in the query. There is no reason to loop through a result set just to stop after the first record.

1 answer