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
1 Comment
[ + ] Show comment
-
Can you share your SQL from the custom fields and also what data you would like to see in that dropdown? - Hobbsy 4 years ago
Answers (1)
Please log in to answer
Posted by:
Hobbsy
4 years ago
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
Comments:
-
That's some great work ! I'm pulling in USER_USER.NAME . thank you MUCH !!! - 2Leo 4 years ago
