Re: [fossil-users] ticket status coloring

2011-01-11 Thread Richard Hipp
On Tue, Jan 11, 2011 at 9:08 PM, Ron Wilson ronw.m...@gmail.com wrote:

 I am new to Fossil and have been experimenting with configuring it.

 then I updated the SQL:
 SELECT
  CASE WHEN status='New' THEN '#f2dcdc'
   WHEN status='Accepted' THEN '#f2dcdc'
   WHEN status='Planned' THEN '#f2dcdc'
   WHEN status='Review' THEN '#e8e8e8'
   WHEN status='Implemented' THEN '#cfe8bd'
   WHEN status='Tested' THEN '#bde5d6'
   WHEN status='Deferred' THEN '#cacae5'
   ELSE '#c8c8c8' END AS 'bgcolor',


Add here:

 status AS status,

To see what is really in your status field.



  substr(tkt_uuid,1,10) AS '#',
  datetime(tkt_mtime) AS 'mtime',
  type,
  status,
  subsystem,
  title,
  comment AS '_comments'
 FROM ticket

 Everything loos as if it should work, but it always chooses the ELSE
 color (#c8c8c8).

 Any hints what I did wrong?
 ___
 fossil-users mailing list
 fossil-users@lists.fossil-scm.org
 http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users




-- 
D. Richard Hipp
d...@sqlite.org
___
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users


Re: [fossil-users] ticket status coloring

2011-01-11 Thread Steve Landers
As an aside, I use the ticket coloring extensively and it works as advertised.  
Start with the default and configure as you feel the need.

One thing I'd like to see some time is support for fgcolor as well as bgcolor 
(but not enough that I'd start hacking the code just at the moment :))

Steve

On 12/01/2011, at 10:26 AM, Richard Hipp wrote:

 
 
 On Tue, Jan 11, 2011 at 9:19 PM, Ron Wilson ronw.m...@gmail.com wrote:
 Did as requested. Status came back as Implemented.
 
 The raw output was:
 bgcolor #   mtime   typestatus  subsystem   title
 #c8c8c8 9445d15aae  2011-01-12 01:02:51 Problem Implemented   
   Invalid
 partnumber in response to query
 
 Does the Implemented string have spaces on one side or the other?
  
 
 On Tue, Jan 11, 2011 at 9:11 PM, Richard Hipp d...@sqlite.org wrote:
 
  Add here:
 
   status AS status,
 
  To see what is really in your status field.
 ___
 fossil-users mailing list
 fossil-users@lists.fossil-scm.org
 http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
 
 
 
 -- 
 D. Richard Hipp
 d...@sqlite.org
 ___
 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


Re: [fossil-users] ticket status coloring

2011-01-11 Thread Ron Wilson
Yes, I am going to do that, tomorrow, and see what happens.

On Tue, Jan 11, 2011 at 9:50 PM, Steve Landers
st...@digitalsmarties.com wrote:
 As an aside, I use the ticket coloring extensively and it works as
 advertised.  Start with the default and configure as you feel the need.
___
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users