Script Action

[onatdeviren]

Hello,

I have been trying to create a GlideRecord request to a data set in a script action. But I cant call the values of different fields in the data set through dot walking, even though I can call the sys id of the data set. 
And when I run the code as a Background script it works just fine... Any idea why it doesnt work as a script action? Thanks! 

My Code: 

        var request_id = event.parm2 //this is the sys_id I want to call

        var data_set = new GlideRecord("table_name");

        if (data_set.get(request_id)) {

            gs.info("test Number: " + data_set.getValue("number")); 

        // Get Value function returns "null". (Not if I run this exact code as Background Script)  

        } else {

            gs.info("Record not found");

        }

[Simon Christens · Accepted solution]

On this table of yours - do you have any query business rule running ?
Maybe try:

        var request_id = event.parm2 //this is the sys_id I want to call
        var data_set = new GlideRecord("table_name");
        data_set.setWorkflow(false); //Disables query business rules that could prevent the user from seing the record
        if (data_set.get(request_id)) {
            gs.info("test Number: " + data_set.getValue("number")); 
        // Get Value function returns "null". (Not if I run this exact code as Background Script)  
        } else {
            gs.info("Record not found");
        }

I dont know if the table is in global scope, scoped app, or something similar (domain separation) that could also cause issues.

[onatdeviren]

Thanks a lot, that solved the problem! :))

[Simon Christens]

Please take into consideration that if you need to update the record in the script its VERY important that you do
data_set.setWorkflow(true) before data_set.update() so that BRs runs

        var request_id = event.parm2 //this is the sys_id I want to call
        var data_set = new GlideRecord("table_name");
        data_set.setWorkflow(false); //Disables query business rules that could prevent the user from seing the record
        if (data_set.get(request_id)) {
            gs.info("test Number: " + data_set.getValue("number")); 
        // Get Value function returns "null". (Not if I run this exact code as Background Script)  
            data_set.setWorkflow(true)
            data_set.setValue(xxxxxx);
            data_set.update();
        } else {
            gs.info("Record not found");
        }

Because setWorkflow(false) will also prevent Business rules from running on updates which can cause huge issues - work_notes, comments etc not working - other rules doesnt apply and so on!

I would probably look into the Query Business rule and adjust that so system is not hit by it - only apply the Query BR if users got role x of y.

[Ravi Gaurav]

Hi @onatdeviren 

Try the below code :-

var request_id = event.parm2; // this is the sys_id you want to call
var data_set = new GlideRecord("table_name");
if (data_set.get(request_id)) {
gs.info("test Number: " + data_set.getValue("number"));
} else {
gs.info("Record not found");
}

[onatdeviren]

This didnt work. What I get is "Record not found". And again in the Background - Script record is found and printed correctly.