Question on sysapproval_approver Table

[priya68]

Hi There,

  I have one requirement on sysapproval_approver Table

     I have one Catalog Item 'XYZ' in that , i have 2 fields and These fields should be displayed on approval page

Not on Request page or RITM those should only visible for Approval ,

So how can i achieve this, can anybody please help me to get the proper solution.

Thanks,

Priya 

[Saurav11]

Hello,

Are these variables if yes then you need to create two fields on the approver table then populate them using business rule and have them visible of form only if the it is ritm and the ritm item name is XYZ.

Please mark my answer as correct based on Impact.

[priya68]

Hello,

  I have created 2 fields on Approver table, now could you please help me on Business Rule.

Thanks,

[priya68]

Hello Saurav,

 I have written the below BR code, but I don't think the code is in proper manner, please help me on this.

(function executeRule(current, previous /*null when async*/) {
if(sysapproval.cat_item.name == 'XYZ')

{
    var sysApprover = new GlideRecord("sysapproval_approver");
    sysApprover.addQuery("sysapproval", current.getValue("sys_id"));
    sysApprover.query();
    if (sysApprover.next()) {
    current.variables.u_site_details = sysApprover.approver;
    current.variables.u_network_segment = sysApprover.approver;    
    }}
})(current, previous);

Thanks,

[Saurav11]

Hello,

Please write a after insert BR on sysapproval_approver table:-

Use the below code:-(Replace the fieldname1 and fieldname2 with your fieldnames)

(function executeRule(current, previous /*null when async*/) {
 var sysApprover = new GlideRecord("sc_req_item");
    sysApprover.addQuery("sys_id", current.sysapproval);
    sysApprover.query();
    if (sysApprover.next()) {
    current.fieldname1 = sysApprover.variables.u_site_details;
    current.fieldname2 = sysApprover.variables.u_network_segment;
	current.update();
	}

})(current, previous);

Please mark my answer as correct based on Impact.