adding distinct for a value in query

swiftinitpvtltd

I want to have distinct for a value in query that is a dropdown input dynamic query for another BO form (it has repeated text values). How do I add that?

tford

Can you give an example of what you want to accomplish?

swiftinitpvtltd

yes thank you.
I have a bo with plain text field which will be repeated or can have duplicate value.

BO1col1
test1
test5
test5
test1
test1
test7

Now I want this column value to be a dropdown in another form but without any duplicates. I can write the query to get this data but it brings duplicates as well(dynamic query option in another bo column). I want to do select distinct.
I have seen one trick in one forum post to add exists but I do not have any other filters as this is a plain text field.

swiftinitpvtltd

is distinct available in find query in aware?

SELECT
DISTINCT Description
FROM HourType
WHERE AvailabilityCode=3

FIND DISTINCT BO WHERE BO.Codes=3
I want to avoid duplicates in a referenced BO dropdown