Trying to use options from a table choice for a select box variable

[Brian Sorensen]

Trying to not reinvent the wheel, I'm sure this can be done, but I'm just getting stuck

I have the following in a table

Project Type - its a choice field

Asset Refresh
Asset Lifecycle
Value Enhancement

On the Catalog form we want to use to populate the table I want to have the same options

I tried to create a record producer with the following

Question Type - Choice
Question Subtype - Reference

Pointed to the table and the field I want

no results

Then tried to use

Choice

Dropdown (Values from Table)
Pointed to the table and column

No results

Not sure what I am doing wrong, but is there a way to not have to recreate the same options?

[Brad Bowman]

You can do this with a Lookup Select Box type of variable.  I have configured this example to emulate Category as seen on the Incident form / table

In the Reference qualifier, use the name and element from your desired choice list.

[Mayur2109]

Hi @Brian Sorensen ,

Yes you can use choices which are created for Project type fields in sys_choice table. You need to check map to field in catalog variable the select type as lookup select box, then you need to Lookup from table as sys_choice. Important point here is you need to add reference qualifier for which you can get query from sys_choice table to get all choices related to Project type field.

For your reference I've created same for incident table & field category.

Please check and Mark Helpful and Correct if it really helps you.

Regards,
Mayur Shardul

ServiceNow Rising Star 2024

[Brian Sorensen]

Found an easier way
just went into the advanced view, which is just the older Maintain items view

left them as a select box and pointed to the table and column I wanted displayed