Service Desk Custom Field
I am configuring the service desk feature of the K1000 and would like to create a custom field. I would like to create a custom field to auto populate the email address of the user creating the request. WE have AD authentication. This information show up in the submitter field when you click on the person icon. but I would like to have a separate field that stores the email.
I tried this "query: select distinct(EMAIL) from USERS" in a single select field and it returns all the emails. I would like it to select the currently logged on users email.
any suggestions are appreciated. If I am not clear just ask and I will elaborate.
I tried this "query: select distinct(EMAIL) from USERS" in a single select field and it returns all the emails. I would like it to select the currently logged on users email.
any suggestions are appreciated. If I am not clear just ask and I will elaborate.
0 Comments
[ + ] Show comments
Answers (2)
Please log in to answer
Posted by:
GillySpy
13 years ago
you would need a ticket rule to do this. something like (note not tested so please test on a test queue and follow http://www.kace.com/support/kb/index.php?action=artikel&cat=8&id=689&artlang=en)
frequency=on ticket save
select query
update query
frequency=on ticket save
select query
select HD_TICKET.ID from HD_TICKET JOIN USER SUBMITTER ON SUBMITTER_ID=SUBMITTER.ID
WHERE CUSTOM_FIELD_VALUE0<>SUBMITTER.EMAIL
update query
update HD_TICKET T JOIN USER SUBMITTER ON SUBMITTER_ID=SUBMITTER.ID
SET
/*assuming CUSTOM_1 is used */ CUSTOM_FIELD_VALUE0 = SUBMITTER.EMAIL
WHERE T.ID =<TICKET_IDS>
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.