The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Change Approval Reason Field

Highlighted
Omer Uyar
Occasional Contributor

Change Approval Reason Field

Hi all,

I have 4.5 SP 19. I want to capture the Reason field data when a person approves or rejects the change request. As i looked in the field lists in i couldn' t find any field like that. I want to catch the votes and capturethe Reason field data and copy to a personel history field.

Thanks in advance,

Omer
2 REPLIES
George M. Meneg
Honored Contributor

Re: Change Approval Reason Field

Hello Omer,

You can't capture by a field but you can get it through an sql query like the following

select cha.cha_id as ID, per.per_name as Voter, cha.cha_description as ITEM_DESCRIPTION,
apv.APV_REASON as reason , apv.APV_APPROVED as Result
from itsm_changes cha inner join ITSM_APPROVER_VOTES apv on cha.cha_OID=apv.APV_APT_OID
inner join itsm_persons per on apv.APV_PER_OID=per.PER_OID
menes fhtagn
Omer Uyar
Occasional Contributor

Re: Change Approval Reason Field

No solution to use change approval reason in SD rules.
//Add this to "OnDomLoad" event