Query extended range failure: Right parenthesis expected near pos 0. this error is appearing.

(0) Share

Report

Posted on by Community Member

hello masters,

i have created a query (below) and when i run it .it gets this error(Query extended range failure: Right parenthesis expected near pos 0. )

q = new Query();
qbds = q.addDataSource(tableNum(InventItemGroupItem));
qbds.name('ItemGroupMaster');
qbds.addRange(fieldNum(InventItemGroupItem, ItemId)).value(strFmt('((%1.%2 == "DAPJCON0001") || (%1.%3 == IG08))',
qbds.name(), fieldStr(InventItemGroupItem, ItemId),
fieldStr(InventItemGroupItem, ItemGroupId)));

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

Mea_ 60,286 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi Kavaljeet Singh,

Try this

qbds.addRange(fieldNum(InventItemGroupItem, ItemId)).value(strFmt('((%1.%2 == "DAPJCON0001") || (%1.%3 == "IG08"))',
qbds.name(),
fieldStr(InventItemGroupItem, ItemId),
fieldStr(InventItemGroupItem, ItemGroupId)));

So you forgot to put "" around IG08

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

Like
a
(2)

Report
Copy link

Link copied!

Crispin, the extra parentheses are necessary for the extended query range syntax. In your case, AX would simply look for ItemId with the given value ("InventItemGroupItem.ItemId == ..."), it wouldn't interpret it as SQL.

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

@ievgen Thanks you got it write, you spotted the mistake.

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

@Martin thanks for the reply.

Can u suggest more about Extended query range

Was this reply helpful? Yes No
Mea_ 60,286 on at

Like
a
(1)

Report
Copy link

Link copied!

There is a good article explaining how to use them www.axaptapedia.com/Expressions_in_query_ranges

Was this reply helpful? Yes No
Community Member on at

Like
a
(0)

Report
Copy link

Link copied!

this is the same article Martin has suggested

Was this reply helpful? Yes No