Fossil SCM

On the stats_report?view=byuser page, order by events by default.

drh 2013-05-05 23:53 trunk
Commit bff7f5b95ed20540a1b08551ea6ff827e4956d10
1 file changed +1 -1
+1 -1
--- src/timeline.c
+++ src/timeline.c
@@ -1962,11 +1962,11 @@
19621962
Blob sql = empty_blob; /* SQL */
19631963
blob_append(&sql,
19641964
"SELECT user, "
19651965
"COUNT(*) AS eventCount "
19661966
"FROM event "
1967
- "GROUP BY user ORDER BY user COLLATE nocase",
1967
+ "GROUP BY user ORDER BY eventCount DESC",
19681968
-1);
19691969
db_prepare(&query, blob_str(&sql));
19701970
blob_reset(&sql);
19711971
@ <h1>Timeline Events by User</h1>
19721972
@ <table class='statistics-report-table-events' border='0'
19731973
--- src/timeline.c
+++ src/timeline.c
@@ -1962,11 +1962,11 @@
1962 Blob sql = empty_blob; /* SQL */
1963 blob_append(&sql,
1964 "SELECT user, "
1965 "COUNT(*) AS eventCount "
1966 "FROM event "
1967 "GROUP BY user ORDER BY user COLLATE nocase",
1968 -1);
1969 db_prepare(&query, blob_str(&sql));
1970 blob_reset(&sql);
1971 @ <h1>Timeline Events by User</h1>
1972 @ <table class='statistics-report-table-events' border='0'
1973
--- src/timeline.c
+++ src/timeline.c
@@ -1962,11 +1962,11 @@
1962 Blob sql = empty_blob; /* SQL */
1963 blob_append(&sql,
1964 "SELECT user, "
1965 "COUNT(*) AS eventCount "
1966 "FROM event "
1967 "GROUP BY user ORDER BY eventCount DESC",
1968 -1);
1969 db_prepare(&query, blob_str(&sql));
1970 blob_reset(&sql);
1971 @ <h1>Timeline Events by User</h1>
1972 @ <table class='statistics-report-table-events' border='0'
1973

Keyboard Shortcuts

Open search /
Next entry (timeline) j
Previous entry (timeline) k
Open focused entry Enter
Show this help ?
Toggle theme Top nav button