Workflow runscript not working for GlideRecord

[Aruna Sree Yela]

Hi,

Workflow run script working if I pass record number directly in the GlideRecord, and If I glide with addQuery its not working at all. Tested by adding workflow logs.

Passing record number directly:

workflow.info('Hi');
var jsonObj = {}; 
var res = {}; 
var parsedData = {}; 
workflow.info('script start');
var caseR = new GlideRecord('x_imports_revision_case');
caseR.addEncodedQuery("case=​POREV0001051");
caseR.query();
workflow.info('after query ' + current.case + ' & ' + current.sys_id + ' & ' + caseR.getValue("number")  + ' & ' + caseR.getValue("short_description")  + ' & ' + caseR.addQuery('case',current.case));
if (caseR.next()) {
	workflow.info('in if');
    jsonObj = caseR.json_output.toString();
    parsedData = JSON.parse(jsonObj);
    workflow.scratchpad.supplier_ship_date = parsedData.u_supplier_ship_date[0].changed_value;
	workflow.info(' the scratchpad is '+ new global.JSON().encode(workflow.scratchpad.supplier_ship_date));
    workflow.scratchpad.po_cancel = parsedData.u_po_cancel[0].changed_value;
	workflow.info(' the scratchpad is '+ new global.JSON().encode(workflow.scratchpad.po_cancel));
}

Output:

Gliding with addQuery:

workflow.info('Hi');
var jsonObj = {}; 
var res = {}; 
var parsedData = {}; 
workflow.info('script start');
var caseR = new GlideRecord('x_imports_revision_case');
caseR.addQuery('case',current.case);
caseR.query();
workflow.info('after query ' + current.case + ' & ' + current.sys_id + ' & ' + caseR.getValue("number")  + ' & ' + caseR.getValue("short_description")  + ' & ' + caseR.addQuery('case',current.case));
if (caseR.next()) {
	workflow.info('in if');
    jsonObj = caseR.json_output.toString();
    parsedData = JSON.parse(jsonObj);
    workflow.scratchpad.supplier_ship_date = parsedData.u_supplier_ship_date[0].changed_value;
	workflow.info(' the scratchpad is '+ new global.JSON().encode(workflow.scratchpad.supplier_ship_date));
    workflow.scratchpad.po_cancel = parsedData.u_po_cancel[0].changed_value;
	workflow.info(' the scratchpad is '+ new global.JSON().encode(workflow.scratchpad.po_cancel));
}

Output:

Thanks in Advance:)

[_Gaurav]

Hi @Aruna Sree Yela 
Can you try the below code?
Also may I know what type of field is case field?

workflow.info('Hi');
var jsonObj = {}; 
var res = {}; 
var parsedData = {}; 
workflow.info('script start');
var caseR = new GlideRecord('x_imports_revision_case');
caseR.addEncodedQuery('case='+current.case);
caseR.query();
workflow.info('after query ' + current.case + ' & ' + current.sys_id + ' & ' + caseR.getValue("number")  + ' & ' + caseR.getValue("short_description")  + ' & ' + caseR.addQuery('case',current.case));
if (caseR.next()) {
	workflow.info('in if');
    jsonObj = caseR.json_output.toString();
    parsedData = JSON.parse(jsonObj);
    workflow.scratchpad.supplier_ship_date = parsedData.u_supplier_ship_date[0].changed_value;
	workflow.info(' the scratchpad is '+ new global.JSON().encode(workflow.scratchpad.supplier_ship_date));
    workflow.scratchpad.po_cancel = parsedData.u_po_cancel[0].changed_value;
	workflow.info(' the scratchpad is '+ new global.JSON().encode(workflow.scratchpad.po_cancel));
}

[Aruna Sree Yela]

@_Gaurav Case type is "Composite Field".

I tried the above code, but no luck for Case field and Number[string] field as well.

Thanks

[piyushsain]

@Aruna Sree Yela 

Can you please try current.case.toString()

[Aruna Sree Yela]

@piyushsain Not working!

And I can be sure that current.case was fetching the value correctly. If you see the below log

workflow.info('after query ' + current.case + ' & ' + current.sys_id + ' & ' + caseR.getValue("number")  + ' & ' + caseR.getValue("short_description")  + ' & ' + caseR.addQuery('case',current.case));

Thanks