Show multiple "related list" items consolidated in source record table/overview (e.g. user+skills)

[Vespertinus]

Hello SNow Community,

i want to show n related list items of a object in a table overview. Actually i faced this requirement very often in lots of systems and never saw a "good" oob solution for this (besides some T-SQL scripts). Hope SNow can do better .

If you have a referenced (1:1) object you can easily add referenced fields in source records table. But doing same for 1:n related objects (related lists / relationships) seems to be always a problem.

Concrete example: User & Skills. I have enabled skill management (PPS Resourcemanagement) and can related several skills to a user. In SNow it even uses a reference object so you can maintain reference parameters (sys_user_has_skill). First thing customer asks when showing the users lists: "Can i have the related skills as an additional column?". But of course in table config / list layout i cannot select related lists... you can also take users "roles" or "groups" instead of "skills"

Possible custom solution i was thinking about: Adding a new field to users table and run a business rule on sys_user_has_skill table (create, update, delete) to push a consolidated string into it and keep it updated. But this is not really a solution for the requirement (only workaround with redundant data, also having limitations with globalization, etc.)

So is there any oob option to add related lists into list layout configuration? Anyone has another idea for better custom solution?

Thx and br

Vesp

[Sharique Azim]

Hi Vespertinus,

I am not sure, but maybe https://www.servicenowguru.com/system-definition/relationships/creating-manytomany-relationship-serv...     might help you.

Or you can create a new realtionship and use the user table on the desired table.

in the script also gliderecord to the skills table and   push the records in   the array   eg( Change Requests relationship) .

Regards,

Shariq

[Vespertinus]

Hello Shariq,

thanks for your reply and proposal. Actually this helps for creating a relationship (many 2 many) and how to setup. But as you see in the blog entry, they also use "related lists" slushbucket to show them on the form. If you have a record overview you cannot visualize all related information. E.g. have a list overview showing all users including all users roles...(consolidated, separated by "," or anything else)

Any other clues?

Thx and br

Vesp

[Sharique Azim]

Hi,

You can create a m-m table or a custom table to store the relation. And thus the reason, I wanted you to create a new relationship. And in the code part also include the desired glideRecord queries for the desired table.

"

Or you can create a new realtionship and use the user table on the desired table.

in the script also gliderecord to the skills table and   push the records in   the array   eg( Change Requests relationship) .

"

Regards,
Shariq

[LaurentChicoine]

Hi Vesp,

There is a feature for that, Hierarchical lists

However, to use it, you need to use List v2 as it is not yet compatible with list v3.