630
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
Yes, RecId is not the right field for sorting. There is no guarantee.
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).
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.
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.
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (