Finance | Project Operations, Human Resources, ...

How to get only last record in table by using query in AX 2012

(0) Share

Report

Posted on by Rahul.p

632

Hello Friends,

I want to get only last record from table by using query in Ax 2012.

I am using below code.

queryBuildDataSource.addSortField(fieldNum(ABC, RecId), SortOrder::Descending);

By using above code I am getting all records but I want to get only last record.

Please tell me how to get only last record from query.

Thanks & Regards

Rahul

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

Set query.firstOnly1(true) to get just the first record.

And change sort direction to SortOrder::Ascending, therefore the last record will become the first.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

As Martin told you, you can use firstOnly to get only the first record that matches your criteria. Then all you need to do is to adjust your criteria so that the "last" is first.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Small correction on the answer from Martin. It should be set to "descending". www.differencebetween.com/.../

I think Martin intended to use descending as well. He might typed too quickly.

Was this reply helpful? Yes No
Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

No, I did mean Ascending. If we want to to get the last record when using descending sort order (as in the question), we can use FirstOnly and use the opposite sort order (therefore we need to change Descending to Ascending).

If we just take the first record instead of the last, we would get different record than required.

Was this reply helpful? Yes No
ergun sahin 8,826 Moderator on at

Like (0)

Report

I think, Rahul means the last record in the table (bigest RecId), not the last record in the query.

By the way, if you have a createdDateTime-style field for sorting, or a field from a number sequences (continuous), I recommend using it.

Was this reply helpful? Yes No
Martin Dráb 237,878 Most Valuable Professional on at

Like (0)

Report

If the goal is getting the record that was inserted last, then just taking the record with the highest record ID doesn't always do the job (if there is more than one AOS, which should always be the case in production).

Was this reply helpful? Yes No
ergun sahin 8,826 Moderator on at

Like (0)

Report

Yes, RecId is not the right field for sorting. There is no guarantee.

Was this reply helpful? Yes No