How to get the value from RITM table insted of TASK table using email script.

Sudhansu12
Tera Contributor

‎04-01-2024 10:13 AM

Hi @Ankur Bawiskar 

I have a existing email Script where i need to get the value of "Description" and "Requested for"  field from RITM table for that purpose i have written a script.

 
var targetObj;
    if (current.getTableName() == "sysapproval_approver") {  
      var grCurrent = new GlideRecord(current.source_table);
        grCurrent.get(current.document_id);
        if (grCurrent) {
            targetObj = grCurrent;
        }
    } else if (current.getTableName() == "sc_task") {
        targetObj = current.parent;
    } else {
        targetObj = current;
    }
   

  above underline code i have used for fetch the Description and req_for field but it is not working.it fetch the data from sc_task table but i need it from RITM table

can any one help me on this.

 

0 Helpfuls
  • 178 Views
1 REPLY 1

Deepak Shaerma
Kilo Sage

‎04-01-2024 09:59 PM

Hi @Sudhansu12 
just update your script as per the requirement

if (current.getTableName() == "sysapproval_approver") {
        // In case current record is an Approval record
        var grCurrent = new GlideRecord(current.source_table);
        if (grCurrent.get(current.document_id)) {

            if (grCurrent.getTableName() == 'sc_req_item') {
                ritm = grCurrent;
            } else if (grCurrent.hasField('request_item')) { // For example, if it’s a task associated with a RITM
                ritm = new GlideRecord('sc_req_item');
                ritm.get(grCurrent.request_item);
            }
        }
    } else if (current.getTableName() == “sc_task”) {
        // For tasks directly linked to RITMs
        ritm = new GlideRecord(‘sc_req_item’);
        ritm.get(current.parent); // Assuming ‘parent’ field links to RITM
    } else if (current.getTableName() == “sc_req_item”) {
        // If current record is an RITM already
        ritm = current;
    }

    if (ritm && ritm.isValidRecord()) {
        // Retrieve and store the description from the RITM record
        descriptionText = ritm.getValue(‘description’);
        
        // Retrieve the requested for user’s display name
        requestedForName = ritm.requested_for.getDisplayValue();
    }

    // Construct the message to be returned
    var finalMessage = "Description: " + descriptionText + "\nRequested For: " + requestedForName;

    return finalMessage;
})();

Note: Please Mark this Helpful and Accepted Solution. If this Helps you to understand. This will help both the community and me..
- Keep Learning ‌‌
Thanks & Regards 
Deepak Sharma


0 Helpfuls