Hi Community, I need to trigger notifications on sys approval table

[rajeshKongamudi]

Hello Community,

We are attempting to retrieve the "Requested For" and "Opened By" fields from the sysapproval table, but we are currently unable to retrieve these values. We would appreciate assistance in triggering the "Requested For" and "Opened By" fields. Below, I have outlined the trigger conditions and the event script.

We would be grateful for any guidance on how to resolve this issue and implement the necessary enhancement. Thank you in advance for your support.

Advanced script: 

--------------------------------

(function executeRule(current, previous /*null when async*/) {

    // Add your code here

var values = current.sysapproval.variables;

gs.eventQueue("Freelancer_reject", current, values.requested_by, values.requested_for.email);

})(current, previous);

[Ankur Bawiskar · Accepted solution]

@rajeshKongamudi 

use this in your script

I assume event, notification is on Approval table and Event parm1 contains Recipient checkbox is True

(function executeRule(current, previous /*null when async*/ ) {
    // Add your code here

    var gr = new GlideRecord("sc_req_item");
    gr.addQuery("sys_id", current.sysapproval);
    gr.query();
    if (gr.next()) {
        var values = gr.requested_for.toString() + ',' + gr.opened_by.toString();
        gs.eventQueue("Freelancer_reject", current, values);
    }

})(current, previous);

If my response helped please mark it correct and close the thread so that it benefits future readers.

[DeependraS]

(function executeRule(current, previous ) {
var approvalRecord = new GlideRecord(current.sysapproval.getRefRecord().getTableName()); // Get related record
if (approvalRecord.get(current.sysapproval)) {
var requestedFor = approvalRecord.getValue("requested_for");
var openedBy = approvalRecord.getValue("opened_by");

gs.eventQueue("Freelancer_reject", current, openedBy, requestedFor);

}
})(current, previous);

How This Fixes the Issue

Correctly fetches the "Requested For" and "Opened By" fields from the referenced request record

Uses getRefRecord() to dynamically get the correct record type from sysapproval

Prevents errors due to missing fields in sysapproval

[Toderean alexan]

Hi @rajeshKongamudi 

  First of all, every time you assign a value to a variable you have to check that if is a valid value, before sending or processing. I recommend to ensure that everything is ok before sending it to event. I would like to see how you configured the notification, how you assigned the parameters? 

[Ankur Bawiskar · Accepted solution]

@rajeshKongamudi 

use this in your script

I assume event, notification is on Approval table and Event parm1 contains Recipient checkbox is True

(function executeRule(current, previous /*null when async*/ ) {
    // Add your code here

    var gr = new GlideRecord("sc_req_item");
    gr.addQuery("sys_id", current.sysapproval);
    gr.query();
    if (gr.next()) {
        var values = gr.requested_for.toString() + ',' + gr.opened_by.toString();
        gs.eventQueue("Freelancer_reject", current, values);
    }

})(current, previous);

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Mani Polisetty2]

Great thanks for your solution, I am also facing the same issue and this solution helped me to resolve my issue. Thanks