How to filter out the users list who has HR profile, field referencing the user table using reference qualifier?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-21-2018 01:28 AM
Using a reference qualifier, I want to filter out the users who does not have a HR Profile present.
the field of the catalog item references the User table.
- Labels:
-
Service Catalog

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-21-2018 01:35 AM
Hi
Return users who do not have HR from script include and call that script include here in the refernce qual.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-21-2018 01:38 AM
Hi Tulika,
Let me know if you the HR profiles are given with a role or any specific group already exists for this? Once we have an idea on role based or group based, we can script this easily and I can provide you the code.
Regards, Akash
If my response proves useful, please mark it "Accept as Solution" and "Helpful". This action benefits both the community and me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2018 12:08 AM
Hi Akash,
yes HR Profile is given with two roles:
sn_hr_core.hrsm_employee
sn_hr_sp.hrsp_employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-24-2018 11:35 PM
Hey Akash,
I have an existing script include that will check if the user has an existing HR profile.
But the script include is in HR core but the catalog item is in global.