How to display only the choices of state value by sn-record-picker

[Kent Gloriana]

Hello Guys.

I want to use sn-record-picker to filter the value of state

but the display field show all the record of state and it's repeating the value.

I want only to display this 4 "Requested,  Awaiting Approval, Closed Complete, Approved "

Please see the attached screenshot.

Can anyone help me?

[Ankur Bawiskar]

Hi,

are you sure you are picking correct state choice values?

what happens when you just give this?

stateIN13,14

Regards
Ankur

[Kent Gloriana]

Yes. I want only to display only the choices "Requested,  Awaiting Approval, Closed Complete, Approved " on the dropdown so that when I select requested and click search it will display all the record that in requested state value. Is there any way to do this?

Thanks a lot.

[Ankur Bawiskar]

Hi,

are you sure the field state has those choices in that table?

Did you check on table filter condition if that query works fine?

Regards
Ankur

[Kent Gloriana]

Sorry for late reply. Yes it has those choices. I want only is on how to display in the dropdown list only 4 not all the the state value of the table.

See attached screenshot for the state choices: