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
-
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.
Array
- Business Central7 March 2023D365 Business Central : An environment with the same name already exists
- Business Central3 March 2023D365 Business Central : Enable Job Queue in Docker Container
- Business Central1 February 2023D365 Business Central : Suggest Account on General Posting Setup
- Business Central26 January 2023D365 Business Central : Persistent Blob