Fossil SCM
Ticket alerts reference the actual ticket, not the ticket change artifact.
Commit
1a5dee1ea201432fc8973c9c231a1f9b2a4401af8a182950f0f6866040ab8603
Parent
d725f611a3920e4…
1 file changed
+4
-1
+4
-1
| --- src/alerts.c | ||
| +++ src/alerts.c | ||
| @@ -2003,11 +2003,14 @@ | ||
| 2003 | 2003 | |
| 2004 | 2004 | |
| 2005 | 2005 | /* First do non-forum post events */ |
| 2006 | 2006 | db_prepare(&q, |
| 2007 | 2007 | "SELECT" |
| 2008 | - " blob.uuid," /* 0 */ | |
| 2008 | + " CASE WHEN event.type='t'" | |
| 2009 | + " THEN (SELECT substr(tagname,5) FROM tag" | |
| 2010 | + " WHERE tagid=event.tagid AND tagname LIKE 'tkt-%%')" | |
| 2011 | + " ELSE blob.uuid END," /* 0 */ | |
| 2009 | 2012 | " datetime(event.mtime)," /* 1 */ |
| 2010 | 2013 | " coalesce(ecomment,comment)" |
| 2011 | 2014 | " || ' (user: ' || coalesce(euser,user,'?')" |
| 2012 | 2015 | " || (SELECT case when length(x)>0 then ' tags: ' || x else '' end" |
| 2013 | 2016 | " FROM (SELECT group_concat(substr(tagname,5), ', ') AS x" |
| 2014 | 2017 |
| --- src/alerts.c | |
| +++ src/alerts.c | |
| @@ -2003,11 +2003,14 @@ | |
| 2003 | |
| 2004 | |
| 2005 | /* First do non-forum post events */ |
| 2006 | db_prepare(&q, |
| 2007 | "SELECT" |
| 2008 | " blob.uuid," /* 0 */ |
| 2009 | " datetime(event.mtime)," /* 1 */ |
| 2010 | " coalesce(ecomment,comment)" |
| 2011 | " || ' (user: ' || coalesce(euser,user,'?')" |
| 2012 | " || (SELECT case when length(x)>0 then ' tags: ' || x else '' end" |
| 2013 | " FROM (SELECT group_concat(substr(tagname,5), ', ') AS x" |
| 2014 |
| --- src/alerts.c | |
| +++ src/alerts.c | |
| @@ -2003,11 +2003,14 @@ | |
| 2003 | |
| 2004 | |
| 2005 | /* First do non-forum post events */ |
| 2006 | db_prepare(&q, |
| 2007 | "SELECT" |
| 2008 | " CASE WHEN event.type='t'" |
| 2009 | " THEN (SELECT substr(tagname,5) FROM tag" |
| 2010 | " WHERE tagid=event.tagid AND tagname LIKE 'tkt-%%')" |
| 2011 | " ELSE blob.uuid END," /* 0 */ |
| 2012 | " datetime(event.mtime)," /* 1 */ |
| 2013 | " coalesce(ecomment,comment)" |
| 2014 | " || ' (user: ' || coalesce(euser,user,'?')" |
| 2015 | " || (SELECT case when length(x)>0 then ' tags: ' || x else '' end" |
| 2016 | " FROM (SELECT group_concat(substr(tagname,5), ', ') AS x" |
| 2017 |