Advance Reference Qualifier

[Simran321]

Hi There,

I have a subcategory table that has name, dependent value (category) and business application. I have a reference qualifier on a sub category field that is looking at application and dependent value and populating sub category.  In the same table I have sub category name "Other" and that is not tied to any application. 

With the Reference qualifier below "Other" sub category is showing for all the applications.

javascript:'u_active=true^u_dependent_value=14b20c42db6d0f001f0f534e5e961905^u_table=incident^u_business_application=' + current.variables.cmdb_ci + '^ORu_name=Other';

I have been asked to exclude "other" for 5-6 applications. What is the best way to do this. Can I do this with if else clause

[Sandeep Rajput]

@Simran321  If multiple if else conditions are required in the reference qualifier then I recommend taking them to a separate script include and return modified reference qualifier depending up on the condition. This script include can be called from the reference qualifier field.

Hope this helps.

[Simran321]

Thanks Sandeep. That is what I did and it's working

[Sandeep Rajput · Accepted solution]

@Simran321 Please mark my response an accepted solution if the suggested approach worked for you.