Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Relationship between Company and Department Table

Go to solution
anubhavkapoor76
ServiceNow Employee

‎04-06-2020 06:08 AM

Hi All,

Where does the relationship between Company ( core_company) and Departments ( cmn_department) table exist?

Assumption: Department field gets autopopulated on filling the Company field

Cheers!!
Anu

Conect me at LinkedIn
0 Helpfuls
  • 3,251 Views
1 ACCEPTED SOLUTION

Go to solution
Pradeep Sharma
ServiceNow Employee

‎04-06-2020 06:30 AM

Hi Anubhav,

"cmn_department" table has a field "company" that refers to the company table. Most likely there could be a client script in your instance which is auto-populating the Department field.

 

- Pradeep Sharma

View solution in original post

5 REPLIES 5

Go to solution
Onkar Pandav
Tera Guru

‎04-06-2020 06:32 AM

Hi,

I think there is no such OOTB relationship.

You can populate those two fields on the basis of "Caller name".