Limit Reference field choices based on live changes

AjvadK · 3 weeks ago

I have 2 reference fields category and sub-category, both referencing the sn_grc_choice table. The category values are set as parent for sub-category values. I need to limit the choice list for sub-category field, based on the category value chosen. I tried using reference qualifier advanced qualifier method using the following code:

javascript&colon;"parent=" + current.category

It works fine for a new record, but for an existing record, it is only taking into account saved/server-side value. So real-time changes made to the category field are not being considered.

Ankur Bawiskar · 3 weeks ago

@AjvadK

try to add this in the Dictionary Attributes of the 2nd field

ref_qual_elements=category

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

soumyadeep10 · 3 weeks ago

Hi @AjvadK ,

Usually what is done is, in the sys_choice table, the dependent value is chosen to specify which choice value will appear based on what dependent value. See below as an example.