Solved: How can I filter if the report and the filter are ... - ServiceNow Community

Hello Everyone!

I have, in a dashboard, a list report about business services.
I have other reports about demand, projects..
With an interactive filter, I filter the tasks that have the business service selected. That's fine.

The question is: how I filter the list report make on the business service table?
When I try to create Interactive Filter Reference on the business service table, I have this error:

How can I filter if the report and the filter are on the same table?

thanks in advance,

Giacomo

18 KB

2,597 Views

1 ACCEPTED SOLUTION

I had this come up a few times, and finally was able to find the original answer that explains how to fix it:

How to create interactive filter based on the incident numbers

The Cliff's Notes are that you'll have to export the XML record and re-import it to allow you to pick sys_id for the same table. It works perfectly, but the UI prevents a self-referencing interactive filter. This is something that you should work with in Dev, in an update set, and then promote through Change Control once it's working.

It would also be great if you could submit a ticket for this on HI, so that we can get your company on the list of people who've asked for this Enhancement. The more customer names on the list, the more likely it will get fixed and you won't have to go through these steps to do it in the future.

Something I glossed over in that initial response - you'll be editing two different XML files - the main interactive filter record to change it back from 'number' to 'sys_id', and then the Interactive Filter Reference record to change from whatever table you selected back to 'incident'

Hopefully this helps!

edit: I want to note though, this is would be for self-referencing interactive filters, like being able to filter a list of incidents to only include these specific incidents. If you're trying to add a filter on Business Service table, to filter the Business Service table to only a few Business Services that you choose, then this is what you want.

If you're trying to filter different tables (incident, outage, change, problem) by business service, then that's a different thing.

View solution in original post

7 REPLIES 7

Hello,

Should the Reference field be Configuration Item or CI on the task?

Thanks!

What do you want to filter based on the table you filter on?

I cannot understand the idea here.

When you filter ticket tables based on the same business service field it will work.

Hello, I would like to filter a report with a filter defined on the same report table.

I had this come up a few times, and finally was able to find the original answer that explains how to fix it:

How to create interactive filter based on the incident numbers

The Cliff's Notes are that you'll have to export the XML record and re-import it to allow you to pick sys_id for the same table. It works perfectly, but the UI prevents a self-referencing interactive filter. This is something that you should work with in Dev, in an update set, and then promote through Change Control once it's working.

It would also be great if you could submit a ticket for this on HI, so that we can get your company on the list of people who've asked for this Enhancement. The more customer names on the list, the more likely it will get fixed and you won't have to go through these steps to do it in the future.

Something I glossed over in that initial response - you'll be editing two different XML files - the main interactive filter record to change it back from 'number' to 'sys_id', and then the Interactive Filter Reference record to change from whatever table you selected back to 'incident'

Hopefully this helps!

edit: I want to note though, this is would be for self-referencing interactive filters, like being able to filter a list of incidents to only include these specific incidents. If you're trying to add a filter on Business Service table, to filter the Business Service table to only a few Business Services that you choose, then this is what you want.

If you're trying to filter different tables (incident, outage, change, problem) by business service, then that's a different thing.