question Re: How to resolve this error "Read operation on table 'sn_hr_core_case_workforce_admin' from & in HRSD forum

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

Prathamesh Cha1 — Fri, 27 Oct 2023 14:10:51 GMT

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.

Re: How to resolve this error "Read operation on table 'sn_hr_core_case_workforce_admin' from &

Sandeep Rajput — Fri, 27 Oct 2023 16:30:53 GMT

@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.

Re: How to resolve this error "Read operation on table 'sn_hr_core_case_workforce_admin' from &

Prathamesh Cha1 — Sat, 28 Oct 2023 17:53:38 GMT

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);

Re: How to resolve this error "Read operation on table 'sn_hr_core_case_workforce_admin' from &

Sandeep Rajput — Sat, 28 Oct 2023 17:58:01 GMT

@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.

Re: How to resolve this error "Read operation on table 'sn_hr_core_case_workforce_admin' from &

Prathamesh Cha1 — Sat, 28 Oct 2023 19:32:27 GMT

tried this but still value is not coming,

var val = '';

var date = new GlideRecord('question_answer');

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

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

date.query();

if(date.next()){

val = date.getValue('value');

}

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

template.print(date.value);

Re: How to resolve this error "Read operation on table 'sn_hr_core_case_workforce_admin' from &

Sandeep Rajput — Sat, 28 Oct 2023 19:38:21 GMT

Try this

var val = ''; var date = new GlideRecord('question_answer'); date.addQuery('table_sys_id', 'e8d2c4a71b8e3d901eeafc07cb4bcbe5'); date.addQuery('question', 'ad28230f1bccb9501eeafc07cb4bcb61'); date.query(); if(date.next()){ val = date.getValue('value'); gs.info('Date value '+date.getValue('value')); } // template.print(gs.getMessage(val)); template.print(val);

Check if the value gets printed in log.

Re: How to resolve this error "Read operation on table 'sn_hr_core_case_workforce_admin' from &

Prathamesh Cha1 — Sat, 28 Oct 2023 19:42:05 GMT

@Sandeep Rajput

not working tried this

Re: How to resolve this error "Read operation on table 'sn_hr_core_case_workforce_admin' from &

Sandeep Rajput — Sat, 28 Oct 2023 19:48:40 GMT

@Prathamesh Cha1 Did any value print in System log? I added a gs.info in the script.