Are you sure that the view "ORG_ORGANIZATION_DEFINITIONS" returns duplicate organizations?!
What is your apps version?
The value set displays the organization ID and returns the organization name. Is this intended?
Sorry for the wrong attachment.
It should be Locators from MTL_ITEM_LCOATIONS Valueset.It should take the value from the First Valuset for ORGANIZATION_ID.
Now I am getting multiple values in the LOV for Locator Valueset
Validation Locators VS.bmp 76.3 K
Can you not create a view ?
Select Distinct id, value from your_table;
And then use it in the Value Set ?
Is there any way to restrict the values on the VALEUSET itself?At least in the WHERE/ORDER BY section for distinct values If i dont want to create a view
We can do it.
In table name field give select statement which have distinct. It should be in one line.
Hope this will help you