Catalog UI policy display wrong value in catalog condition list

[A3]

I am using Catalog UI policy to display/hide fields depending on a value in another field.

1. On my PDI the data from the fields displays:

2. On the company dev server it displays other data in the drop down list.

3. The variable setup:

4. Data displays correctly in select list on SR:

5. Data in sys_choice table:

6. The problem is not just with this variable but on others as well.

7. I have tried the below from suggestions I found but did not fix problem.

• change Table from question_choice to sc_item_option
• Clear the cache and retest: Cache.do

Any suggestions will be appreciated.

[Juhi Poddar]

Hello @A3 

• Please verify the records in the sys_choice table in the dev instance. There may be duplicate or extra records, or the filter condition used to fetch the choices might not be correctly defined.
• Try copying and running the exact query from the sys_choice filter to see what values are being returned. This can help you confirm whether the dropdown is showing the expected choices.

Hope this helps!

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps future readers to locate the solution easily and supports the community!"

Thank You
Juhi Poddar

[A3]

It returns the correct data but it is still not working.

[GlideFather]

Hi @A3 
can you please review the "name=question_choice"?

Because question_choice is the table in which it is...

Can you please remove that part to see what it will return please

[Juhi Poddar · Accepted solution]

Hello @A3 

Try this:

javascript:'name=question_choice^element=momo_gaming^inactive=falseORDERBYsequence'

Hope this helps!

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps future readers to locate the solution easily and supports the community!"

Thank You
Juhi Poddar

[GlideFather]

@Juhi Poddar you miss "^" between false and ORDERBY