Mercurial > hg > orthanc-databases
changeset 326:4454545bb265
Fix issue #200 (fields messed up in /changes route)
| author | Sebastien Jodogne <s.jodogne@gmail.com> |
|---|---|
| date | Thu, 22 Jul 2021 19:24:58 +0200 |
| parents | e0b9abf98019 |
| children | 9660def78649 6a49c495c940 |
| files | Framework/Plugins/IndexBackend.cpp MySQL/NEWS |
| diffstat | 2 files changed, 6 insertions(+), 4 deletions(-) [+] |
line wrap: on
line diff
--- a/Framework/Plugins/IndexBackend.cpp Tue Jul 20 17:11:00 2021 +0200 +++ b/Framework/Plugins/IndexBackend.cpp Thu Jul 22 19:24:58 2021 +0200 @@ -568,8 +568,8 @@ DatabaseManager::CachedStatement statement( STATEMENT_FROM_HERE, manager, - "SELECT Changes.seq, Changes.changeType, Changes.resourceType, Changes.date, " - "Resources.publicId FROM Changes INNER JOIN Resources " + "SELECT Changes.seq, Changes.changeType, Changes.resourceType, Resources.publicId, " + "Changes.date FROM Changes INNER JOIN Resources " "ON Changes.internalId = Resources.internalId WHERE seq>${since} ORDER BY seq " + suffix); statement.SetReadOnly(true); @@ -671,8 +671,8 @@ DatabaseManager::CachedStatement statement( STATEMENT_FROM_HERE, manager, - "SELECT Changes.seq, Changes.changeType, Changes.resourceType, Changes.date, " - "Resources.publicId FROM Changes INNER JOIN Resources " + "SELECT Changes.seq, Changes.changeType, Changes.resourceType, Resources.publicId, " + "Changes.date FROM Changes INNER JOIN Resources " "ON Changes.internalId = Resources.internalId ORDER BY seq DESC " + suffix); statement.SetReadOnly(true);