Advance query filter in Ax 2012

As you know like wildcard operator to filter bunch of record in Axapta grid. In Ax 2012 you can use like wild card operator with query build range object also.


 QueryBuildRange QBR;  
 QBR =SysQuery::findOrCreateRange(DS.dataSourceTable(tablenum(custtable)),fieldNum(Custtable,AccountNum));  
 QBR.value(SysQuery::valueLikeAfter(testTxt.text()));  

In above example we used value like after same way you can use valuelike also.

Other you can use like SysQuery::valueUnlimited if there is no value for range purpose.

No comments: