[TRAC] Provide a more comprehensive "Related to current user" ticket query / report

[ax]

the current "Related to current user" ticket query / report is of limited use to me, as it only includes open tickets that i am the owner or reporter of (i'm seldom the owner because i cannot commit). it would be much more useful to me if it would also include tickets that i commented on or am in the cc, and also all closed tickets. trac's cookbook ​has such an report. i would appreciate if this report (including the first change: include tickets that the user made any changes to ...) could be added to josm.openstreetmap.de.

on a related note: i think it would make sense to add a component website (or trac) for issues like this one.

[stoecker]

Added. Please tell if result is reached. For me the result is to show nearly everything ;-)

Close report when ok.

[ax]

Replying to stoecker:

Added. Please tell if result is reached. For me the result is to show nearly everything ;-)

yes, was expecting this :) for me, it is only 8 tickets. very useful!

one little addition that would be nice to have would be an extra sort column, after closed and priority, by last modified, desc. ie.

  ORDER BY
    (status = 'closed'), 
    (CASE status
       WHEN 'closed' THEN changetime
       ELSE (-1) * CAST(p.value AS int)
    END) DESC,
    changetime DESC

how about "adding a trac component website (or trac) for issues like this one"?

thanks!