Fossil SCM
Provide a default ticket report format: "All Tickets". Ticket [86eb5f92f5]
Commit
024859fff29ad089bfda3293037bdbe30cecf73d
Parent
10df4ff6037b80a…
1 file changed
+20
+20
| --- src/schema.c | ||
| +++ src/schema.c | ||
| @@ -145,10 +145,30 @@ | ||
| 145 | 145 | @ owner text, -- Owner of this report format (not used) |
| 146 | 146 | @ title text, -- Title of this report |
| 147 | 147 | @ cols text, -- A color-key specification |
| 148 | 148 | @ sqlcode text -- An SQL SELECT statement for this report |
| 149 | 149 | @ ); |
| 150 | +@ INSERT INTO reportfmt(title,cols,sqlcode) VALUES('All Tickets','#ffffff Key: | |
| 151 | +@ #f2dcdc Active | |
| 152 | +@ #e8e8e8 Review | |
| 153 | +@ #cfe8bd Fixed | |
| 154 | +@ #bde5d6 Tested | |
| 155 | +@ #cacae5 Deferred | |
| 156 | +@ #c8c8c8 Closed','SELECT | |
| 157 | +@ CASE WHEN status IN (''Open'',''Verified'') THEN ''#f2dcdc'' | |
| 158 | +@ WHEN status=''Review'' THEN ''#e8e8e8'' | |
| 159 | +@ WHEN status=''Fixed'' THEN ''#cfe8bd'' | |
| 160 | +@ WHEN status=''Tested'' THEN ''#bde5d6'' | |
| 161 | +@ WHEN status=''Deferred'' THEN ''#cacae5'' | |
| 162 | +@ ELSE ''#c8c8c8'' END AS ''bgcolor'', | |
| 163 | +@ substr(tkt_uuid,1,10) AS ''#'', | |
| 164 | +@ datetime(tkt_mtime) AS ''mtime'', | |
| 165 | +@ type, | |
| 166 | +@ status, | |
| 167 | +@ subsystem, | |
| 168 | +@ title | |
| 169 | +@ FROM ticket'); | |
| 150 | 170 | @ |
| 151 | 171 | @ -- Some ticket content (such as the originators email address or contact |
| 152 | 172 | @ -- information) needs to be obscured to protect privacy. This is achieved |
| 153 | 173 | @ -- by storing an SHA1 hash of the content. For display, the hash is |
| 154 | 174 | @ -- mapped back into the original text using this table. |
| 155 | 175 |
| --- src/schema.c | |
| +++ src/schema.c | |
| @@ -145,10 +145,30 @@ | |
| 145 | @ owner text, -- Owner of this report format (not used) |
| 146 | @ title text, -- Title of this report |
| 147 | @ cols text, -- A color-key specification |
| 148 | @ sqlcode text -- An SQL SELECT statement for this report |
| 149 | @ ); |
| 150 | @ |
| 151 | @ -- Some ticket content (such as the originators email address or contact |
| 152 | @ -- information) needs to be obscured to protect privacy. This is achieved |
| 153 | @ -- by storing an SHA1 hash of the content. For display, the hash is |
| 154 | @ -- mapped back into the original text using this table. |
| 155 |
| --- src/schema.c | |
| +++ src/schema.c | |
| @@ -145,10 +145,30 @@ | |
| 145 | @ owner text, -- Owner of this report format (not used) |
| 146 | @ title text, -- Title of this report |
| 147 | @ cols text, -- A color-key specification |
| 148 | @ sqlcode text -- An SQL SELECT statement for this report |
| 149 | @ ); |
| 150 | @ INSERT INTO reportfmt(title,cols,sqlcode) VALUES('All Tickets','#ffffff Key: |
| 151 | @ #f2dcdc Active |
| 152 | @ #e8e8e8 Review |
| 153 | @ #cfe8bd Fixed |
| 154 | @ #bde5d6 Tested |
| 155 | @ #cacae5 Deferred |
| 156 | @ #c8c8c8 Closed','SELECT |
| 157 | @ CASE WHEN status IN (''Open'',''Verified'') THEN ''#f2dcdc'' |
| 158 | @ WHEN status=''Review'' THEN ''#e8e8e8'' |
| 159 | @ WHEN status=''Fixed'' THEN ''#cfe8bd'' |
| 160 | @ WHEN status=''Tested'' THEN ''#bde5d6'' |
| 161 | @ WHEN status=''Deferred'' THEN ''#cacae5'' |
| 162 | @ ELSE ''#c8c8c8'' END AS ''bgcolor'', |
| 163 | @ substr(tkt_uuid,1,10) AS ''#'', |
| 164 | @ datetime(tkt_mtime) AS ''mtime'', |
| 165 | @ type, |
| 166 | @ status, |
| 167 | @ subsystem, |
| 168 | @ title |
| 169 | @ FROM ticket'); |
| 170 | @ |
| 171 | @ -- Some ticket content (such as the originators email address or contact |
| 172 | @ -- information) needs to be obscured to protect privacy. This is achieved |
| 173 | @ -- by storing an SHA1 hash of the content. For display, the hash is |
| 174 | @ -- mapped back into the original text using this table. |
| 175 |