Lookup select box is not showing choices on the variable

Souvick6917
Tera Contributor

Hello,

I am  facing one issue on lookup select box type variable. I have created a customized field on Incident table , type is Choice and created the choices. Now I have a record producer where I have a variable with the same name and type is Lookup select box. When I am providing the correct name of the customized field in the lookup field value of the variable , no choices are getting populated. 

Is there any issue with the type of field on Incident table as 'Choice', because if it is 'String' it will work.

Summarize the fields:

Table : Incident

Field : Product ( type : Choice)

 

Variable : Product ( on record producer)

Type :  Lookup select box

Lookup value field : product (from incident)

 

Please help to understand the root cause and probable solution.

 

Regards

Souvick

1 ACCEPTED SOLUTION

Sandeep Rajput
Tera Patron
Tera Patron

@Souvick6917 Lookup select box variable acts more like a reference field than a choice field. A select box would be more appropriate variable to have on your record producer than a Look up select box.

View solution in original post

4 REPLIES 4

Brad Bowman
Kilo Patron
Kilo Patron

Understand that a Lookup Select Box type variable is going to show you only the choices (Products in this case) that exist as a value on one or more incident records. It is looking up all of the values of the custom field from the incident table.

Sandeep Rajput
Tera Patron
Tera Patron

@Souvick6917 Lookup select box variable acts more like a reference field than a choice field. A select box would be more appropriate variable to have on your record producer than a Look up select box.

Hi Sandeep,

 

The selectBOx which I used in the cataog form is not showing up the assignment groups but only domain, on groups list its showing blank

Souvick6917
Tera Contributor

Thank you all, as I figured out the condition for lookup select box and used select box instead , it worked. But sincere appreciation for taking out your time and replying on my question.

 

Regards

Souvick