I wanted to share a new insight I had into ServiceNow. Many of us know that when you create tables, that contain references to other tables, they show up in the related list you can include on the form.
What a lot of people (including myself until recently) didn't know was that you can create a relationship between any table in ServiceNow without having a reference or foreign key shared. I am going to show you how.
The first thing you need to do is migrate to the "Relationships" module under System Definition:
Create a new Relationship between the two tables you want:
This step is optional, but there are some hidden fields you can use as well to help filter what shows up in your list. I am not going to do this to my CMALOY - Test relationship, but if you look at the "Storage File Shares" relationship or any others out of the box you can get an idea how to use the filters:
Next go back to your applies to table (in my case I used incident) and personalize the incident form related list. Your new relationship is now accessible there:
Check out the form you added the new related list on and voilí :
Cheers.
2 Comments
