question Creating a report to show Incidents without Interactions in Community Central forum

Creating a report to show Incidents without Interactions

SimonHind — Fri, 18 Jul 2025 22:15:38 GMT

I am trying to generate a report for the dashboard that allows me to see Incidents without Interactions

Re: Creating a report to show Incidents without Interactions

GlideFather — Fri, 18 Jul 2025 22:34:50 GMT

and can you please show us what you tried?

The interactions are stored in [interaction] table incidents in [incident] eventually [task] and if an incident is created from an Interaction, this relationship is stored in [interaction_related_record].

So you can query all the incidents that AREN'T in this table interaction_related_record, because if they are then it means they have an interaction associated. It could be possible to use GlideAggregate instead of GlideRecord as you want to get just number without any data manipulation to it.

And don't forget to add some period of time - all incidents created in last 30 days etc...

Share us here your progress

Re: Creating a report to show Incidents without Interactions

GlideFather — Fri, 18 Jul 2025 22:45:29 GMT

@SimonHind the script below might be beautified but it works and could serve as an inspiration:

In my PDI I set encoded query on 5 incidents where only 1 has interaction, remaining 4 don't:
(your condition will be different - created in last 30D, 7D, has this or that category, assignment group etc.)

Let me know what do you think and if this helped you and my efforts were not for nothing :))

Re: Creating a report to show Incidents without Interactions

SimonHind — Fri, 18 Jul 2025 23:31:11 GMT

This is my basic Report using the Interaction related Record

it shows ID of related record with Incident: INC#######

166 in total, however if I switched to Incident table

ideally what I am looking for is all Incidents where there are no Interactions, so i hope my Interaction related Record is correct for this

Re: Creating a report to show Incidents without Interactions

AndersBGS — Sat, 19 Jul 2025 06:37:13 GMT

Hi @SimonHind ,

You just need to add a related list condition like below: