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.

[Community Alums]

hI @pavan_yadav ,

Can you share screenshot of your script?

[pavan_yadav]

Hi @Community Alums 

the above is sysauto_report  table condition field script and 
below is sys_properties table record

when i check logs
im getting --> 

in background script im able to see sys id of created property.

[GlideFather]

@pavan_yadav I got it!!!!

It is because you are entering the script to Condition field 😉

And it doesn't make sense for condition. 

[GlideFather]

@pavan_yadav 

Try anything similar to:
(just a draft, not tested)

var prop = gs.getProperty('some.property.name'); 
if(prop = 'Source') {
return true;
} else {
return false;
}

*prop return sys id so the if condition the script shall be per sys_id not name...

[pavan_yadav]

Hello @GlideFather ,
But in the condition we can write script some ootb script screen shot below,
condition is a script field, so for the below script it is working.

And also i have tried like below:

im getting result but to avoid hardcoding I want to use properties here.