How to create custom Reference Qualifier fields

[Andre Tella]

Hi there, 

I have a demand where I need to create a Reference Qualifier field where I need to show only services that are under the parent Service, and also are active. 

Right now we are trying like this:

We've also tried adding this:

javascript:'parent='+current.business_service;u_active=true^EQ

But it does not seem to work. Any ideas?

[Brad Bowman]

Starting with the first condition before we add in the active, make sure you are identifying the correct field and relationship.  As pictured, you are asking for records on the Service Offering table to be filtered to show only those where the Parent field on the SO is populated with whatever has been selected as the value of a field named business_service that is on the same form/table as this reference field.  Note that the Parent field on the Service Offering table is a reference to the cmdb_ci_service table, so business_service must be a reference to the same table for this to work.

Once you get that straightened out, the convention to add another condition like active would be more like:

javascript:'parent='+current.business_service + '^u_active=true';

[Andre Tella]

Hi Brad, 

Not sure if I followed correctly. There are 2 fields in the form: HR Service (hr_service) and Type (service_offering). 
For the Type field, I do need the ones related to the HR Service selected, and also are active. 

Can you try to explain yourself one more time?

Thanks a lot!!

[Brad Bowman · Accepted solution]

Since you are referring to a HR Case, your environment may be different than what I'm doing to my PDI, but if the Type/service_offering field when you view the Dictionary Entry shows that this field is on the task table, you'll want to leave the Reference Qualifier on service_offering as it was out of the box as changing the Reference Qualifier where you have pictured in the original post will change it system-wide every place serivce_offering is used.

Unless you are using a service_offering field that is not on the task table, what you want to do in this case is first change to the Human Resources: Core Application Scope.  Now view the Dictionary Entry for Type/service_offering and create a New record on the Dictionary Override  Related List, pictured at the bottom of your original screenshot.  The Table will be HR Total Rewards Case. Check the box for Override reference qualifier, then supply a qualifier like this:

hr_service is the field name to use, not business_service.  I couldn't get any results in my environment because I don't have/can't create a Service Offering with a Parent that is a HR Service, but if that's how you have these setup, or are using a different service_offering field than the qualifier using current.hr_service will work. 

[Andre Tella]

Hi Brad,

I've implemented this solution that you've mentioned, but I did not work...

Now when I go to select a new Type(service_offering) inside the HR Case, nothing shows up...

Do you have another idea?