Tasks list could have a more clear order

[Christopher Adams]

The tasks list is currently ordered by the query:

SELECT *, ppl_tasks.id AS task_id FROM ppl_tasks, ppl_task_types WHERE ppl_tasks.type = ppl_task_types.id AND ppl_tasks.assigned_to = [userid] ORDER BY ppl_tasks.status DESC, creation_date DESC limit 10

This ensures that the tasks are ordered by status from top to bottom: Updated, Start, Completed

It might be more clear if the tasks are shown in this order

Tasks that are of type "update" or "new" are ordered by creation date, newest at the top.

Tasks that are of type "completed" are always at the bottom.

[Christopher Adams (christopheradams)]

The bug that this needs to fix is that the "Find Portraits" task is added as "new" with a "Start" button but ends up below "Update" tasks like sync photostream.

[Christopher Adams (christopheradams)]

Change the order to:

ORDER BY creation_date DESC, ppl_tasks.status DESC limit 10