[prev in list] [next in list] [prev in thread] [next in thread] 

List:       fossil-users
Subject:    [fossil-users] Adding my own table to the repo
From:       Clark Christensen <cdcmicro () yahoo ! com>
Date:       2010-02-11 1:39:28
Message-ID: 297436.16017.qm () web31812 ! mail ! mud ! yahoo ! com
[Download RAW message or body]

I was looking to have a ticket report that was ordered by status, but with an \
arbitrary ordering of the status groups ("Open", then "Fixed", then "Deferred", then \
...).  No problem  I'll just use SQLite CLI to create my own enum table with the \
statuses, and a display order for each, then join ticket with enumand order the \
result set by enum.display_order.

Apparently, I was wrong.  I was able to create and populate the enum table (actually, \
"swff_enum") no problem (see CREATE below).  But I get an error from Fossil trying to \
save the report (report SQL below).

Syntax error: access to swff_enum.TYPE is prohibited

Certainly, I missed something somewhere.  Can anyone enlighten me?  Has this been \
discussed before?

Thanks!

 -Clark


CREATE TABLE swff_enum (
  TYPE text,
  NAME text,
  DISPLAY_ORDER integer
)

SELECT
  CASE WHEN t.status IN ('Open','Verified') THEN '#f2dcdc'
       WHEN t.status='Review' THEN '#e8e8e8'
       WHEN t.status='Fixed' THEN '#cfe8bd'
       WHEN t.status='Tested' THEN '#bde5d6'
       WHEN t.status='Deferred' THEN '#cacae5'
       ELSE '#c8c8c8' END AS 'bgcolor',
  t.tkt_id AS "Tkt ID",
  substr(t.tkt_uuid,1,10) AS "#",
  t.status as Status,
  t.priority as Priority,
  datetime(t.tkt_mtime) AS Modified,
  t.type as Type,
  t.subsystem as Developer,
  t.title as Title
FROM
  ticket t,
  swff_enum m
where
  m.type = 'status'
  and m.name = t.status
--where status not in ('Closed','Deferred')
ORDER BY
m.display_order, priority, Modified desc


[prev in list] [next in list] [prev in thread] [next in thread]