D365 FO - X++ Join multiples tables with same table using query build data source
This tutorial discusses how to address a common query creation issue by using the query build data source in Dynamics 365 Finance and Operations. It covers how to join multiple tables, including the base table, HcmEmployment table, and Leave Plan table, using query build data source. The code used for joining these tables with query build data source is provided in the tutorial.
The tutorial also provides information on useful date-related and query-related methods such as Year(date _date) for getting the year from a specified date, mkdate(int _day, int _month, int _year) for creating a new date, mthOfYr(date _date) for getting the month from a specified date parameter, dayOfMth(date _date) for getting the day of the month from a specified date parameter, and SysQueryRangeUtil::dateRange(startDate,toDate) for adding date range to queries. It also explains how to hide a range in a query by setting its status to hidden.
If you're struggling with query creation using the query build data source in Dynamics 365 Finance and Operations, this tutorial is an excellent resource to guide you through it.
For more information, you can check out the original post.
Published on:
Learn moreRelated posts
Creating A Date Table In Power BI
If you're using Power BI, it's crucial to create a date table to ensure accurate and efficient data analysis. Unfortunately, many people overl...
D365 FO Data entity Export using X++
This post provides information on exporting data entity through X++ in D365 FO. The post includes a code snippet written in X++ that can be us...
Date Table in Power BI: Enhancing Your Data Analysis
Hey there! Are you looking to level up your data analysis game in Power BI? Well, you're in luck because we're about to dive into the wonderfu...
Dynamic Date Slicer In Power BI Using A Period Table
If you're looking to customize your visualizations and gain more control over your data in Power BI, you'll want to check out the period table...
How to Create a Date Table in Power BI
Creating a date table is a crucial task for any data analyst or visualization expert working in Power BI. It allows you to effectively filter,...
Power Query Transform Column Challenge: Stacked Data to Ordered Table
This Power Query transform column guide focuses on transforming stacked data into a tabular format with the information presented in descendin...
Introducing Power Query Extended Date Table V2
In this blog post, you'll learn about Power Query Extended Date Table V2, its updated features and where to find the code as well as the requi...
Modify and delete multi-table lookups within Dynamics 365 CRM
In this tutorial, we'll dive into the process of modifying and deleting multi-table lookups within Dynamics 365 CRM. Previously, we explored c...
Building Your First Calendar Table in Power BI!
If you're eager to learn how to create a dedicated calendar table and an independent date hierarchy using DAX in Power BI, look no further tha...