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

Sreeram Nair · ‎01-11-2025

Alternatively, On the list of records, you can locate and right-click on the Resolved value, select Filter Out.

ɪꜰ ᴍʏ ᴀɴꜱᴡᴇʀ ʜᴀꜱ ʜᴇʟᴘᴇᴅ ᴡɪᴛʜ ʏᴏᴜʀ Qᴜᴇꜱᴛɪᴏɴ, ᴘʟᴇᴀꜱᴇ ᴍᴀʀᴋ ᴍʏ ᴀɴꜱᴡᴇʀ ᴀꜱ ᴛʜᴇ ᴀᴄᴄᴇᴘᴛᴇᴅ ꜱᴏʟᴜᴛɪᴏɴ ᴀɴᴅ ɢɪᴠᴇ ᴀ ᴛʜᴜᴍʙꜱ ᴜᴘ.

ʙᴇꜱᴛ ʀᴇɢᴀʀᴅꜱ

ꜱʀᴇᴇʀᴀᴍ