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 (also called SELECT DISTINCT) from the table. D365 Business Central does not provide this logic out of the box so we will need to find a way to do this ourselves.

We can use combination of looping and temporary table to find distinct values. However, I found that using Query is the easiest…

Continue Reading thatnavguy’s Article on their blog

D365 Business Central : Using Query to Get Distinct Values – That NAV Guy

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

Blog Syndicated with thatnavguy’s Permission

More About This Author

Teddy
Experienced NZ-based NAV Developer and Consultant with 10+ years of experience leading multiple IT projects, performing business analyst, developing, implementing, and upgrading Dynamics NAV and Business Central.
I have led multiple Dynamics NAV and Business Central projects for businesses in Asia, such as Japan, Singapore, and Indonesia, and currently in both Australia and New Zealand.
I am passionate to deliver solution that focuses on user-friendly interface while keeping high standard of compliance with the needs. I believe in adding value to people’s lives and try to leave people better than when I first met them.

Author: Teddy

Experienced NZ-based NAV Developer and Consultant with 10+ years of experience leading multiple IT projects, performing business analyst, developing, implementing, and upgrading Dynamics NAV and Business Central. I have led multiple Dynamics NAV and Business Central projects for businesses in Asia, such as Japan, Singapore, and Indonesia, and currently in both Australia and New Zealand. I am passionate to deliver solution that focuses on user-friendly interface while keeping high standard of compliance with the needs. I believe in adding value to people’s lives and try to leave people better than when I first met them.

Share This Post On