diff options
| author | Claudius Coenen | 2017-10-09 12:13:41 +0200 |
|---|---|---|
| committer | Claudius Coenen | 2017-10-09 14:03:33 +0200 |
| commit | 724a6bc26f20c47421b1d14b25e4062f3807dbc5 (patch) | |
| tree | be4da1904196fb9f7ea1a9087860581a8bfd37f6 | |
| parent | a99cac0cf05acaddd38f21851e85ae542ebc0070 (diff) | |
createdAt DESC with quotation marks did not work with MySQL fixes #565
| -rw-r--r-- | lib/models/revision.js | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/lib/models/revision.js b/lib/models/revision.js index 6f3a746f..225a95d4 100644 --- a/lib/models/revision.js +++ b/lib/models/revision.js @@ -110,7 +110,7 @@ module.exports = function (sequelize, DataTypes) { where: { noteId: note.id }, - order: '"createdAt" DESC' + order: [['createdAt', 'DESC']] }).then(function (revisions) { var data = [] for (var i = 0, l = revisions.length; i < l; i++) { @@ -131,7 +131,7 @@ module.exports = function (sequelize, DataTypes) { where: { noteId: note.id }, - order: '"createdAt" DESC' + order: [['createdAt', 'DESC']] }).then(function (revisions) { if (revisions.length <= 0) return callback(null, null) // measure target revision position @@ -142,7 +142,7 @@ module.exports = function (sequelize, DataTypes) { $gte: time } }, - order: '"createdAt" DESC' + order: [['createdAt', 'DESC']] }).then(function (count) { if (count <= 0) return callback(null, null) sendDmpWorker({ @@ -231,7 +231,7 @@ module.exports = function (sequelize, DataTypes) { where: { noteId: note.id }, - order: '"createdAt" DESC' + order: [['createdAt', 'DESC']] }).then(function (revisions) { if (revisions.length <= 0) { // if no revision available |