/build/static/layout/Breadcrumb_cap_w.png
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"
M7czQJ.jpeg
0 Comments   [ + ] Show comments

Comments


All Answers

1
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.
Answered 10/05/2018 by: ondrar
Brown Belt