Lookup Property from sys_properties table in UI Builder

[Elena]

Hi everyone,

I am trying to lookup a system property (sys_properties table) in UI Builder.

I tried with the data resource "Look Up Properties" but I guess it looks for properties of the experience not the system, so I'm getting a null as a result.

I also tried with the data resource "Look Up Record" but I cannot select the correct table (sys_properties).

Is anyone more successful than me and can show me how to do it?

Thanks.

[Voona Rohila]

Hi Elena , use below method to get the property value

 gs.getProperty('property name');

[Elena]

Hi Rohila,

where should I use it in UI Builder? I cannot call gs in a Client Script.

[Brad Tilton · Accepted solution]

Hi Elena,

The Look Up Properties composite data resource is restricted to looking up properties defined in the glide.graphql.property.whitelist system property, which is not editable by customers right now.

You can create a transform data resource that will do this. Transform data resources let you execute server-side code and make the results available in UIB. If you go this route, don't forget to create an ACL for your DR. You can find out more about transform data resources here: https://developer.servicenow.com/blog.do?p=/post/quebec-ui-builder-data-resources/

[Elena]

Thanks, it worked.