Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Report of tasks not on Freeform VTB

smathews8726166
Tera Contributor

I have created a Freeform Visual Task Board.  I manually assign tasks assigned to my Assignment Group to the VTB. I would like to create a report listing all tasks that are assigned to my Assignment Group that are not on the VTB board. Can anyone help with the report query ?

1 REPLY 1

James Chun
Kilo Patron

Hi @smathews8726166,

 

When you create tasks from the Freeform VTB, they are saved in the Private Task [vtb_task] table.

 

Normally you would assign it only to yourself, but if you are looking for a query to filter out the Private Tasks assigned to one of your groups, you can simply exclude the table in the condition, e.g.

JamesChun_0-1719174588914.png

 

Cheers