Unable to retrieve property value using gs.getProperty('') in scheduled report (sysauto_report)

[pavan_yadav]

I'm trying to use var prop = gs.getProperty('some.property.name'); inside a scheduled report (sysauto_report), but the value of prop keeps returning undefined. Can anyone confirm if gs.getProperty() works in scheduled reports, or if there's a limitation in that context?

Thanks,
Pavan.

[GlideFather]

@pavan_yadav FYI

I tried it in my PDI but I cannot get no logs at all, not undefined, but nothing....

Documentation:

https://developer.servicenow.com/dev.do#!/learn/learning-plans/xanadu/new_to_servicenow/app_store_le...

[Community Alums]

As Ankur mentioned this is due to script executes in sandbox and you don't have access to gs.getProperty() method.

[pavan_yadav]

Hello @Community Alums ,
Is there any document, please give me link, 
i want to override that behaviour

[Mark Manders]

If it is for branding of the email, you can use email scripts. Those work in scheduled reports as well. And from there your can absolutely call properties.

[pavan_yadav]

Hi @Mark Manders ,
Yes we can also use email scripts but in my case I need to apply this condition in SLA, this report schedule should send notification only 9am to 7pm, so I already declared timings in cmn_schedule table, 
so in the schedule report I'm using GlideSchedule() and its method isInSchedule(), these 2 are helps to restrict schedule running between the time.