Related List : same table in two tabs with different filters

[valter479]

I have a request to have two tab on the relate lists pointing to the same table (Project)

Project Tab 1 (all except project on the "on hold" state) and another tab with Project Tab 2 (only project on the "On Hold" state) something like this.

Looks great but the issue I am having is when I create the "Related List Entry" on the Related List input box I put "pm_project.u_committee - On Hold", which surprising, it let me. 

But the issue is when I go to configure -> related list, the selected related list choice is missing the column. 

If i remove the "- On hold" from the "Related List Entry" input box. I can't change the label of the tab 2 to be different from tab 1 in the List Control record.

Is there another way to achieve this?

[Goran WitchDoc · Accepted solution]

Hi,

The reason it doesn't work is that in the field Related list, it wants to have "table_name.field" and when you add " - on hold" it breaks. To do what you want and a custom title, you need to create a new relationship. There you define the name and how the two tables are related to each other.

You can read more about it here: Create defined related lists

Let me know if you need more help.

//Göran
Feel free to connect:
LinkedIn
Subscribe to my YouTube Channel
or look at my Book: The Witch Doctor's Guide To ServiceNow

[Valentyn]

If you create a tab using Relationship, the tab will display the information, but you will not be able to edit it (add user to groups, etc.)
So, to create multiple independent tabs on same M2M table you can create several exactly same M2M tables with different names. Thus you will have a new tab for each of them