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 from the table (also called SELECT DISTINCT). Unfortunately, D365 Business Central does not provide this logic…
Blog Syndicated with thatnavguy’s Permission