Fossil SCM
Fix the query for the new /taglist page so the "Most Recent" is the time of the object being tagged, not the tag itself.
Commit
ac446f27ed1e725b32a0ef4c5d8a25b123f629879a477b5f4f2a251183ac55d9
Parent
239a3fa34eebb1c…
1 file changed
+2
-1
+2
-1
| --- src/tag.c | ||
| +++ src/tag.c | ||
| @@ -861,13 +861,14 @@ | ||
| 861 | 861 | @ </tr></thead><tbody> |
| 862 | 862 | |
| 863 | 863 | db_prepare(&q, |
| 864 | 864 | "SELECT substr(tagname,5),\n" |
| 865 | 865 | "row_number()OVER(ORDER BY tagname COLLATE uintnocase),\n" |
| 866 | - "substr(datetime(max(mtime)),1,16),\n" | |
| 866 | + "substr(datetime(max(event.mtime)),1,16),\n" | |
| 867 | 867 | "count(*)\n" |
| 868 | 868 | "FROM tagxref JOIN tag USING(tagid)\n" |
| 869 | + " JOIN event ON event.objid=tagxref.rid\n" | |
| 869 | 870 | "WHERE tagname like 'sym-%%'\n" |
| 870 | 871 | "AND tagxref.tagtype=1\n" |
| 871 | 872 | "GROUP BY 1\n" |
| 872 | 873 | "ORDER BY 3 DESC;\n" |
| 873 | 874 | ); |
| 874 | 875 |
| --- src/tag.c | |
| +++ src/tag.c | |
| @@ -861,13 +861,14 @@ | |
| 861 | @ </tr></thead><tbody> |
| 862 | |
| 863 | db_prepare(&q, |
| 864 | "SELECT substr(tagname,5),\n" |
| 865 | "row_number()OVER(ORDER BY tagname COLLATE uintnocase),\n" |
| 866 | "substr(datetime(max(mtime)),1,16),\n" |
| 867 | "count(*)\n" |
| 868 | "FROM tagxref JOIN tag USING(tagid)\n" |
| 869 | "WHERE tagname like 'sym-%%'\n" |
| 870 | "AND tagxref.tagtype=1\n" |
| 871 | "GROUP BY 1\n" |
| 872 | "ORDER BY 3 DESC;\n" |
| 873 | ); |
| 874 |
| --- src/tag.c | |
| +++ src/tag.c | |
| @@ -861,13 +861,14 @@ | |
| 861 | @ </tr></thead><tbody> |
| 862 | |
| 863 | db_prepare(&q, |
| 864 | "SELECT substr(tagname,5),\n" |
| 865 | "row_number()OVER(ORDER BY tagname COLLATE uintnocase),\n" |
| 866 | "substr(datetime(max(event.mtime)),1,16),\n" |
| 867 | "count(*)\n" |
| 868 | "FROM tagxref JOIN tag USING(tagid)\n" |
| 869 | " JOIN event ON event.objid=tagxref.rid\n" |
| 870 | "WHERE tagname like 'sym-%%'\n" |
| 871 | "AND tagxref.tagtype=1\n" |
| 872 | "GROUP BY 1\n" |
| 873 | "ORDER BY 3 DESC;\n" |
| 874 | ); |
| 875 |