x++ code to Insert Data into Table directly from Query in ax 2012

-

Hello Guys,the below is the process to insert data into table directly from query.

    TestTable   testTable;
    Query         query;
    QueryBuildDataSource    qbds;
    QueryBuildFieldList     qbdfieldList_customer;
    QueryBuildRange         qbr;
    Map                               fieldMappig;

    delete_from testTable;

    query = new Query();
    qbds = query.addDataSource(tableNum(CustTable));
    qbr = qbds.addRange(fieldNum(CustTable,Currency));
    qbr.value('AUD');

    qbdfieldList_customer = qbds.fields();
    qbdfieldList_customer.addField(fieldNum(CustTable,Currency));
    qbdfieldList_customer.addField(fieldNum(CustTable,AccountNum));
    qbdfieldList_customer.addField(fieldNum(CustTable,CustGroup));
    qbdfieldList_customer.dynamic(QueryFieldListDynamic::No);

    fieldMappig = new Map(Types::String,Types::Container);
    fieldMappig.insert(fieldStr(TestTable,customercurrency),    [qbds.uniqueId(),fieldStr(CustTable,Currency)]);
    fieldMappig.insert(fieldStr(TestTable,customeraccountnum),[qbds.uniqueId(),fieldStr(CustTable,AccountNum)]);
    fieldMappig.insert(fieldStr(TestTable,customerGroup),[qbds.uniqueId(),fieldStr(CustTable,CustGroup)]);

    query::insert_recordset(testTable,fieldMappig,query);

Thanks.



Comments

Post a Comment

Popular posts from this blog

x++ code to add hyperlink to a field in D365FO

-
Here is a way to provide hyperlink for field. 1.Create an Extension class to the form as below. [ExtensionOf(formStr(TestHistory))] public final class  TestHistoryForm_Extension { } 2.Copy onPostRun form eventhandler and write code as below.     [FormEventHandler(formStr(TestHistory), FormEventType::PostRun)]     public static void TestHistory_OnPostRun(xFormRun sender, FormEventArgs e)     {         FormStringControl   formCtrl = sender.design().controlName(formControlStr(TestHistory,TestHistory_Voucher));         formCtrl .registerOverrideMethod(methodStr(FormStringControl, jumpRef), methodStr(TestHistoryForm_Extension, JumpRefId), sender);     } 3.write definition for JumpRefId method public void jumpRefId(FormControl _formControl)     {         MenuFunction    menuFunction;       ...
Read more

x++ code to get Vendor Email Address based on Purpose in Dynamics 365 for Operations

-
public static  Email   getVendorEmailAddress()     {               VendTable  vendTable;         DirPartyLocation dirPartyLocation;         LogisticsElectronicAddress elecAddress;         LogisticsElectronicAddressRole elecAddressRole;         LogisticsLocationRole locRole;         Str vendNum;              vendNum='205181';//Vendor Number                 select firstonly  DirPartyLocation                     where dirPartyLocation.party ==  VendTable::find(vendNum).Party//Vendor Number             join   elecAddress                     where elecAddress.Location == dirPartyLocation.Loca...
Read more

x++ code to get Customer Address based on purpose in ax 2012

-
static void  customerAddress(Args _args) {     DirPartyPostalAddressView           dirPartyPostalAddrlocal;     DirPartyLocationRolesView           dirPartyLocationRoleslocal;     LogisticsLocationRole                   logisticsLocRole;     select firstOnly   * from dirPartyPostalAddrlocal order by RecId desc         exists join dirPartyLocationRoleslocal             where dirPartyLocationRoleslocal.Location   == dirPartyPostalAddrlocal.Location                 && dirPartyLocationRoleslocal.Party     ==     CustTable::find(_accountNum).Party//_dirpartyRecid                 //&& dirPartyPostalAddrlocal.IsPrimary == NoYes::No         exists j...
Read more