Task Titlequery for information
StatusIn Progress
Last Updated2017-04-05 20:46:51
Sched start date:
Actual start date:2016-08-24
Sched completion date:
Actual completion date:
Estimated Hours
Actual Hours0
Owners
wbhauck
Product
ProjectProject Useful Version 1
Storytoday's updates
Description

select task_assignments.task_id, task_status_types.alive, tasks.task_status_type_id, tasks.title from task_assignments, tasks, task_status_types where task_assignments.user_id=2 and tasks.id = task_assignments.task_id and task_status_types.alive = 1 and tasks.task_status_type_id = task_status_types.id;

Notes

Comments

UserDateHoursComment
wbhauck 2016-08-26

select tasks.id as TID, task_comments.id as TCID, task_comments.comment from task_comments, tasks, task_status_types where task_comments.task_id = tasks.id and tasks.task_status_type_id = task_status_types.id and task_status_types.alive =1 order by tasks.id;