Changes between Version 2 and Version 3 of CookBook/Configuration/Reports

Timestamp:

Mar 22, 2010, 3:16:49 PM (14 years ago)

Author:

mpotter@…

Comment:

—

CookBook/Configuration/Reports

@@ -73 +73 @@
      (CASE status
 }}}
+
+== Non Ticket Reports ==
+
+SQL reports do not have to be limited to tickets.  They can report on revisions, wiki pages, or user activity.
+
+=== User Changesets ===
+The follow report will lists all of the changes for the current user, or add "?USER=''user''" to the end of the URL to report on another user.
+{{{
+!#sql
+SELECT 
+   "changeset" AS _realm, rev as id, 
+   time AS date, time, 
+   SUBSTR(message, 1, 80 )AS message
+FROM revision
+WHERE author='$USER'
+ORDER BY time DESC
+}}}
+This report only gives the first 80 characters of the check-in message.  To give the full message, make the following change:
+{{{
+#!diff
+--- Report.sql
++++ Report.sql
+@@ -1,7 +1,7 @@
+  SELECT 
+     "changeset" AS _realm, rev as id, 
+     time AS date, time, 
+-    SUBSTR(message, 1, 80 )AS message
++    message AS _message_
+  FROM revision
+  WHERE author='$USER'
+  ORDER BY time DESC
+}}}
+=== Wiki Changes ===
+This reports the wiki pages ever modified by the current user, or add "?USER=''user''" to the end of the URL to report on another user.  Version is the highest version that the user modified.
+{{{
+#!sql
+SELECT 
+   "wiki" AS _realm, 
+   name AS id, 
+   max(version) AS Version,
+   time AS date, time, 
+   comment
+FROM wiki
+WHERE author='$USER'
+GROUP BY name
+}}}
+For wiki pages that were last modified by the current user:
+{{{
+#!sql
+SELECT 
+   "wiki" AS _realm, 
+   wiki.name AS id, 
+   time AS date, time, 
+   comment
+FROM wiki,
+ (SELECT max(version) AS maxVer, name
+  FROM wiki
+  GROUP BY name) maxResults
+WHERE wiki.name = maxResults.name
+ AND version = maxVer
+ AND author = '$USER'
+ORDER BY wiki.name
+}}}