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

اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا
Subscribe to:
Post Comments (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...
No comments:
Post a Comment