How to display only active items in reference fields?

[LoriC]

Hello  - when displaying values in a reference field, how do I set it so that items that are 'false' do not display? An example is when selecting SC Category in the incident form and choosing a category, it is displaying categories we have set to false. 

Thanks!

[harshagumma]

Hi LoriC,

Right click on the SC Category field on the incident table and click on "Configure Dictionary" and update the reference qualifier condition as below. 

If the solution shared works for you, please "Accept as Solution" and mark " Helpful."  

Thanks,

Gummagatta Harshavardhana

[LoriC]

Hi - I have a follow up question - in our reference qualifier we have this javascript:

javascript:"sc_catalog="+current.u_catalog 

This seems like how we are only pulling in one particular catalog and not ones such as public or resources. 

Excuse this beginner question but how do I add that I only want the active items for that catalog?

Thanks!

[Anand Kumar P]

Hi @LoriC ,

Right-click on the reference field choose Configure Dictionary.
Find Reference Qualifier and add a condition to filter out unwanted values. For example, if you have an “active” field, the condition might be active=true.

Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand