Fossil

Check-in [bff7f5b95e]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:On the stats_report?view=byuser page, order by events by default.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: bff7f5b95ed20540a1b08551ea6ff827e4956d10
User & Date: drh 2013-05-05 23:53:26.058
Context
2013-05-06
09:40
On the /vdiff web-page, presence of "v" should mean "v=1", just as on the /event and /timeline web-pages. Add "&sbs=1" in various /vdiff and /fdiff url's, so it no longer depends on the default value. Replace some "v=1" parameters with the short form "v". ... (check-in: d24afd17c6 user: jan.nijtmans tags: trunk)
2013-05-05
23:53
On the stats_report?view=byuser page, order by events by default. ... (check-in: bff7f5b95e user: drh tags: trunk)
23:49
Implement sorting by event count on some of the stats_report pages. ... (check-in: 10aaf0c971 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to src/timeline.c.
1960
1961
1962
1963
1964
1965
1966
1967
1968
1969
1970
1971
1972
1973
1974
  int rowClass = 0;                  /* counter for alternating
                                        row colors */
  Blob sql = empty_blob;             /* SQL */
  blob_append(&sql,
               "SELECT user, "
               "COUNT(*) AS eventCount "
               "FROM event "
               "GROUP BY user ORDER BY user COLLATE nocase",
              -1);
  db_prepare(&query, blob_str(&sql));
  blob_reset(&sql);
  @ <h1>Timeline Events by User</h1>
  @ <table class='statistics-report-table-events' border='0'
  @ cellpadding='2' cellspacing='0' id='statsTable'>
  @ <thead><tr>







|







1960
1961
1962
1963
1964
1965
1966
1967
1968
1969
1970
1971
1972
1973
1974
  int rowClass = 0;                  /* counter for alternating
                                        row colors */
  Blob sql = empty_blob;             /* SQL */
  blob_append(&sql,
               "SELECT user, "
               "COUNT(*) AS eventCount "
               "FROM event "
               "GROUP BY user ORDER BY eventCount DESC",
              -1);
  db_prepare(&query, blob_str(&sql));
  blob_reset(&sql);
  @ <h1>Timeline Events by User</h1>
  @ <table class='statistics-report-table-events' border='0'
  @ cellpadding='2' cellspacing='0' id='statsTable'>
  @ <thead><tr>