Retrieving Record Numbers Instead of sys_ids in ATF

Khalid9030 · ‎12-29-2024

Hello,

In ATF, we have two Record Query steps with different conditions for the same table. These two record conditions are called in the Set Field Values step(PFA). When I call these two records, I am getting the sys_ids instead of the record numbers (PFA).

Could you please advise how to retrieve the record numbers instead of the sys_ids in ATF?

Ankur Bawiskar · ‎12-29-2024

@Khalid9030

something like this

Step execution script:

(function executeStep(inputs, outputs, stepResult, timeout) {

    var recordSysId = inputs.u_sysid
    var gr = new GlideRecord("incident");
    gr.addQuery("sys_id", recordSysId);
    gr.query();
    if (gr.next()) {
        outputs.u_number = gr.getDisplayValue();
        stepResult.setOutputMessage('Found the record');
        stepResult.setSuccess();
    } else {
        stepResult.setOutputMessage('Record not found');
        stepResult.setFailed();
    }

}(inputs, outputs, stepResult, timeout));

For my testing: I used these steps and it worked and gave me the number taking sysId as input

Output:

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

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Khalid9030 · ‎12-30-2024

@Ankur Bawiskar

Can you do same thing using the Run Server side ?

Ankur Bawiskar · ‎12-30-2024

@Khalid9030

No because that OOB step has pre-defined output variable and you cannot add a custom output variable to it

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

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Chidanand_VK · ‎01-27-2025

You can do using 'Run server side script' test step by using the script like below example.

var gr = new GlideRecord('incident');

gr.addEncodedQuery('short_description=test^description=test');

gr.query()

while(gr.next()){

outputs.record_id = gr.number; //gives the Number present on the Incident as output

}

Unfortunately, you can't take the Output of the Record query test step as Input in the Run server side script. So, you need to add the query in the script for your table.

If my answer helped you in any way, please mark it as helpful or correct.

Regards,

Chidanand Kalmani