How can I filter on CTASK and TASK states for VTB sourced from [task] table?

jobzombi
Giga Contributor

‎11-22-2022 09:59 AM

I’m creating a VTB for incident, custom sc task, from a custom form, and change task tracking. Incident I got from Incident.IncidentState but I can’t for the life of me find the same for the other two. Change Task does not have the state field and I can’t find anything for Catalog Task either. I’m looking to set lanes according to states and I want to filter with “is one of“ for specific states. The Task State and State filters are too broad and I get too many items on the board.

0 Helpfuls
  • 644 Views
2 REPLIES 2

Sagar Pagar
Tera Patron

‎11-22-2022 10:03 AM

Hi @jobzombi,

Have you try with Task type field/column in filters?

 

Thanks,

Sagar Pagar

The world works with ServiceNow
0 Helpfuls

jobzombi
Giga Contributor
In response to Sagar Pagar

‎11-22-2022 12:39 PM

FiltersVTB.png

 

That is the current filter that I am using...

 

I am already filtering by task type Change Task and Incident and a custom form from of type Catalog Task; Prod Ops Request.  The issue is that for the above three task types, I only care for the following:

 

VTBStates.png

 

I don't care for Closed, Closed Completed and Resolved, but if I try to include the [task] parent state of anything Closed (eg Closed Skipped), it ends up including "Closed", which results in over 800 entries for the last 3 months.  For Incident I was able to narrow it down to "Incident.Incident state", but can't find the same for CTASKs and TASKs:

 

ChangeTask.png

0 Helpfuls