/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


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) .

01/17/2020 385 views

i was able to pull assets, ... just something missing that i cant get it figured out... Thank You

1 Comment   [ + ] Show comment

Comments

  • Can you share your SQL from the custom fields and also what data you would like to see in that dropdown?

All Answers

0

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


Answered 01/21/2020 by: Hobbsy
Red Belt

  • That's some great work ! I'm pulling in USER_USER.NAME . thank you MUCH !!!

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ