web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... select first only and ...

Finance | Project Operations, Human Resources, ...

Answered

select first only and select query in x++

(2) Share

Report

Report

Posted on by CU10121822-0

698

Hi team,

I have a query. Is both “select first only” and “select” query is return the first record only without where condition?

1.

CustTable custTable;

select firstOnly custTable;

if (custTable)
{
info(strFmt("Account number: %1", custTable.AccountNum));
}

2.

select custTable;

if (custTable)
{
info(strFmt("Account number: %1", custTable.Accountnum));
}

Note- I don't have system access so unable to check it.

Pls advise, thanks

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Sort by

Verified answer

Subra 1,934 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @CU10121822-0

When you use select firstonly keyword in your select query it will optimize the SQL query in the backend like it will look only for Top (1) record. If we doesn't use the keyword the query is not optimized.

Thanks,
Subra

Was this reply helpful? Yes No
CU10121822-0 698 on at

Like (0)

Report
Copy link

Link copied!

Hi Subra, based on my above examples pls explain what it will return .
thanks

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 306,587 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,
In your first statement, the SQL server will return only one record as Subra mentioned. It will be translated to return top 1.
The second statement is bad coding. This will return all records from the CustTable. The focus will be on the first record. The issue here is related to performance. Returning one record is way faster than returning a set of all records.
Your examples will have the same result, but the difference is performance.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 305 Super User 2026 Season 2

#2

Martin Dráb 281 Most Valuable Professional

#3

Anton Venter 266 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans