ATF - Unable to fetch RITM Number in test step.

Gaurav Bhatia · ‎06-12-2020

Hi Team,

This is related to ATF (Service catalog in service portal). I have a requirement to show a log message in an ATF test step. I am doing 'Record Query' on log table then adding 'Open an existing record' step,

Log message contains the RITM no. This is the key to fetch the log message.

But I am unable to get RITM no. in the test steps. When we order a catalog item then we are getting REQ no. Now to get RITM no, I added a test step 'Record Query' on sc_req_item table (filter i uses as - Request is output of Order a catalog item)

By doing this I am able to get the sys id of RITM But I want RITM no so that I will use this to fetch log message.

Please let me know if we can fetch RITM no or not

Regards,

Gaurav

Community Alums · ‎06-12-2020

Hi Gaurav,

Here is the script. Please replace the SYS_ID of the test step accordingly:

(to get the sys_id open the Record Query on sc_req_item table test step, and copy sys_id from context menu like we do in normal forms.)

(function(outputs, steps, stepResult, assertEqual) {
    // add test script here
	var gr = new GlideRecord("sc_req_item");
	gr.get(steps('**sys_id of TEST STEP that has the RITM sys_id').record_id);
	outputs.table = 'sc_req_item';
	outputs.record_id = gr.getValue('number');
	stepResult.setOutputMessage(gr.getValue('number'));
	 })(outputs, steps, stepResult, assertEqual);

Thanks,

Debopriya

View solution in original post

Community Alums · ‎06-12-2020

Hi Gaurav,

You can add a Run Server side script test step after your record query. From the sys_id fetch the RITM number and set it as the output for your run script test step.
Thanks,
Debopriya

Gaurav Bhatia · ‎06-12-2020

Hi Debopriya,

Can u please help me writing that script? Don't know how to write script in 'Run Server Side Script' test step.

Thanks

Community Alums · ‎06-12-2020

Sure, give me a moment I will get back to you with the script.

Community Alums · ‎06-12-2020

Hi Gaurav,

Here is the script. Please replace the SYS_ID of the test step accordingly:

(to get the sys_id open the Record Query on sc_req_item table test step, and copy sys_id from context menu like we do in normal forms.)

(function(outputs, steps, stepResult, assertEqual) {
    // add test script here
	var gr = new GlideRecord("sc_req_item");
	gr.get(steps('**sys_id of TEST STEP that has the RITM sys_id').record_id);
	outputs.table = 'sc_req_item';
	outputs.record_id = gr.getValue('number');
	stepResult.setOutputMessage(gr.getValue('number'));
	 })(outputs, steps, stepResult, assertEqual);

Thanks,

Debopriya