Allow User Variable in Service Desk Custom Field Query
I'd like to query the USERFIELDVALUE table where FIELD_ID = '1' for the specific User submitting the ticket. This is just like the update query in Service Desk rules where you can specify a variable that pulls the ticket numbers from the select query, but would be for the currently logged in user (USER.ID = <USER>).
For example:
query: SELECT DISTINCT(FIELDVALUE) FROM USERFIELDVALUE WHERE FIELDID = '1' AND USER.ID = USERFIELDVALUE.USER_ID AND USER.ID = <USER>
18
votes
