Create Report based on list collector field

[User659586]

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]

Hi @Ricardo Rodrigues ,

I thought hard about it and considered using the tags. Every time a value for "Business Applications" is added, a tag with the same name is also added in the background. 

What sounds simple at first is a bit more complex in practice and I don't have the time to develop it right now.

But maybe you can do something with this approach.

Kind regards
Maik

[User659586]

Thanks I will try that solution but how can I access the "Tag" field?

Can I simply do, for example, project.tags ?

[Maik Skoddow · Accepted solution]

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

[User659586]

I think it's a great solution, I tried it joining multiple tables and shows exactly what I want! Thanks a lot!

[Maik Skoddow]

Thanks for the feedback and glad to help you!

Kind regards
Maik