Loading...

D365 FO - X++ Join multiples tables with same table using query build data source

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 more
Sherif Fayed
Sherif Fayed

Share post:

Related 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...

1 month ago

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...

6 months ago

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...

11 months ago

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...

1 month ago

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,...

1 year ago

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...

1 year ago

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...

1 year ago

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...

1 year ago

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...

1 year ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy