how to exclude the resolved tickets in task table filter?

sowmyab · ‎03-15-2017

I want to exclude the Incident -Resolved tickets in Task table Filter.

I tried with incident state and incident.incident state is not "resolved" - this is not working(Still i'm able to see the resolved tickets in list view.)

If i use state is not "scheduled" then its working ( not showing resolved tickets and scheduled tickets as well.)

But i need to show the scheduled tickets., so i can't use that option in filter.

please refer screenshot.

So Is there any filter to add to get solution for the above, please help me out if anyone knows

Thanks,

Shiva Thomas · ‎03-16-2017

Hi Sowmyab,

On my instance, this is the filter we use for exactly the same purpose you're trying to achieve:

All active tasks are visible, excluding resolved incidents.

The trick is to allow tickets with empty value in Incident State, else will not list non incidents records.

active=true^ref_incident.incident_state!=6^ORref_incident.incident_stateISEMPTY^assignment_groupDYNAMICd6435e965f510100a9ad2572f2b47744

I hope this help.

Shiva, from Switzerland

Please Hit like, Helpful or Correct depending on the impact of the response

View solution in original post

vinitha3 · ‎03-15-2017

Hi,

Just give,

Status is not 'Resolved" for status filter.

Since you have given active = true, closed incidents will not come.

Thanks,

Vinitha.K

Please Hit like, Helpful or Correct depending on the impact of the response

sowmyab · ‎03-16-2017

Thank You,

There is no status field in Task Table.

In state - we don't have the "resolved" option.

vinitha3 · ‎03-16-2017

If you want only tickets you can directly report on Incident table, right?

so, what is your requirement?

sowmyab · ‎03-16-2017

We created one module i.e., MY group work - (it includes the all tickets ie., incidents, change request, catalog task) - Task table

I need to add the filter for that you can refer the below screenshot.