Define related list linking a custom table for a given set of CI classes

[PratyushaBodepu]

Hello all,

We have a requirement to add a related list linking records from a custom table to a given set of CI classes(around 60 odd CI classes).

The custom table has a reference field pointing to the cmdb_ci table.

I was looking for an easier way to add the related list to all those CIs at once and for that, I have found that we can script the Apply to table and Query from table in the sys_relationship table by clicking on the Advanced checkbox. Please find the attached image. 

I'm having trouble achieving this configuration, please throw some light on these script fields' usage.

@Allen Andreas

@Ankur Bawiskar

#cmdb #relatedlists #itsm

Best Regards,

Pratyusha

[Ankur Bawiskar]

@PratyushaBodepu 

why are you using advanced script?

[PratyushaBodepu]

Hi Ankur, 

I was doing it for the first time and was not aware of its usage. For this specific functionality, I thought If I can figure out how to use this advanced script here, I wouldn't need to go to all these CI class forms and add the related list.

As I went on with this research, I found out that we can add the automatically created related list to the form as the tables are already related, but even in this case, we'd have to add the related list manually to all the forms. My attempt was more to find out if there is a way to automatically do it any other way instead of manually changing it in those selected CI Class forms.

Best Regards,

Pratyusha