preloader-matrix

Alfasith

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,

Share on email
Share on facebook
Share on twitter
Share on linkedin
Share on pinterest

Leave a Reply

Your email address will not be published.