Flyspray - The bug killer!

  • Status Unconfirmed
  • Percent Complete
    0%
  • Task Type Feature Request
  • Category User Interface
  • Assigned To No-one
  • Operating System All
  • Severity Medium
  • Priority Very Low
  • Reported Version 1.0-rc
  • Due in Version Undecided
  • Due Date Undecided
  • Votes
  • Private
Attached to Project: Flyspray - The bug killer!
Opened by Dominik Meyer - 13.12.2016

FS#2323 - show category tree in task list

we should show the category tree in the task list.
in the task we show the tree.

e.g. “Parent → Sub” instead of “Sub”

Project Manager
peterdd commented on 14.12.2016 04:39

Note for implementers:

Possible with an extra ‘case’ within scripts/index.php for render the category cell, category_id provided by get_task_list() results needed:

Untested for the nested set model used for flyspray’s categories: 

SELECT parent.category_name
FROM {list_category} AS node, {list_category} AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.category_id=?
AND parent.project_id=node.project_id -- several trees of categories stored in the table (global and 1 for each project)
AND parent.lft >1  -- we do not neet the root node
ORDER BY parent.lft

and with GROUP_CONCAT() (Mysql, similiar should be possible for postgresql too) 

SELECT GROUP_CONCAT(parent.category_name SEPARATOR ' : ') AS category_path
FROM {list_category} AS node, {list_category} AS parent
WHERE node.lft BETWEEN parent.lft AND parent.rgt
AND node.category_id=?
AND parent.project_id=node.project_id -- several trees of categories stored in the table (global and 1 for each project)
AND parent.lft >1  -- we do not neet the root node
ORDER BY parent.lft

But: 1 extra sql query needed for each row in the tasklist. So with the current max of 250 rows max 250 extra sql queries.

Research if possible to put it bugfree and without substantial performance loss to current within the big query of get_task_list() in class.backend.php

Non-programmer solution: Put the name of parent category as prefix to sub category’s name too. Never a possible performance problem, but extra admin work if you rename the parent categories. :-P

Loading...

Available keyboard shortcuts

Tasklist

Task Details

Task Editing