Unable to find relationship of relate list

[Sachin G K1]

Hi All,

I added on Related list "Outage" for incident as you can see in below picture, but i am unable to find relationship of this related, I really want to know how this related list working, and how it is created.

Thanks,

Sachin

[Danish Bhairag2]

Hi @Sachin G K1 ,

Just try to right click on the breadcrumbs/filter under outages tab it will open up the table for u.

If any m2m table open that means there is a Many to many relationship created between outage n incident table.

If directly the outage table open then there is no specific relationship created. it's just the field present in outage table have incidents field which is referencing to incident table.

Thanks,

Danish 

[Sachin G K1]

Hi Danish,

Its not m2m table, i want to gain in-depth understanding of this.

How above highlighted related list configured, suppose if i want to create similar related list to relate incident with new table 'y',how to do it.

[AndersBGS]

Hi @Sachin G K1 ,

the related list outage is related to the table task_outage where there is a m2m relationship between task table and cmdb_ci_outage table.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Arpan Baishya]

Hi @Sachin G K1,

Here's what I found.

For that related list, click on Column Options (the three dots) on any column and go to List Control. You will find some information such as the Label for the list among other List behavior information.

Under List Control, I saw that the Related list field is populated as "task_outage.task". Then, I went to the Relationships table to search if there is any related list which queries from the "task_outage" table. I didn't get any matches which makes me think what @Danish Bhairag2 said may be correct. 

"If directly the outage table open then there is no specific relationship created. it's just the field present in outage table have incidents field which is referencing to incident table."

This is how a typical task_outage record looks like.

And if you go to the actual Outage [cmdb_ci_outage] record, you'll see the Task number field over there as well.

Hope this helps.