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

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

pavan_yadav — Wed, 16 Jul 2025 09:08:11 GMT

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.

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

Pranesh072 — Wed, 16 Jul 2025 09:10:21 GMT

On which field you are adding this code?

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

Mark Manders — Wed, 16 Jul 2025 09:19:53 GMT

Where/why are you calling a system property? What is the config you are trying to collect from the property?

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

GlideFather — Wed, 16 Jul 2025 09:26:35 GMT

@pavan_yadav
check it in background script, what it returns when you call that property or you can log it..

I just tried to call a random property and that work, try it in you instance, similarly to:

And if it returns ok, then you know it is something with the scheduled report. Couldn't it be due to cross-scope?

EDIT:

in the script above I called this property:

And I noticed following:

is the "read role", does your report have right to read the system property??
isn't the property marked as Private?

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

pavan_yadav — Wed, 16 Jul 2025 09:35:55 GMT

In sysauto_report table we have condition field, it is script field, there I'm trying to call one schedule record (cmn_schedule) to restrict sending notification after 6pm.

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

Shraddha Kadam — Wed, 16 Jul 2025 09:36:26 GMT

Hello @pavan_yadav ,

Follow the steps which is provided by @GlideFather , and if your system property is in the scope application, then make sure you are calling from the "name" field instead of the suffix.

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

pavan_yadav — Wed, 16 Jul 2025 09:37:21 GMT

In sysauto_report table we have field called condition, it is script field, there I'm trying to take cmn_schedule record to restrict sending notification after time out.

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

pavan_yadav — Wed, 16 Jul 2025 09:39:27 GMT

Hi @GlideFather ,
In background script or other places, I'm able to retrieve property value but in the sysauto_report table we have condition (script) field there if I try to retrieve property value it is giving me undefined.

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

Shraddha Kadam — Wed, 16 Jul 2025 09:40:35 GMT

Can you provide screenshot of your script and system property

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

pavan_yadav — Wed, 16 Jul 2025 09:42:11 GMT

Hi @Shraddha Kadam ,
my issue is in the table : sysauto_report has condition field, it is script field there im not able to retrieve the property value. I created a property in sys_properties table, name: schedule, application : global, type: string, and value: sysid of record cmn_schedule table

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

Chaitanya ILCR — Wed, 16 Jul 2025 09:43:41 GMT

Hi @pavan_yadav ,

make sure there is no Typo

gs.getProperty()

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

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

pavan_yadav — Wed, 16 Jul 2025 09:50:27 GMT

Hi @Chaitanya ILCR ,
my line is

var sc = gs.getProperty('Schedule');
gs.log(sc); --> it is resulting undefined in sysauto_report tables condition field.
but when I try in background script, I'm able to see the sysid as result.

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

Community Alums — Wed, 16 Jul 2025 09:52:33 GMT

hI @pavan_yadav ,

Can you share screenshot of your script?

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

GlideFather — Wed, 16 Jul 2025 09:58:45 GMT

@pavan_yadav can you please check the scope of your property?
And how did you add a script to sysauto_report? Is the report in the same scope as the property?

if you property is named "my_property" and scope is "x_snc_scope", then call it:

x_snc_scope.my_property

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

pavan_yadav — Wed, 16 Jul 2025 10:21:01 GMT

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.

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

GlideFather — Wed, 16 Jul 2025 10:28:00 GMT

@pavan_yadav I got it!!!!

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

And it doesn't make sense for condition.

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

GlideFather — Wed, 16 Jul 2025 10:29:47 GMT

@pavan_yadav I was asking here where did you manage to get a script for sysauto_report as there is no script field.

The only one is Condition, so you need to return the result for the Condition:

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

GlideFather — Wed, 16 Jul 2025 10:32:17 GMT

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

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

pavan_yadav — Wed, 16 Jul 2025 10:35:56 GMT

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.

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

GlideFather — Wed, 16 Jul 2025 10:40:18 GMT

That is fine, but you got "undefined" because your scripted condition was:

var prop = gs.getProperty('com.glide.cs.branding.support_email_label'); gs.info(prop);

please add there some values to return and let me know how did it go.

Try something like this:

var prop = gs.getProperty('some.property.name'); //perhaps it must be prop = sys_id of the property if(prop = 'Source') { gs.info('Out if Prop true'); return true; } else { gs.info('Out if Prop false'); return false; }