Differences From:

File src/tagview.c part of check-in [8d529a7ae9] - Tidy up the raw tags web page, and provide a way to get there, for admins only by eric on 2008-11-26 21:59:42. [view]

To:

File src/tagview.c part of check-in [7c281b629a] - Prevent tag cancellations from showing in "fossil tag list" and "fossil tag find", and also on the tagview web page, but make them visible with "--raw" or on the RawTags webpage (admin only). Fixes ticket f273b440c38eb8478822812e0730f0fc2c8b4c36. by eric on 2008-12-20 11:36:20. [view]

@@ -62,9 +62,9 @@
     "   DATETIME(tx.mtime) AS 'Timestamp',"
     "   linkuuid(b.uuid) AS 'Version'"
     "  FROM tag t, tagxref tx, blob b "
     " WHERE t.tagid=tx.tagid AND tx.rid=b.rid"
-    "   AND tx.tagtype!=0 %s "
+    " %s "
     TAGVIEW_DEFAULT_FILTER
     " ORDER BY tx.mtime DESC %s",
     zLikeClause, zLimit
   );
@@ -175,8 +175,9 @@
   Stmt q;
   zSql = mprintf("%s AND EXISTS (SELECT 1"
          " FROM tagxref"
          "  WHERE tagxref.rid = event.objid"
+         "  AND tagxref.tagtype > 0"
          "  AND tagxref.tagid = (SELECT tagid FROM tag"
          "      WHERE tagname = %Q||%Q))"
          " ORDER BY 3 desc",
          timeline_query_for_www(), pPrefix, pName);