Edgewall Software

Changes between Version 6 and Version 7 of CookBook/Configuration/Reports


Ignore:
Timestamp:
Dec 15, 2013, 8:22:12 AM (9 years ago)
Author:
Ryan J Ollos
Comment:

Adjust queries for cross-db compatibility.

Legend:

Unmodified
Added
Removed
Modified
  • CookBook/Configuration/Reports

    v6 v7  
    222222#!sql
    223223SELECT
    224    "changeset" AS _realm, rev as id,
     224   'changeset' AS _realm, rev as id,
    225225   time AS date, time,
    226226   SUBSTR(message, 1, 80 )AS message
     
    236236@@ -1,7 +1,7 @@
    237237  SELECT
    238      "changeset" AS _realm, rev as id,
     238     'changeset' AS _realm, rev as id,
    239239     time AS date, time,
    240240-    SUBSTR(message, 1, 80 )AS message
     
    252252#!sql
    253253SELECT
    254    "wiki" AS _realm,
     254   'wiki' AS _realm,
    255255   name AS id,
    256256   max(version) AS Version,
     
    265265#!sql
    266266SELECT
    267    "wiki" AS _realm,
     267   'wiki' AS _realm,
    268268   wiki.name AS id,
    269269   time AS date, time,