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