Interactive filter - Filtering total incidents by company name in core_company table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-08-2025 11:56 PM
Hi - I wanted to create an interactive filter where I can filter the total number of incident created and closed by each supplier. The supplier data is available in company table (core_company) and I know I need to create a reference type filter which is not working for me. Can anyone guide me how to achieve this, please?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-09-2025 04:26 AM
Then you need to dotwalk through the assigned to-field to the company field on the user table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-09-2025 12:51 AM
Can you please share the interactive filter you created?
Did you add the interactive filter reference?
The above setup will apply the filter on your report for the reference fields you define here.
Adding link for reference : Create a reference field interactive filter
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-09-2025 03:28 AM
Thank you for the response. Here is my interactive filter,
Interactive Filter references:
Unfortunately, there is no direct relationship between incident table and company table in our instance of service now. We will have to go through assigned to -> User table -> Company. The Company field in the incident table is set as blank in our system.
Thanks
Fareeth
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-09-2025 03:32 AM