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,