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)
WorflowWorkitemActionManager- Customizations. - Validation on workflow approval actions in D365 Fno / AX 2012 R3
D365FO Workflow Validation Before Action Execution Workflow Validation Before Executing a Workflow Action in Dynam...
-
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