How to get a lookup select in a record producer to list all options?

[Jacob Saaby Ni1]

Hi everyone.

I became aware yesterday, of a caveat with using lookup select variables in a record producer.

So, let's say there is a number of records in e.g. the Incident table.

The incident form has a field called "Option X". Option X has 5 options, but across all of the incident records, only 3 of them have ever been chosen, when people created incidents. Let's say the options that were chosen were 1, 2 and 3. This means, no incidents exist where the value of Option X is 4 or 5.

So, now I want to create a record producer where I let users have a simple approach to submitting an incident.

I create a variable called Option X. I define it as a lookup select field. I map it to the Option X field. In Type Specification I instruct it to look at the Incident Table, and the field Option X.

I check off that it should only show unique values.

This means that when users create incident records, they only get to choose values 1, 2 and 3 from that record producer variable.

As soon as I go into the platform and create an incident record, choosing 4 in Option X, users also get to choose 4 in the record producer variable. But they still don't get to choose option 5.

So my question is:

How can I have a lookup select field list ALL of the options available in the Option X field, instead of only the options which have been used in existing incident records?

If this is not possible, then I guess my only option is to "copy" the choice table for the field, and mirror that in the record producer. Is this the way to go?

[Ashutosh Munot1]

Hi,

Cant you use choice field, which can refer to option x field on incident table. 

This will list all the choices available on incident form for that field.

Thanks,

Ashutosh Munot

Please Hit Correct, Helpful or like,if you are satisfied with this response.

[Community Alums · Accepted solution]

Dear  jacobsaaby,

Instead of Lookup select box, user "Select box" type, and aslo select value of Choice table  as "Incident" and Choice field as  "Option X"(which you mentioned in your question).

"Choice table" and "Choice fields" are fields under "Type Specifications" section in Variable form.

[Jacob Saaby Ni1]

Thanks Swamy, that worked beautifully 🙂

[Danielle Shingi]

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0784512