Suppose that I have SQL:
Select DISTINCT co_num, due_date
From coitem
where [some condition here]
Here the code will return DISTINCT values. For example if co_num 123 has 5 lines with same due date, then I will get only one row.
How can we achieve DISTINCT feature in IDO Collection?
Is there a way that I can specify that I want to pull only the distinct rows and not duplicates?
Even in Dataview, is there a way to fetch distinct data?
I know this is something very common in data word. But perhaps I am missing something.
Hi, you need to join the table coitem back on itself, joining on the distinct columns and only return the record with the lowest, or highest, primary key value. Assuming you have a primary key (unique…
IDO's support the "Distinct" keyword, but I can't find anything on how its implemented (ie: which column/properties are you considering "distinct"). Depending on how that functions it should work for you.
I was also thinking that somewhere I have used distinct in the past. Then I recalled that in IDO Rest API Web Services,, in LoadCollection we can use distinct. But not in IDOs directly.