Record Producer Lookup Select Box

[KamakshiM]

I am trying to create a record producer for the Incident table and I created a variable for the Channel field.

I selected the Lookup Select Box and in Type Specification, I have given Incident as the lookup table and Channel as the lookup field.

But in my PDI, when I try to view the form, it shows the options from existing incident records rather than the available channels.

It is showing this:

instead of this:

Is this a known bug in PDI? Or am I doing something wrong?

[Kalyani Jangam1]

Hi @KamakshiM 

Rather than to use lookup select box used simple choice field and map that field to channel field in incident. You have to create choices on new field in record producer.

[Pradeep67]

enable the "Unique values only", it should do the trick. but use Select box with choice fields for this

[OlaN]

Hi,

Instead of using a Lookup select box, you can use a reference field selection with some conditions on the query.

Like I've configured below:

[JenniferRah]

Make sure the "Unique values only" checkbox is selected.