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
![Alfasith AX](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjFCsBSvNUtph5BS_nBvcdYm3YaVG0GBnQAKHbEDjqE6z_HSUuYknE01DBZJCjjZxnvlKVLIXUnkqSVygmTlAQxCn5aR4l7RDLMKbs_VZyTLs_habcFKCCjTzswligQdQWU0UvXXVUt5t4p/s1190/workaholic-hand-typing-keyboard-dark-late-night-with-computer.jpg)
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا
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...
-
Hi, Create a EDT name it Gender then in properties enumType : //select the enum name Use the below code and enjoy. static v...
No comments:
Post a Comment