question How to create sys property Reference type and List Type in Community Central forum

How to create sys property Reference type and List Type

Varsha A — Thu, 07 Nov 2024 04:12:50 GMT

How to create sys property Reference type and List Type so that we can select values from table instead of adding comma separated sys_ids.

Re: How to create sys property Reference type and List Type

Community Alums — Thu, 07 Nov 2024 04:51:16 GMT

@Varsha A Navigate to sys_properties.list and click on new to create a new property.

For reference type:

Type: Choose Reference from the dropdown.

Reference Table: Choose the target table you want to reference (e.g., cmdb_ci_computer, incident, user, etc.).

Default Value: This can be left empty or can be set to a default sys_id (if needed).

And for other Choose List from the dropdown.

To utilise properties in script :

Reference Property:

var refValue = gs.getProperty('your_table_reference_property');

var gr = new GlideRecord('cmdb_ci_computer');

gr.get(refValue); // Retrieves the referenced record based on the sys_id

List Property:

var listValue = gs.getProperty('your_table_list_property');

var sysIds = listValue.split(','); // Split the comma-separated sys_ids

var gr = new GlideRecord('cmdb_ci_computer');

gr.addQuery('sys_id', 'IN', sysIds);

gr.query();

while (gr.next()) {

// Process each record in the list or add your logic as per your requirement.

}

Hope this will help you.

Re: How to create sys property Reference type and List Type

Runjay Patel — Thu, 07 Nov 2024 04:53:02 GMT

Hi @Varsha A ,

Did not understand you fully, Are you trying to get the reference value from property? Please explain bit more your requirement.

Re: How to create sys property Reference type and List Type

Varsha A — Thu, 07 Nov 2024 07:15:51 GMT

Hi @Community Alums

we don't have type reference available : "Type: Choose Reference from the dropdown."

Re: How to create sys property Reference type and List Type

Varsha A — Thu, 07 Nov 2024 07:18:31 GMT

Hi @Runjay Patel , yes i want to create property of type reference or List, so that i can select values from table.

e.g. i would like to select user from the reference field.

Re: How to create sys property Reference type and List Type

Runjay Patel — Thu, 07 Nov 2024 07:49:47 GMT

Hi @Varsha A ,

But for reference type why you wanna create property, you can create dictionary of reference type and give ref table as User. It will give you option to select user for that field. Why are you referring to create property here, Still i didn't get.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

Re: How to create sys property Reference type and List Type

Varsha A — Thu, 07 Nov 2024 08:57:06 GMT

Hi @Runjay Patel

I want it in same way, but i am unable to display it on property ui page,

https://snhackery.com/2019/01/16/reference-type-system-properties-part-iii/

and also see same type of requirement here,

https://www.servicenow.com/community/developer-forum/make-a-system-property-where-the-choices-should-be-like-a-quot/m-p/1560509

Do let me know if you have idea on this.

Thank you

Re: How to create sys property Reference type and List Type

Community Alums — Thu, 07 Nov 2024 09:45:10 GMT

@Varsha A

Create a Reference Field in the Property Form Layout:

To enable selection from a table, customize the layout of the sys_properties form:

Go to System UI > Form Layout and select the sys_properties table.

Add a Reference field (e.g., u_custom_reference) and configure it to reference the desired table.

This creates a field in the system properties where users can select a single record from the specified table.

I wanted to say same as point 2 but just missed few text, sorry for confusion.