Today, I will be discussing about one of the common issue related to query creation using query build data source.
Let's suppose we have following tables.
- Leave Assignment table - (Base Table) - Namely Parent for demo purpose
- HcmEmployment table - Namely Child 1 for demo purpose
- Leave Plan table - Namely Child 1 for demo purpose
We want to link base table with both hcm employment (child1) and leave plan table (child2) using query build data source. Below is the code used for performing this operation.
public QueryRun fetchMultipleTableQueryDemo()
{
QueryBuildDataSource hcmEmploymentds;
QueryBuildDataSource qbds;
Query query = new Query();
// Adding parent as a datasource
QueryBuildDataSource qbds = query.addDataSource(tableNum(Parent));
// Adding child 1 as a datasource
hcmEmploymentds= qbds.addDataSource(tableNum(Child1));
hcmEmploymentds.joinMode(JoinMode::InnerJoin);
hcmEmploymentds.addLink(fieldNum(Parent, Worker),fieldNum(Child1, Worker));
hcmEmploymentds.fetchMode(QueryFetchMode::One2One);
// Adding child 2 as a datasource
qbds = qbds.addDataSource(tableNum(Child2));
qbds.joinMode(JoinMode::InnerJoin);
qbds.addLink(fieldNum(Parent, LeaveDetail), fieldNum(Child1, RecId));
qbds.fetchmode(QueryFetchMode::One2One);
return new QueryRun(query);
}
Subscribe to:
Post Comments (Atom)
Connect and upload in azure blob with azure key vault using x++
Today, I will be sharing details about file upload in azure blob using azure vault that includes pre requisite and code snippet used to it....
-
Today, I will discussing about how to create a batch job using SysOperationFramework in Dynamics 365 Finance And Operations. Let's sup...
-
Today I will be discussing about how to create batch job through x++. Before going in code lets discuss what are batch jobs. Batch job : ...
-
This blog is about how to upload data in D365 using excel file. As we all know that AX7 is running on web browser so importing data using ex...
No comments:
Post a Comment
Note: only a member of this blog may post a comment.