Changeset 40882 for trunk/ippMonitor/def/distRun.d

Timestamp:

Sep 3, 2019, 4:04:13 PM (7 years ago)

Author:

tdeboer

Message:

updated ippMonitor queries

File:

• trunk/ippMonitor/def/distRun.d (modified) (2 diffs)

trunk/ippMonitor/def/distRun.d

@@ -1 @@
-TABLE distRun, distComponent
+TABLE distRun JOIN distComponent USING (dist_id)
 TITLE Distribution Runs
 FILE  distRun.php
@@ -6 +6 @@
 # the following WHERE clauses are added to all queries joined by AND
 
-WHERE distRun.dist_id = distComponent.dist_id
-UNRESTRICTED AND 0=1
-RESTRICT_COUNT AND 0>1
+UNRESTRICTED WHERE distRun.time_stamp >= CURDATE()
+RESTRICT_COUNT WHERE distRun.time_stamp >= CURDATE()
 
 #     field                   size  format  name         show    link to                  extras