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

Community Alums · ‎05-16-2022

Hi ,

I have a similar requirement , could you brief what all steps were done to achieve it ? list collector value to be populated in tags field by BR/schedule job ? then was any database view also created ? for reporting purposes.