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

[Vishal Khandve]

Hi Giri,

may be problem is here

you have to give someother diiferent name

Thnk you

[Venkat122]

When i use below, it is working

function getIncidents()

{

var arr = [];

var query = 'active=true';

var gr = new GlideRecord('incident');

gr.addEncodedQuery(query.toString());

gr.query();

while(gr.next())

{

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

}

return arr.toString();

}

[Shishir Srivast]

can you paste the screenshot of your property?

[Venkat122]

[Vishal Khandve]

Try only sys_id of assignment group, it is working for me.

Hope it works for you.

Thank you,