X++ Query removing preceeding whitespace from range

(0) Share

Report

Posted on by Dale Thornton

Hi All,

We have a query in AX2012 R2 that needs to filter by a packing slip ID in such a way:

qbdsInventTrans.addRange(fieldNum(InventTrans, PackingSlipId)).value(' 466/Z');

The important part to note is the initial whitespace before 466/Z which should match the value in the database. As soon as the range gets added to the query the whitespace is being removed (I can see its removed from the Query object text while debugging) so the range does not match what is in the database.

How do I configure the query or range so that it does NOT remove the whitespace?

Thanks!

Dale

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Verified answer

Denis Macchinetti 16,444 on at

Like (0)

Report

Hi Dale

Try something like :

qbdsInventTrans.addRange(fieldNum(InventTrans, PackingSlipId)).value("\" 466/Z\"");

Regards

Was this reply helpful? Yes No
Dale Thornton on at

Like (0)

Report

Thanks Denis!! That worked perfectly you're a life saver.

Was this reply helpful? Yes No
Verified answer

Douglas Noel 3,905 on at

Like (0)

Report

Hi Dale,

you should use one of the following methods or built-in functions, if you want to assign a single value to an range

.....value ( queryValue(yourvalue) );

.....value ( SysQuery::value(yourvalue));

they do the complete escaping for you - never assign strings as query value directly, beside you are absolutely sure that they don't need to be escaped

the comma for example has to be escapred, the backslash the leeading blanks and so on...

regards

Douglas

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

in this case you should use StrLtrim() and StrRtrim()

one method we should use always use is QueryValue()

please verify.

Was this reply helpful? Yes No
Suggested answer

Dale Thornton on at

Like (0)

Report

Ah that makes more sense, will be using this solution for sure. Thanks Douglas :)

Was this reply helpful? Yes No
Denis Macchinetti 16,444 on at

Like (0)

Report

Hi Guys

I'm agree with Douglas.

I gave a quick response.

I'm agree in using QueryValue(..) method.

Thanks

Regards

Was this reply helpful? Yes No