[Tcllib-devel] Configuration of fossil tickets in tcllib

[Torsten B. <be...@ty...>]

Hi,

I noticed that it is not always easy to find the tickets for a logged-in user.

While the ticket report "All Submitted By Me" does list the correct ones, the report "My tickets" doesn't. Instead, it lists all tickets submitted by 'gahr' only (maybe because this person is the owner of the ticket report).

I was assuming this report would list all tickets a user is associated with in terms of being a submitter, assignee or closer (there's no ticket for that). I suggest to change the ticket name to something like "All tickets I am associated with" (or something else along these lines) and to change the SQL to this:


SELECT
CASE WHEN status='Open'    THEN '#f2dcdc'
     WHEN status='Deleted' THEN '#bde5d6'
     WHEN status='Pending' THEN '#cacae5'
     WHEN status='Closed'  THEN '#c8c8c8'
     ELSE                       '#ffffff'
END AS 'bgcolor',
substr(tkt_uuid,1,10) AS '#',
datetime(tkt_mtime)   AS 'Last Changed',
type                  AS 'Type',
status                AS 'Status',
subsystem             AS 'Subsystem',
title                 AS 'Summary'
FROM ticket
WHERE (submitter = $login OR assignee = $login OR closer = $login)
order by tkt_mtime DESC


If that is too much (as some people may have closed or assigned a lot of tickets) I suggest to leave out the closers or restrict this to open tickets.


Also, when searching tickets using the search form that comes up when clicking on the "Tickets" menu, it is unclear what and where the search is done. I would have expected to get this ticket listed:

https://core.tcl-lang.org/tcllib/tktview?name=7bca91a31c

when searching for "markdown" as it has the string in the summary field, but it is not on the result list.

These are probably all just minor things but thank's for considering anyway :-) 


Regards, Torsten