gs.getproperty not working

[Venkat122]

Hi All,

I am using script include in report for some complex query. To make this dynamic i am taking some values from sys_properties table using gs.getProperty() method. But when i use it in script include it is not working. same script is working when i checked by running in background. Is this an expected behavior? How we can overcome this problem?

script include:

name: getIncidents

client callable: true

script:

function getIncidents()

{

var arr = [];

var query = gs.getProperty('Custom.incident.query');

var gr = new GlideRecord('incident');

gr.addEncodedQuery(query.toString());

gr.query();

while(gr.next())

{

arr.push(gr.sys_id+'');

}

return arr.toString();

}

Form list view, i am calling it as

sys id --is one of-- javascript:getIncidents()

Build version: isthanbul

Thanks and regards

Swamy

[Anisha4]

gs.getProperty or GlideRecord to sys_properties (impersonation )doesnt work in case you are using them in dynamic filters. Use User preferences instead.

[preeeti majhi]

Hi 

I was also facing the same issue and my dev lead helped me with the root cause of it. Please look into the link this will answer the question to the issue.

https://docs.servicenow.com/bundle/paris-platform-administration/page/administer/security/reference/r_ScriptSandboxing.html