How to create custom Reference Qualifier fields

Andre Tella
Tera Contributor

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:

 

AndreTella_0-1697558317582.png

We've also tried adding this:

 

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

 

But it does not seem to work. Any ideas?

1 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:

BradBowman_0-1698069350283.png

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. 

 

View solution in original post

6 REPLIES 6

That's actually progress as it shows you are affecting the correct qualifier.  Confirm that the record you are selecting a Type on is on the hr_core_case table, then look outside of this record at a list view of the service_offering table.  Is there record(s) where the Parent = Customer Background Verification?  This is the relationship I couldn't establish in my PDI - when creating a new service_offering record, the Parent field is a reference to cmdb_ci_service, so the HR Service (sn_hr_core_service) records do not appear.

Hi Brad, 

 

Not sure if I understood...

I do need the Type (service_offering) values that are childs/related to the HR Service (hr_service) selected. 

Also, the ones that are active as well.

Thanks