Action: #qryTaskDetail.taskdescription#
Status ---> checked> Pending checked> Complete checked> Cancelled
<cfoutput>#qryTaskDetail.tasknotes#</cfoutput>
Due Date

select tsk.taskdescription, tsk.disposition, tsk.duedate, tn.tasknotes, tsk.reminderdays from tbl_wrk_tasks tsk left outer join tbl_wrk_tasknotes tn on tn.taskid = tsk.taskid where tsk.ownerid = and tsk.ownertype = and tsk.taskid = select * from qmd_taskTemplates order by sortOrder, taskDescription