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 can also suggest to create a database view on skills and sys_user   tables. In the where clause of the user, use something like usr_sys_id= skl_user .   Add table fields like inherited from(referencing sys_user_group),users , skills and etc for skills.

Similarly, add fields like user id, display name,company and etc for the user table.

I hope this helps, try and reach back to us.

Refer :http://wiki.servicenow.com/index.php?title=Database_Views , Creating a database view   for more info.