adding distinct for a value in query

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

adding distinct for a value in query

Post by 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
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: adding distinct for a value in query

Post by tford »

Can you give an example of what you want to accomplish?
Tom - V8.8 build 3137 - MySql / PostGres
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

Re: adding distinct for a value in query

Post by 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
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

Re: adding distinct for a value in query

Post by 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
Post Reply