How to remove choice option from Record Producer

jaubert
Tera Guru

I set two category choices as inactive on my custom table.  When I use the record producer form, those choices are still visible.  How do I set them as inactive on my record producer?

1 ACCEPTED SOLUTION

Saurav11
Kilo Patron
Kilo Patron

Hello,

 

That is because even though the options are inactive they are probably used in some of the records so it is showing in the varibale.

 

Do one thing change the lookup table to sys_choice instead (I am takin the esample of Incident table and category field Please adjust according to your custom table) 

 

Saurav11_0-1666197247716.png

 

Then in the reference qualifier add the below(again adjust the table and field name)

 

javascript:'nameSTARTSWITHincident^name=incident^element=category^language=en^inactive=false';

 

Please mark answer as correct based on Impact.

View solution in original post

8 REPLIES 8

Mike_R
Kilo Patron
Kilo Patron

Find your record producer

instanceName.service-now.com/sc_cat_item_producer_list.do?sysparm_query=active%3Dtrue&sysparm_view=

 

Open up the record, scroll down to Variables related list

Mike_R_0-1666190039357.png

 

 

Open the variable

 

Scroll down to the Question Choices and make the choices inactive.

jaubert_0-1666192965315.png

I have no choices listed once I open the variable.

jaubert_1-1666193308156.pngjaubert_2-1666193402587.png

 

Is that second screenshot of an existing ticket? I think the inactive will only take effect for future requests.