Query build range on AX X++
QueryBuildRange qbr; * For setting range value we usually use like this qbr.value(“Our Value”); qbr.value(queryValue(“Our Value”)); * For setting range value using SysQuery qbr.value(SysQuery::value(“Our Value”)); qbr.value(SysQuery::valueLike(“Our Value”)); qbr.value(SysQuery::valueNot(“Our Value”)); * For logical NOT qbr.value(SysQuery::valueNot(“Our Value”)); * For retrive all records in usual way we can give like empty (” “) but using sysquery class qbr.value(SysQuery::valueUnlimited()); * For retrive Null records qbr.value(SysQuery::valueEmptyString()); * For retrive Not Null records qbr.value(SysQuery::valueNotEmptyString()); * For giving range usually we add qbr.value(fromDate,toDate) but using sysQuery qbr.value(SysQuery::range(fromDate,toDate); The method will add the dots (‘..’) like this * For finding total number of records available in the...