diff options
| author | Rob Stradling <rob@comodo.com> | 2017-05-05 11:25:21 +0100 |
|---|---|---|
| committer | Rob Stradling <rob@comodo.com> | 2017-05-05 11:25:21 +0100 |
| commit | 057b29c2f0e55fd18daf0eefa1aaace28177296b (patch) | |
| tree | aa54de46acc78e1fb519783ae69eaca52b8bb359 | |
| parent | 914dda189d17deca368fce7b2feaefb5bfdaa343 (diff) | |
| download | certwatch_db-057b29c2f0e55fd18daf0eefa1aaace28177296b.zip certwatch_db-057b29c2f0e55fd18daf0eefa1aaace28177296b.tar.gz certwatch_db-057b29c2f0e55fd18daf0eefa1aaace28177296b.tar.bz2 | |
Sort monitored logs by tree_size rather than latest_entry_id.
| -rw-r--r-- | web_apis.fnc | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/web_apis.fnc b/web_apis.fnc index bd77f15..c22b628 100644 --- a/web_apis.fnc +++ b/web_apis.fnc @@ -800,7 +800,7 @@ BEGIN ctl.INCLUDED_IN_CHROME, ctl.CHROME_ISSUE_NUMBER, ctl.NON_INCLUSION_STATUS FROM ct_log ctl WHERE ctl.IS_ACTIVE = 't' - ORDER BY ctl.LATEST_ENTRY_ID DESC NULLS LAST + ORDER BY ctl.TREE_SIZE DESC NULLS LAST ) LOOP SELECT coalesce(l_record.TREE_SIZE, 0) - coalesce(max(ENTRY_ID), -1) - 1 INTO t_count @@ -862,7 +862,7 @@ BEGIN FROM ct_log ctl WHERE ctl.IS_ACTIVE = 'f' AND ctl.LATEST_ENTRY_ID IS NOT NULL - ORDER BY ctl.LATEST_ENTRY_ID DESC NULLS LAST + ORDER BY ctl.TREE_SIZE DESC NULLS LAST ) LOOP SELECT coalesce(l_record.TREE_SIZE, 0) - coalesce(max(ENTRY_ID), -1) - 1 INTO t_count |