How to create a report based on a GlideList field of a change table?

chilakalasa · ‎03-30-2026

I'm working on a requirement to show reports on a dashboard for change requests. I'm able to create simple single score cards and bar graphs through standard reporting.

However, there's a report requirement where I need to create a report based on GlideList. Each change can have field that is of GlideList type. I've to create a bar graph to represent list of changes per element (cmdb_ci_site) in the dashboard.

Change	Sites (GlideList)
CHG001	SITE-A, SITE-C
CHG002	SITE-A, SITE-B, SITE-C
CHG003	SITE-B, SITE-D
CHG004	SITE-A, SITE-C, SITE-D

Site	Changes
SITE-A	3 (CHG001, CHG002, CHG004)
SITE-B	2 (CHG002, CHG003)
SITE-C	3 (CHG001, CHG002, CHG004)
SITE-D	2 (CHG003, CHG004)

I've looked at using scripted indicator sources (Needs PA license) or DB view based reporting. Is there a simpler approach to implement this?

Thanks in Advance!

Teja

Mark Manders · ‎03-30-2026

Yes, approach it from the 'site' table. With a bit of luck you already have a 'related list' that shows you the changes. You can use related list conditions to get the changes per site that way.

If it's really about the numbers, a data base view will be needed.

Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

chilakalasa · ‎03-30-2026

Hi @Mark Manders

The problem is that it's a glide list. I'm not sure if we can create a related list out of it. Also, we are looking for analytics to see how many changes are associated with each site out of the dashboard.

DB view seems to be the way as of now. Thank you for your inputs. Appreciate it.

Regards

Teja

chilakalasa · a month ago

Hi @Mark Manders ,

Can you suggest how we can create a view based on a GlidList as the String operators are not accessible in the WHERE clause? I've used >= but didn't have any success with that approach.

Thanks in advance!

Regards

Teja