Distinct – Pardaan.com

D365 Business Central : Using Query to Get Distinct Values

When working with table data, there will be times when we need to retrieve a unique record value from the table (also called SELECT DISTINCT). Unfortunately, D365 Business Central does not provide this logic out of the box. We will need to find a way to…

10 August 2022

Dynamics NAV & BC Tips & tricks

How Do I Perform a Select Distinct with Queries

This video demonstrates how to perform a select distinct with queries in Microsoft Dynamics NAV. The demonstration covers the following steps: What is a Select Distinct? Bron : Think about IT Lees meer...

13 May 2016

Dynamics NAV & BC Tips & tricks

Application Design Pattern: SELECT DISTINCT with Queries

This pattern explains how to perform SELECT DISTINCT by using queries in Microsoft Dynamics NAV. It is brought to you by Bogdana Botez from the Dynamics NAV team here at Microsoft Development Center Copenhagen (MDCC). When you work with tables, sometimes you must perform a SELECT…

9 March 2015