We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

How to group VTB cards by swim lane in a report?

Michael Gruber
Tera Contributor

Hi

 

Not sure if this is the right forum, but couldn't find one about reporting.

 

I want to create a list report that groups visual task board cards, by swim lane.

 

I tried to a list report using the vtb_card table as the data source, but when I try to group by "swim lane" I get zero results (without grouping it shows the cards I want to report on).

Maybe I need to use a different table(?) i.e. Tasks? 

5 REPLIES 5

Srikanth_9
Mega Sage

Hi @Michael Gruber,

 

In ServiceNow, Visual Task Board (VTB) the fields are used to define the swim lanes. This will visually separate the records by grouping.

 

A Swim Lane = a Field Value.

 

For example - Incidents by Assigned to and Assignment group.

 

Navigate to Self-Service > Visual Task Boards > New

Select Data Driven Board 

Select Table - Incident > Vertical Lane Field - Assigned To > Swim Lane Field - Assignment Group

Add the Filter Conditions if needed - Active > is > True - Create.

 

 

Srikanth_9_0-1767673315830.png

 

Srikanth_9_1-1767673330348.png

 

Srikanth_9_2-1767673522004.png

 

 

If the provided solution is working, please Accept as Solution and hit the Helpful. 
 
Thanks & Regards,
Srikanth Akula.

Srikanth,

 

Thank you for your input, however the solution applies to data driven VTBs, what about freeform VTBs (which are the boards I use).

regards

Michael

Hi @Michael Gruber,

 

It is not possible to group Freeform VTB cards by swimlane in a report, because swimlane data is never stored on vtb_card or any related table. 
Only data‑driven boards support reportable swimlanes, because they map swimlanes to actual task fields.
 
 
 
If the provided solution is useful/working, please Accept as Solution and hit the Helpful. 
 
Thanks & Regards,
Srikanth Akula.

Srikanth_9
Mega Sage

 

Hi @Michael Gruber,

 

We can't use different tables because according to the VTB rules:

1. One Base Table only.

2. Can Include Child Tables.

3. Swim Lanes must be from a Common Field.

 

Example:

Task + Incident + Change Task -> Possible.

Task + CMDB CI -> Not Possible.

 

If Tables are Unrelated, Go with:

1. Use Multiple Reports

2. Performance Analytics

 

If the provided solution is working, please Accept as Solution and hit the Helpful. 
 
Thanks & Regards,
Srikanth Akula.