O'Reilly logo

Extending Microsoft Dynamics NAV 2016 Cookbook by Alexander Drogin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Linking datasources with advanced queries

The data item property DataItemLinkType specifies how the tables will be joined in the query. Besides two basic types, there is an option that allows the developer to enable advanced options and perform right outer joins, full outer joins, and cross joins.

How to do it...

In this recipe , we will build a Query object with full outer join between two tables to see detailed information on customer discount groups configuration:

  1. Create a Query object in object designer.
  2. Insert a data item with the Customer table as data source.
  3. Include two columns from the Customer table: No. and Name.
  4. Add another data item Customer Discount Group.
  5. Include two fields from the Discount group: Code and Description:

  6. Open the properties ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required