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 Hours4.5
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 2019-05-02 1.0

worked on it

wbhauck 2019-05-02 2.0

did stuff

wbhauck 2019-05-01 1.5

more work

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;