While Select statement and Containers

(0) Share

Report

Posted on by Community Member

Is there any way Containers can be used in a while select statement? This is what I want to achieve:

Container Items;
PurchLine purchLine;
int i;
;
Items = [9109-0018,9109-0019,9109-0022,9109-0025];

for (i=1; i <= conlen(Items); i++)
{
while select PurchId from purchLine
where purchLine.ItemId == conpeek(custTransCont, i)
{

info(purchLine.PurchId);
}
}

But AX won't let me compare the value grabbed from conpeek. I guess it cannot... but wondering if you gents got any solution for it? Maybe I am not thinking it through

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

André Arnaud de Cal... 301,037 Super User 2025 Season 2 on at

Like (1)

Report

Hi Khosla,

You can create a variable where you first store the Item from the container. This variable can be used in the select statement as workaround, so try this:

Container Items;

PurchLine purchLine;

ItemId itemId;

int i;

;

Items = [9109-0018,9109-0019,9109-0022,9109-0025];

for (i=1; i <= conlen(Items); i++)

{

itemId = conpeek(custTransCont, i);

while select PurchId from purchLine

where purchLine.ItemId == itemId

{

info(purchLine.PurchId);

}

}

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Oh my god, I feel so dumb.

Thanks!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I don't understand but where did the custTransCont come from?

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

Like (0)

Report
Note that the code is quite inefficient, because it executes a database query for each item in the container. A better approach would be constructing a query with several ranges and running it once. Like this:

Query q = new Query(); QueryRun qr; QueryBuildDataSource ds = q.addDataSource(tableNum(PurchLine)); ds.addSelectionField(fieldNum(PurchLine, PurchId)); for (i = 1; i <= conlen(items); i++) { itemId = conpeek(items, i); ds.addRange(fieldNum(PurchLine, ItemId).value(queryValue(itemId)); } qr = new QueryRun(q); while (qr.next()) { PurchLine purchLine = qr.get(tableNum(PurchLine)); info(purchLine.PurchId); }

By the way, I would avoid containers unless there is a good reason for using them. A set of strings would be a good alternative in this case.

Was this reply helpful? Yes No