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.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

1
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
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>
Answered 03/01/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
1
thank you for the reply. I will give it a shot.
Answered 03/03/2011 by: ryklism
Orange Belt

Please log in to comment
Answer this question or Comment on this question for clarity