web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) in querybuildrange mul...

Microsoft Dynamics AX (Archived)

in querybuildrange multiple value is not fetching after , seperator

(0) Share

Report

Report

Posted on by Community Member

rangeItemId = this.query().dataSourceTable(tableNum(InventTable)).addRange(fieldNum(InventTable, ItemId));

rangeItemId.value(SysQuery::value(con2Str(element.checkItemAlreadyExistRemove(),',')));

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

multiple values in query range value with "," separator but not fetching the values

Was this reply helpful? Yes No
Ali Zaidi 4,657 on at

Like (0)

Report

For multiple values in query us container. For example

QueryBuildRange qbr = q.dataSourceTable(BOMTable).addRange(fieldNum(BOMTable, BOMId));

container c;

while (...)

{

c+= queryValue(BOMVersion.BOMId);

}

qbr.value(con2str(c));

Other wise use loop to add multiple ranges on same field.

like

QueryBuildDataSource qbds = q.dataSourceTable(BOMTable);

QueryBuildRange qbr;

while (...)

{

qbr = qbds.addRange(fieldNum(BOMTable, BOMId));

qbr.value(queryValue(BOMVersion.BOMId));

}

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans