How can I get only distinct values from the list?

I see that there isn't a clear way of retrieving a unique item list and counting those values. What other options are there?   For example, I have the following list of values in Element column:   I want to have only {Upset top, Upset Bottomtom, Blocker Top, Finisher Top}
2 answers

Hi Yogeshwar,

As Stella said, if the objects are the same, then you can use the method suggested by Stella,


but, if the objects are different, you can use OQL, and use Distinct query or Group By query.

This way you will be able to get only unique column data.


Let me know, if you have any issues,

Hope it helps!



Hi Yogeshwar , 


If these list is going to have same objects repeated means , then you can apply union operation for the same list , resultant list will have unique objects in the list