How to resolve this error "Read operation on table 'sn_hr_core_case_workforce_admin' from "global"

Prathamesh Cha1 · ‎10-27-2023

Hi All,

How to resolve below error

Read operation on table 'sn_hr_core_case_workforce_admin' from scope 'Global' was denied because the source could not be found. Please contact the application admin.

Sandeep Rajput · ‎10-27-2023

@Prathamesh Cha1 Use the following steps to fix this issue.

1. Select the application scope as Human Resources Core Scope.

2. Navigate to Application Restricted Caller Access Module

3. Create a new record as follows.

Submit the record and try running the script again. This time the errors will not appear.

Hope this helps.

Prathamesh Cha1 · ‎10-28-2023

Hi @Sandeep Rajput ,

I have created record as you said, But Here I am getting "undefined" or "null" as output.

Actually I am trying this script in email script, and get the data in notification body but I am getting undefined as output,

Here Undefined is the output here I am trying to fetch value of "value" field from question_answer table

code:

var date = new GlideRecord('question_answer');

date.addQuery('table_sys_id', 'e8d2c4a71b8e3d901eeafc07cb4bcbe5');

date.addQuery('question', 'ad28230f1bccb9501eeafc07cb4bcb61');

date.query();

if(date.next()){

var val = date.getValue('value');

}

// template.print(gs.getMessage(val));

template.print(val);

Sandeep Rajput · ‎10-28-2023

@Prathamesh Cha1

While reviewing your script, I observed an issue on line number 14 where you have defined a local variable

var val = date.getValue('value');

On line number 18 you are trying to access this variable

template.print(val);

The script will crash on the above line as val is a local variable declared inside if and being accessed outside its scope.

Please declare the var val=''; outside the if statement as follows.

var val='';
if(date.next()){
val=date.getValue('value');
}
template.print(val);

Hope this fixes your issue.

Prathamesh Cha1 · ‎10-28-2023

tried this but still value is not coming,

var val = '';