- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-17-2023 08:59 AM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2023 07:08 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-24-2023 12:44 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2023 11:03 AM