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 resulting query
info(strFmt(“%1”,SysQuery::countTotal(queryRun)));
*   For finding total number of Datasource available in the resulting query
info(strFmt(“%1”,SysQuery::countLoops(queryRun)));
*  For Datasource and Range creation
SysQuery::findOrCreateRange(parameter);
SysQuery::findOrCreateDataSource(parameter);
SysQuery::findOrCreateDataSourceByName(parameter);

Comments

Post a Comment

Popular posts from this blog

this transaction has been marked for settlement by another user

Image
this error because this voucher already  been mark by you or another user. the problem is there many Journal we don't know where the journal line we mark settle with this voucher. the easy way is you can.. 1) Go to AP/Common/Vendors/All vendors.. 2) Select the vendor for which the error is displayed 3) On the Invoice Tab/ click settle open transactions 4) On the "Open transactions form" the transactions which are marked in (!) red are the cause of the error 5) Select the transaction line 6) In "Inquiry" click "specifications" 7) On the "Specifications" form again select the transaction and click "Open Journal form" 8) This will open the related payment journal where this transaction has been marked for payment 9) Open lines 10) Select the related payment line and click "Functions" and select "Settlement" 11) A window will display: "Marked transactions exist. Remove them". ...
Read more

Basic Accounting

Image
In this training lesson, we will study what accounting is, what its main principles are, its terminology, and how accounting is used in a company. The accountingcoach.com is a very good site with clear and concise explanation of Accounting. Let’s assume that Taras goes into the pizza business – namely, cooking and selling pizza. The name of the new company is  The Tastiest . Taras will start his business by putting some of his personal savings into it. In effect, he is buying shares of The Tastiest’s common stock. This is the first initial transaction – the company receives cash but at the same time the company has a debt. Try to illustrate this transaction. First Transaction Imagine a circle which represents the whole company, its left side is the Assets and its right side is the Liabilities. Assets are the things that the company owns and are sometimes referred to as the resources of the company. Liabilities are obligations of the company; they are amounts owed to others. ...
Read more