Related Lists on the HR Profile table

Dave65 · 3 weeks ago

In my PDI, when I look at an HR Profile, there are related lists at the bottom of the form.
I can find all but 2 of them on the Relationships table or the sys_m2m table.
Can anyone tell me how these are created?
The 2 I am referring to have the labels 'Jobs' & 'Employee Documents'.

Thanks in advance for your help.

Ankur Bawiskar · 3 weeks ago

@Dave65

the Jobs one you won't find in Relationships table since it's an OOTB related list i.e. "sn_hr_core_job" table has field pointing to HR Profile.

Only defined relationships are present in that Relationships Under System Definitions

I am not sure about the Employee Documents.

If you are unable to find that as well in sys_relationship table it means it's an OOTB related list

i.e. Employee Document table also has a field which points to HR Profile table

Example: Direct reports related list doesn't have any filter based on some field so it's a defined relationship and you will find that in Relationships

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

RaghavSh · 3 weeks ago

@Dave65 All relationships are stored in "sys_relationship".

You can import xml of relationship required to your instance and add those relationship to your form.

Please mark the answer correct/helpful accordingly.

Raghav
MVP 2023
LinkedIn

Dave65 · 3 weeks ago

Hi RaghavSH

I cannot find the 2 Related lists on that table in my PDI, this is what I see:

These are the 2 I can't find:

For the Jobs tab, the label comes from the Plural of the table definition for the sn_hr_core_job table.

Ankur Bawiskar · 3 weeks ago

@Dave65

defined relationships are created from Relationships Under System Definitions

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Dave65 · 3 weeks ago

Hi Ankur

The problem I'm having is that there are 2 Related lists that are Out of the box and there is no entry for them on the Relationship table.
Please look at my previous response.