Need my custom action code to be reviewed because my output is not working properly

[yjeon92]

In Flow Designer - Custom Action, my input is incident_number which refers to Records.

This is my Script Step:

function execute(inputs, outputs) {
var gr = new GlideRecord(inputs.incident);
gr.query();
if (gr.next()) {
var comments = gr.comments.getJournalEntry(1);
var regex = /\b\d{5}\b/;
var match = comments.match(regex);}

if (match) {
outputs.employee_id = match[0];
}
}

(inputs, outputs);

and my output is the employee_id.

My goal is to look up the incident record to parse through the additional comment to find the Employee ID and output the employee_id as an integer.  My issue is my output is not working even though the script goes through the testing.  Please help

[yjeon92]

@Mohith Devatte 

It still won't output the employee id in the comments of the incident that it is being triggered.

[Mohith Devatte]

@yjeon92 put some logs in below loop and check if logs are triggering

if (match) {
outputs.employee_id = match[0];
}

[yjeon92]

is this what you mean:

if (match) {

outputs.employee_id = match [0];

}

gs.log(employee_id);

[Mohith Devatte]

if (match) {

gs.info('employee_id'+match [0]);

outputs.employee_id = match [0];

}

[Sunny15 · Accepted solution]

Hello @yjeon92 

Please Copy Paste and try following code .

(function execute(inputs, outputs) {
  var match ;
var gr = new GlideRecord('incident');
gr.addEncodedQuery('number='+inputs.incident_number+'^ORsys_id='+inputs.incident_number);  // add your filed name which your passing as parameter to query in incident table. 
gr.query();
if (gr.next()) {
var comments = gr.comments.getJournalEntry(1);
var regex = /\b\d{5}\b/;
match = comments.match(regex);
}

if (match) {
outputs.employee_id = parseInt(match[0])+1;
}

// ... code ...
})(inputs, outputs);