From 9c6ae892a21b3105ada2fa1514a45d7a9f90f6bf Mon Sep 17 00:00:00 2001 From: Will Budicm Date: Wed, 20 May 2020 12:21:53 +1000 Subject: [PATCH] Bug 25 fix. --- Current Development Check List.md | 1 + htdocs/cgi-bin/system/modules/Settings.pm | 2 +- 2 files changed, 2 insertions(+), 1 deletion(-) diff --git a/Current Development Check List.md b/Current Development Check List.md index 20aa686..6aa4394 100644 --- a/Current Development Check List.md +++ b/Current Development Check List.md @@ -95,6 +95,7 @@ This version is not compatible in data structure to prior versions. Data migrati ### v. 1.9 Encountered/Fixed * ✔ Bug 25 - SQLite view not properly sorting in new databases. Newer records listed last. + * View should order by time function desc, ascendig is default. * ✔ Bug 24 - Logs row sum calculation not working/wrong, with negative and positive values. * ✔ Bug 23 - Delete not working in view mode. * ✔ Bug 22 - Delete selection of entries not working after a while, db fix in config page required. diff --git a/htdocs/cgi-bin/system/modules/Settings.pm b/htdocs/cgi-bin/system/modules/Settings.pm index 455e571..a49285e 100644 --- a/htdocs/cgi-bin/system/modules/Settings.pm +++ b/htdocs/cgi-bin/system/modules/Settings.pm @@ -108,7 +108,7 @@ sub createVW_LOGStmt { return qq( CREATE VIEW VW_LOG AS SELECT rowid as ID,*, (select count(rowid) from LOG as recount where a.rowid >= recount.rowid) as PID - FROM LOG as a ORDER BY Date(DATE) DESC;' + FROM LOG as a ORDER BY Date(DATE) DESC, Time(DATE) DESC;' )} sub createAUTHStmt { return qq( -- 2.34.1