Many to Many table not appearing in the Configure -> Related Lists option

matthew_hughes
Kilo Sage

I have table called 'Markets Requests' and these are the current related lists that appear:

 

Markets Related lists.png

 

I'm wanting to add another related list that creates a relationship between a Markets Request record and multiple CIs in the cmdb_ci table.

 

In a Scope called 'Markets', I've created a Many To Many Definition by stating the below:

Many to Many Definition.png

This then creates my m2m table 'Markets requests Configuration Items':

Many to Many table.png

 However, when I go back to the 'Markets Requests' table and click on the 'Configure -> Related Lists' option, the m2m table 'Markets requests Configuration Items' is not appearing in the available options:

 

Related List options.png

 

I was just wondering why the m2m table is not appearing in the available options. Is it related to cross scoping or is it something else?

 

Ideally, I'd like to be able to build relationships between a markets request and multiple configuration items, the same way the Affected CIs tab is set up on normal type Change records:

Affected CIs out of the box.png

1 REPLY 1

Ahmmed Ali
Mega Sage

Hello @matthew_hughes 

 

I did replicated same in my PDI with different scope as well, the difference is that you will see the relationship with field name actually instead of table name.

 

i.e you will see "Configuration Items" in related list in your request table and in cmdb_ci table, you will see relationship with name as Market requests.

 

AhmmedAli_0-1686813688508.png

 

AhmmedAli_1-1686813712983.png

 

Thank you,

Ali

 

If I could help you with your Query then, please hit the Thumb Icon and mark my answer as Correct!!

Thank you,
Ali