Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Wednesday, February 25, 2015

QueryDataSourceLink in AX

Hi,

static void AlfasithQueryDataLink(Args _args)
{
    Query                   query;
    QueryBuildDatasource    datasource;
    ;

    query = new Query();

    datasource = query.addDataSource(tableNum(CustInvoiceJour));// Add Parent table

    datasource = datasource.addDataSource(tableNum(CustInvoiceSalesLink)); // Add child table

    datasource.joinMode(JoinMode::InnerJoin);       // Mode of join

    datasource.relations(false);        // Indicate you don't want to use relations DynamicLink

 
    datasource.addLink(fieldNum(CustInvoiceJour, SalesId),
        fieldNum(CustInvoiceSalesLink, SalesId));     // Add link between parent field and child field

    info(query.xml());
}

Regards,

No comments:

Post a Comment

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...