Allow to list projects which use a specific task type

[philippotto]

Link to Discuss

In the task types view, there should be a "view projects" button for each task type which lists the projects which use said task type.

Maybe, this can replace the "view" function (we need to clarify whether there aren't users that need this feature).

[MichaelBuessemeyer]

either new view or integrate it into the project list view

[fm3]

A difficulty is that projects don’t have a specific task type. Tasks do. So to determine the projects for a given task type, we have to join all the tasks. Seems to be acceptably fast, though.

select p.name
from webknossos.projects_ p
join webknossos.tasks_ t on t._project = p._id 
join webknossos.taskTypes_ tt on t._taskType = tt._id
where tt._id = 'myTaskTypeId'
group by p.name