News and Announcements icon

Dynamics 365 CommunityForums Finance forum compare values in a li...

Finance forum

Unanswered

compare values in a list x++

(1) Share

Report

Report

Posted on by ..

973

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

}

Categories:

Development / Customization / SDK

All responses Img

All responses (1)

Answers Img

Answers (0)

Martin Dráb 228,089 Super User 2024 Season 2 on at

Like (2)

Report
compare values in a list x++

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())); }

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2

Martin Dráb 228,089 Super User 2024 Season 2

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans