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

Timestamp:

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

Author:

tdeboer

Message:

updated ippMonitor queries

File:

• trunk/ippMonitor/def/warpProcessedSkyfiles.d (modified) (1 diff)

trunk/ippMonitor/def/warpProcessedSkyfiles.d

@@ -1 @@
-TABLE rawExp JOIN chipRun USING(exp_id) JOIN camRun USING(chip_id) JOIN fakeRun USING(cam_id) JOIN warpRun USING(fake_id) JOIN warpSkyfile USING(warp_id)
+TABLE rawExp JOIN chipRun USING (exp_id) JOIN camRun USING (chip_id) JOIN fakeRun USING (cam_id) JOIN warpRun USING (fake_id) JOIN warpSkyfile USING (warp_id)
 TITLE Warp Processed Skyfiles
 FILE  warpProcessedSkyfiles.php
 MENU  ipp.science.dat
 
-RESTRICT_COUNT WHERE dateobs >= CURDATE()
-UNRESTRICTED WHERE dateobs >= CURDATE()
+RESTRICT_COUNT WHERE rawExp.dateobs >= CURDATE()
+UNRESTRICTED WHERE rawExp.dateobs >= CURDATE()
 
 ARGS  ARG1  rawImfile.exp_id=$rawExp.exp_id