[prev in list] [next in list] [prev in thread] [next in thread]
List: fossil-users
Subject: Re: [fossil-users] What happened to my tickets...
From: verizon <vze35xda () verizon ! net>
Date: 2009-02-20 16:40:25
Message-ID: 5ED4DFAC-D515-4E19-9E27-E0B0EADDACC6 () verizon ! net
[Download RAW message or body]
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
> drh@hwaci.com
>
>
>
> _______________________________________________
> fossil-users mailing list
> fossil-users@lists.fossil-scm.org
> http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
[Attachment #3 (text/html)]
<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; \
-webkit-line-break: after-white-space; "><div><br></div>The default from fossil. \
<div><br></div><div>I've also been reading Michael Owens book about about \
SQLite so this makes sense now.<div><br></div><div><span class="Apple-style-span" \
style="font-family: 'sans serif'; font-size: 16px; "><table cellpadding="0" \
cellspacing="0" border="0" style="position: static; z-index: auto; "><tbody><tr><td \
valign="top" align="right">Title:</td><td width="15"></td><td \
colspan="3">Baisc</td></tr><tr><td valign="top" align="right">Owner:</td><td></td><td \
colspan="3">anonymous</td></tr><tr><td valign="top" \
align="right">SQL:</td><td></td><td valign="top"><pre>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</pre></td></tr></tbody></table><br></span></div><div><span \
class="Apple-style-span" style="font-family: 'sans serif'; font-size: 16px; "><span \
class="Apple-tab-span" style="white-space:pre"> </span>--jim \
schimpf</span></div><div><font class="Apple-style-span" face="'sans serif'" \
size="4"><span class="Apple-style-span" style="font-size: \
16px;"><br></span></font></div><div><div><br><div><div>On 20 Feb, 2009, at 11:12, D. \
Richard Hipp wrote:</div><br class="Apple-interchange-newline"><blockquote \
type="cite"><div><br>On Feb 20, 2009, at 10:50 AM, verizon wrote:<br><br><blockquote \
type="cite">Hi,<br></blockquote><blockquote type="cite"><span class="Apple-tab-span" \
style="white-space:pre"> </span>I've been adding problem tickets to my repositories \
and doing<br></blockquote><blockquote type="cite">resolutions or them but recently \
have noticed that with the standard<br></blockquote><blockquote type="cite">report \
and display the comments on these tickets are not showing.<br></blockquote><br>What \
SQL are you are using for your "standard report"? Are you querying<br>for the \
"comment" column of the TICKET table?<br><br>D. Richard Hipp<br><a \
href="mailto:drh@hwaci.com">drh@hwaci.com</a><br><br><br><br>_______________________________________________<br>fossil-users \
mailing list<br>fossil-users@lists.fossil-scm.org<br>http://lists.fossil-scm.org:8080/ \
cgi-bin/mailman/listinfo/fossil-users<br></div></blockquote></div><br></div></div></div></body></html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic