adding distinct for a value in query
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
adding distinct for a value in query
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?
Re: adding distinct for a value in query
Can you give an example of what you want to accomplish?
Tom - V8.8 build 3137 - MySql / PostGres
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
Re: adding distinct for a value in query
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.
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.
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
Re: adding distinct for a value in query
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
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