VTB not showing ON HOLD filter.

CJPeterson
Tera Expert

Hi All, 

Could someone advice on why certain filters wouldnt show up when creating a Visual Task Board. I want to populate incidents ON HOLD but that option is not showing in the filter list. 

 

The current filters i have : Assignment group = L2_CLOUD_INFRA, Active, State in (Pending, Open, Work in Progress, Assess, Functional Review, Tower Review, GCAB ), [...], Task type = Incident .or. Task type = Catalog Task .or. Task type = Problem .or. Task type = Change Request 

 

CJPeterson_0-1686336236288.png

CJPeterson_1-1686336256326.png

 

1 ACCEPTED SOLUTION

arielgritti
Mega Sage

Hi @CJPeterson 

You're filtering on the task table. The task table doesn't have "On hold" as a sys_choice value. The "On hold" choice is on the incident table.

I created a VTB from scratch adding an additional "OR" clause filtering by the incident.state field and the "On hold" state is there.

 

arielgritti_0-1686385654425.png

 

Please mark helpful or correct if I helped you.
This action will help other members with similar issues to find a solution.
Thanks
Ariel

View solution in original post

2 REPLIES 2

arielgritti
Mega Sage

Hi @CJPeterson 

You're filtering on the task table. The task table doesn't have "On hold" as a sys_choice value. The "On hold" choice is on the incident table.

I created a VTB from scratch adding an additional "OR" clause filtering by the incident.state field and the "On hold" state is there.

 

arielgritti_0-1686385654425.png

 

Please mark helpful or correct if I helped you.
This action will help other members with similar issues to find a solution.
Thanks
Ariel

SinghBalwant
Kilo Guru

Hi @CJPeterson ,

In one of my previous projects, I developed a similar Virtual Table Builder (VTB) feature. To use it, you simply need to choose a table and select your desired state(s) (you can choose multiple states). The selection of state can be made in the vertical lane field.

I have provided a screenshot of the structure for reference, so you can create the VTB accordingly.                     

 

Please inform me if my feedback was useful and if it resolved your issue. If it did, please click the "Helpful" button below.

Thank you for your valuable feedback! It helps me enhance my responses and serve you better in the future.