Custom Field in Queue Customization
I'm trying to Custom Field as Manager to pull the manager from User. According to Kace, I can pull location "query: select distinct(LOCATION) from USER". Can I pull Manager using this query? I tried changing LOCATION with MANAGER and that did nothing. It just shows up as a drop down menu with the actual "query: select distinct(LOCATION) from USER"
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
ondrar
5 years ago
Two things.
First, remove the quotes from what you put in Select Values, and the query will run.
Second, the USER table only has MANAGER_ID, so you'll need a different query. Try this:
query: select distinct(M.FULL_NAME) from USER join USER M ON M.ID=USER.MANAGER_ID
That will return the name of any users who are set as managers of other users.
