/build/static/layout/Breadcrumb_cap_w.png

Custom Field query: - How to Select Value for Specific User and not get a list?

I am trying to figure out how I can enter the USER.ID variable in a query: under Custom Fields.  I'd like to query the USER_FIELD_VALUE table where FIELD_ID = '1' for the specific User submitting the ticket.

query: SELECT DISTINCT(FIELD_VALUE) FROM USER_FIELD_VALUE WHERE FIELD_ID = '1' AND USER.ID = USER_FIELD_VALUE.USER_ID AND USER.ID = <USER>


So the question is: Do Custom Field queries support a variable?  If so, what is it?


0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 3 weeks ago
Red Belt
1

As far as I am aware, custom fields do not support variables, if they did, some aspects of my KACE life over the years would have been much easier ;o)


What you are asking for is obviously similar to a ticket rule, but the custom field has a disadvantage, namely there is no Select query to provide the variable contents in the same way.


Comments:
  • With that being the case, I created a new UserVoice request: https://kace.uservoice.com/forums/82699-sma-k1000/suggestions/44064231-allow-user-variable-in-service-desk-custom-field-q

    Please vote for it (and anyone else who views this later, please consider voting for it so it happens!). - RyanTech 3 weeks ago
 
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