Here is a request which would for instance display the "Feature Request" tickets, with a description field which would be either the old "comment", either from the new TICKETCHNG table:
SELECT
CASE WHEN status IN ('Open','Verified') THEN '#f2dcdc'
WHEN status='Review' THEN '#e8e8e8'
WHEN status='Fixed' THEN '#cfe8bd'
WHEN status='Tested' THEN '#bde5d6'
WHEN status='Deferred' THEN '#cacae5'
ELSE '#c8c8c8' END AS 'bgcolor',
substr(tkt_uuid,1,10) AS '#',
datetime(ticket.tkt_mtime) AS 'mtime',
datetime(min(ticketchng.tkt_mtime)) AS 'ttime',
type,
status,
subsystem,
title,
coalesce(comment,icomment) AS '_Remarks'
FROM ticket
LEFT JOIN ticketchng ON ticket.tkt_id=ticketchng.tkt_id
WHERE status='Open' AND type='Feature_Request'
GROUP BY ticket.tkt_id
ORDER BY ticket.tkt_mtime
This is what is used in our source code repository.
By the way, we did enhance the mORMot official project
RoadMap to list only the main features on which we are currently working,
then push all feature request to-do list as corresponding tickets.
Our future may sound more easy to guess now.
Feedback is welcome in our forum, as usual!
