Smarter sidebar
Add the following to one to the appropiate model after releasing 1.04.
select p.name, p.id, COUNT(t.project_id) AS count FROM projects p, todos t
WHERE t.project_id IS NOT NULL AND t.done=0
AND p.done h1. t.project_id GROUP BY p.id;
}}}
Consider moving the sidebar management into a seperate controller. This might allow us to set up some clever OSX/dashboard widgets or small popups.
Select the above for a list of projects by:
{{{
p.id IN #{projectids.join(",")}
Leave a comment