How to fix Reference Qualifier to only show Active Categories instead of All

Emily4
Tera Contributor

Hello,

So on the Incident form, depending what is in the business area field, some categories are exposed..
Example: Business Area = Strongroom... there are 5 categories that get exposed on the INC form. 

find_real_file.png

 

There used to be other categories under the Strongroom Business Area, but I made them inactive so only the 5 shown above show on the form.. That works as expected.

Here is the problem:


I have a record producer form that lets you pick the Business Area, and shows the Categories available, however, it is showing all the categories available for Strongroom. Not just the active ones.. 

find_real_file.png

How can I change the script in this reference qualifier to only show active categories for the selected Business Area instead of all of them?

find_real_file.png

 

Thanks in advance for the help!

Emily

1 ACCEPTED SOLUTION

Vamsi Sreenivas
Giga Guru

HI Emily,

 

update your reference qualifier with below:

javascript:'name=incident^element=category^inactive=false^dependent_value='+current.variables.u_choice_3

 

Mark my answer as HELPFUL / CORRECT if this help resolve your issue.

Regards,

Vamsi S

View solution in original post

7 REPLIES 7

Vamsi Sreenivas
Giga Guru

HI Emily,

 

update your reference qualifier with below:

javascript:'name=incident^element=category^inactive=false^dependent_value='+current.variables.u_choice_3

 

Mark my answer as HELPFUL / CORRECT if this help resolve your issue.

Regards,

Vamsi S

THANK YOU! 

Yousaf
Giga Sage

Hi,

Try adding this to your query.

 + '^active=true'

 

Mark Correct or Helpful if it helps.


***Mark Correct or Helpful if it helps.***

  1. Step 1:-Application Navigator>Incident>Open Existing Record or Create New.
  2. Step 2:-Right Click on Any Reference Field i. e. Caller.
  3. Step 3:-Configure Dictionary.