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,
The purpose of this blog is for knowledge sharing and connect the relevant audience who are all into Microsoft Dynamics world.
Alfasith AX

اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا
Wednesday, February 25, 2015
Monday, February 23, 2015
Code to print only particular language label for any language environment in AX
Hi,
Code to print only particular language label for any language environment
info(SysLabel::labelId2String2(literalstr("@SYS87980"),"ar"));
Regards,
Code to print only particular language label for any language environment
info(SysLabel::labelId2String2(literalstr("@SYS87980"),"ar"));
Regards,
Subscribe to:
Posts (Atom)
Get a table ID in SQL - D365
Hi select ID from SysTableIdView where SysTableIdView .Name = 'CustTable' Regards,
-
Hi, AccountingDistribution ( accounting distribution 7452 ) AccountingDistributionEventTmp ( accounting distribution 100001 ) Accountin...
-
//< What is GUID> // GUID 16 bit large range of alphanumeric similar to RecID to treat as primary key of a table. static void CreateG...