The default from fossil.
I've also been reading Michael Owens book about about SQLite so this
makes sense now.
Title: Baisc
Owner: anonymous
SQL:
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(tkt_mtime) AS 'mtime',
type,
status,
subsystem,
title,
comment AS '_comments'
FROM ticket
--jim schimpf
On 20 Feb, 2009, at 11:12, D. Richard Hipp wrote:
On Feb 20, 2009, at 10:50 AM, verizon wrote:
Hi,
I've been adding problem tickets to my repositories and doing
resolutions or them but recently have noticed that with the standard
report and display the comments on these tickets are not showing.
What SQL are you are using for your "standard report"? Are you
querying
for the "comment" column of the TICKET table?
D. Richard Hipp
d...@hwaci.com
_______________________________________________
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
_______________________________________________
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
