Small and medium business | Business Central, N...

Getting only distinct values

(0) Share

Report

Posted on by Muhammad Anas Naeemi

436

Hey community, I want to ask that how can I only get unique Production ID i.e. 1000, 1330 and 1600 and I don't want it to be repetitive like it is in the picture below. It should consist of only three lines each for one Production ID. Kindly suggest how can I do that.

I have the same question (0)

All responses (9)

Answers (0)

Sort by

Suggested answer

Mohana Yadav 61,204 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Is it a custom table/page?

How are you filling this table now?

can you show the code?

Was this reply helpful? Yes No
Muhammad Anas Naeemi 436 on at

Like (0)

Report
Copy link

Link copied!

Actually I am getting the data from a query. and yes I'm inserting it in a custom table. the query contains repetitive values. this is how I'm getting values but they are repetitive as shown in the above image

Was this reply helpful? Yes No
Ayala 112 on at

Like (0)

Report
Copy link

Link copied!

Hi,

If you have the option to work with query object. You can create some like this:

query 60100 DistinctValues

{

elements

{

dataitem(SalesLine; "Sales line")

{

column(LineNo; "Line No.")

{

}

column(Count)

{

Method = Count;

}

}

}

}

It will return dataset with unique line no. You can find more information on Aggregate and sort data in a query - Training | Microsoft Learn

I hope this will help you

Was this reply helpful? Yes No
Suggested answer

Ayala 112 on at

Like (0)

Report
Copy link

Link copied!

HI,

On query to get unique values you must group only for those unique fields you need to obtain.

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,302 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Check if your query has at least one aggregate column to trigger the distinct.

Refer to below link for more information.

thatnavguy.com/.../

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,144 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, You can also directly add a loop that inserts a new row if it doesn't exist and modifies the record if it exists, which is also more convenient.
But defining in Query is the best performance.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Muhammad Anas Naeemi 436 on at

Like (0)

Report
Copy link

Link copied!

Hey, still unclear. Can you show me the code for this?

Was this reply helpful? Yes No
Muhammad Anas Naeemi 436 on at

Like (0)

Report
Copy link

Link copied!

Yes teddy I have used Method=Sum but it's not working. I tried to use count but my fields are integer and not code.

Was this reply helpful? Yes No
Suggested answer

Teddy Herryanto (Th... 14,302 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The query should retrieve the distinct records for all the fields specified in the query object, not the ones specified in your procedure logic.

You didn't post your query, but I can see that you commented out some of the query fields on your screenshot.

Things like uerMember or Description also being considered as part of distinct value.

Was this reply helpful? Yes No