Simple x++ query with enum value range

static void queryEnumValue(Args _args)
{
    Query                   query;
    QueryRun                queryrun;
    QueryBuildDataSource    qbds;
    QueryBuildRange         qbr;
    PurchTable              purchTable;
    ;
   
    query = new Query();
   
    qbds = query.addDataSource(tableNum(PurchTable));
    qbds.addSortField(fieldNum(PurchTable, PurchId), SortOrder::Ascending);
    qbr     = qbds.addRange(fieldNum(PurchTable, PurchStatus));
   
    qbr.value(enum2str(PurchStatus::Received));
   
    queryrun = new QueryRun(query);
   
    while(queryrun.next())
    {
        purchTable = queryrun.get(tableNum(PurchTable));
       
        info(strFmt("%1", purchTable.PurchId));
    }
}

Comments

Post a Comment

Popular posts from this blog

Create record in inventdim table through code X++ in ax 2012

Hi , Today I am going to tell you how to create record in inventdim table through code. In InventDim Table we cant use .insert() method for creating record. As it is very important table and hit many transaction so it is recommended not to play with this table unless it is not necessary. may be it cause data in consistancy. But as like me if you have to do with this table you can use below code at your own risk. Its is working code for sure.  ttsBegin;         item = InventTable::find(ItemId);                  // Item id = "Item-0001"         inventdim.InventSiteId          = Site;              // Site = "Site1"         inventdim.InventLocationId      = Location;  // Location = "Location1"         if(item.colorActive())       ...
Read more

Code to import Employee Master data in ax 2012 R3 x++

Hello , Here I am sharing with you the code to import the Employee Master data in ax 2012 R3. I have used this code for one of my Saudi Arabian client so some line would be new for you. Customize the code as per your requirement. Hope it will help you thanks :) ------------------------------------------------------------------------------------------------------------ static   void  ImportWorkerthruExcel(Args _args) {     SysExcelApplication xlsApplication;     SysExcelWorkBooks xlsWorkBookCollection;     SysExcelWorkBook xlsWorkBook;     SysExcelWorksheets xlsWorkSheetCollection;     SysExcelWorksheet xlsWorkSheet;     SysExcelRange xlsRange;     SysExcelCells Cells;     SysExcelCell RCell;     CommaIO inFile;      int  nRow,i;     DialogField dialogPath;   ...
Read more

Post product receipt for registered quantity x++, Ax 2012

public void Run() {     PurchFormLetter             purchFormLetter;     PurchFormletterParmData     purchFormLetterParmData;     PurchParmUpdate             purchParmUpdate;     PurchParmTable              purchParmTable;     PurchParmLine               purchParmLine;     PurchTable                  purchTable,purchTable1;     PurchLine                   purchLine;     InventTrans                 inventTrans;     InventTransOrigin           inventTransOrigin;     PurchId                     purchId;     Num     ...
Read more