Create Report based on list collector field

User659586 · ‎01-26-2021

Hi

I want to create a report that groups and counts projects with same business applications. This field is a List Collector so it can have multiple entries.

What can I do to split this field for reporting purposes?

I tried database views to join project and business application tables because I need the Application Portfolio Manager to filter these projects.

How can I accomplish that?

Thanks!

Maik Skoddow · ‎02-03-2021

Hi @Ricardo Rodrigues ,

I'm afraid it is not that simple, as there is a many-to-many relation between records and tags (aka labels). But due to this fact the tag concept is suitable to your use case (as you cannot create a m2m table for licence reasons)

For more information please see https://docs.servicenow.com/bundle/paris-platform-user-interface/page/use/common-ui-elements/concept...

Kind regards
Maik

View solution in original post

Maik Skoddow · ‎01-26-2021

Hi @Ricardo Rodrigues ,

the answer is not simple, but there is an excellent article that covers exactly your use case: https://community.servicenow.com/community?id=community_blog&sys_id=36ee942edb1304501cd8a345ca961974

Kind regards
Maik

If my answer replied your question please mark appropriate response as correct so that the question will appear as resolved for other users who may have a similar question in the future.

User659586 · ‎01-26-2021

It's a great solution but I can't create a new table because of licensing problems...

Is there any alternative to accomplish this?

Maik Skoddow · ‎01-27-2021

Hi @Ricardo Rodrigues ,

with an additional table for value normalization it is nearly impossible to create the wanted report.

However, I have an idea which I need to implement and test first. It may take a few days.

Kind regards
Maik

User659586 · ‎01-28-2021

Thanks for replying.

I will wait for that idea and your feedback, thanks a lot!