Is it possible to report on checklist items associated with a task on a visual task board.

[tonyk]

I'm attempting to use a visual task board as part of a scrum initiative and each card will represent a story and associated tasks are being documented using checklists on the task card.   In order to create visibility for the team I also created several reports and a dashboard.   I want one of the reports to include the associated checklist tasks but I can't get to any checklist fields from the task table.   I did find the checklist table itself but the checklist items dont appear to associate back to the task so I can't separate those checklist items from other non-related checklist items used on other task boards.

Does anyone know how to do this?

[She Sull · Accepted solution]

Yes, you can run a report on the checklist_item table.

[tonyk]

thanks I realize theres a checklist item table but I cant figure out how to select only those checklist items associated with a specific task or visual task board.

[She Sull]

You can only get to the task the checklist is on from the checklist item table so you may need to create a database view to get the task board as well:

[juliesutton]

Has anyone created this database view?   I'm new to that side of things and not sure what the statement should look like.   I know the checklist is related to the visual task card through the "document' field and the card is related to the task board through the board field.   What I'm looking for is a roll up of all checklist items associated with a task board by completion status.   Basically a "how much do I have left to do" metric.

- Julie