#25 Modified version of bug_list.cs, for "tasks" column

[Johnny T. Li]

Thanks for great app.

Using it I come across the following.
_________________________
Curerntly "to view tasks" requires user to enter the edit_bugs.aspx -> click on tasks/time link

Then to edit the task the user needs to click on edit.

It would be nice to see the tasks in the bugs.aspx and click on a link to edit that task.

________________________________________________

I add a query to show the task in the bugs.aspx as follows

************************
select isnull(pr_background_color,'#ffffff'), bg_id [id],tsk_id [task id], isnull(fl_flag,0) [$FLAG], bg_short_desc [desc], tsk_description [task], tsk_planned_duration [planned duration], tsk_actual_duration [actual duration], tsk_percent_complete [% complete],isnull(pj_name,'') [project], isnull(og_name,'') [organization], isnull(ct_name,'') [category], isnull(asg.us_username,'') [assigned to], isnull(st_name,'') [status]
from bugs
left outer join bug_user_flags on fl_bug = bg_id and fl_user = $ME
left outer join users rpt on rpt.us_id = bg_reported_user
left outer join users asg on asg.us_id = bg_assigned_to_user
left outer join users lu on lu.us_id = bg_last_updated_user
left outer join projects on pj_id = bg_project
left outer join orgs on og_id = bg_org
left outer join categories on ct_id = bg_category
left outer join priorities on pr_id = bg_priority
left outer join bug_tasks on bg_id = tsk_bug
left outer join statuses on st_id = tsk_status
order by bg_id desc
************************

and modify some code to treat [task] similar to [desc] so that it will return a link to edit_task.aspx

[Johnny T. Li]

File Added: bug_list.cs

[Johnny T. Li]

modified to treat task similar to desc to create link to task

[Johnny T. Li]

File Added: bug_list.cs

[Corey Trager]

How don't understand your code change. The bug/task relationship is one-to-many, so how can there be a task column in the bug list? What happens when there are 2 tasks? Do you have the same bug listed twice?

[Johnny T. Li]

File Added: list_tasks.JPG

[Johnny T. Li]

yes bug list once for each task - see image

[Corey Trager]

I see the screenshot, but again, what happens when you have two tasks for the same bug?

[Johnny T. Li]

m...

Given: bug A with task 1 and task 2, the disply would be
__________________________
bug A, task 1
bug A, task 2
__________________________

It don't matter if the bug has 0 or n tasks.

The point is to see them and able to access them in the bug list.

If if bug is display n times for the n tasks that are associate with it, that is still good, because we can see that.