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, ... compare values in a li...

Finance | Project Operations, Human Resources, ...

Unanswered

compare values in a list x++

(1) Share

Report

Report

Posted on by ..

2,017

Hi,

let's say i have a sales order with 5 lines.
And let's say i have a list in my custom service that contains 3 of those lines.

i need to determine that there are two extra lines in the order and delete them, how to do that?

So i want sth like this:

While select salesLine where salesLine.SalesId = _salesId && salesLine.RecId != 'Any of the recIds in the list'

{

delete this salesLine

}

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Martin Dráb 240,538 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
A better approach is using Query* classes. In your code, you can't dynamically add a range for every entry in the list, but iterating the list and calling QueryBuildDataSource.addRange() is trivial. For example:
ListEnumerator enumerator = list.getEnumerator(); while (enumerator.moveNext()) { qbds.addRange(...).value(SysQuery::valueNot(enumerator.current())); }

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

Martin Dráb 345 Most Valuable Professional

#2

CU10121822-0 304

#3

André Arnaud de Cal... 283 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