Query range not equal to zero

axapta x++ dynamics-ax-2012
RT. picture RT. · May 13, 2014 · Viewed 15.5k times · Source

I'm in AX 2012 R2 environment.

I would like to add a query range to HcmEmployment table and filter out rows that have a LegalEntity value = 0.

The following code fails at runtime with the exception "Invalid Range".

qbrLegalEntity = qbds.addRange(fieldNum(HcmEmployment, LegalEntity));
strRangeCondition = '(%1 != %2)';
qbrLegalEntity.value(strFmt(strRangeCondition, 
                        fieldStr(HcmEmployment, LegalEntity),
                        queryValue("0")));

Is it possible to code this range condition?

Thank you.

Answer

Jan B. Kjeldsen picture Jan B. Kjeldsen · May 14, 2014

Do not make it harder:

qbds.addRange(fieldNum(HcmEmployment,LegalEntity)).value(SysQuery::valueNot(0));

The reason for your failed query expression was the use of queryValue("0") which quotes the zero. Changing that to 0 would work as well, but again too laborious.

And even shorter is:

qbds.addRange(fieldNum(HcmEmployment,LegalEntity)).value('!0');

To diagnose query errors take a look on the SQL generated:

info(qbds.toString());

Related questions

How to invoke a menu item from code in AX 2012

I have some custom code in PurchTable "Register" menuitem's clicked method, Now I need to run the Register command from code after a buttons function has been perfomed. My question is that how can I call the Register command from …

Read More
Multiple values in query range value in Dynamics AX 2012

How to build query with multiple values. I need to create filter which display only active BOMs in grid and I looking for solution. Here is my code which isnt working: public void executeQuery() { QueryBuildRange qbr; QueryRun queryRun; Query q = …

Read More
Refresh entire form in AX 2012?

I'm currently working with a form that has a grid at the bottom. Whenever I hit f5, the grid refreshes, but the rest of the form does not. What can I do to make the entire form refresh it's data? …

Read More