I would like to use a Custom Fields to Single Select from names in a Label. i cant use USERS because there are too many duplicates and too many(qty) .
i was able to pull assets, ... just something missing that i cant get it figured out... Thank You
In your custom field try something like this:
query: SELECT USER.EMAIL, USER.ID, USER_LABEL_JT.LABEL_ID FROM ORG1.USER USER INNER JOIN ORG1.USER_LABEL_JT USER_LABEL_JT ON (USER.ID = USER_LABEL_JT.USER_ID) WHERE USER_LABEL_JT.LABEL_ID = "219" ORDER BY FULL_NAME ASC
This will display all the users email addresses in the label ID 219.
You can change the data shown by changing USER.EMAIL to which ever field in the user table has the data you need.
Also to find the ID of the User label, go to Home>Label Management> Labels and hover over the user label you want, you should see the ID appear in the bottom left corner of the screen