Changeset 40749

Timestamp:

May 20, 2019, 12:24:31 PM (7 years ago)

Author:

tdeboer

Message:

script updated to deal with Bright non-Sweetspot reduction

File:

• trunk/ippScripts/scripts/night_report.pl (modified) (2 diffs)

trunk/ippScripts/scripts/night_report.pl

@@ -709 +709 @@
     $query .= "    JOIN chipRun using (chip_id)";
     $query .= "    JOIN rawExp using (exp_id)";
-    $query .= "    WHERE diffRun.reduction like 'SWEETSPOT'";
+    $query .= "    WHERE stack2 IS NULL";
 ##  $query .= "    AND exp_id > $refExpID"; -- adding this restriction here slows the query way down1
     $query .= "    AND stack2 IS NULL";
@@ -724 +724 @@
     while (@row = $result->fetchrow_array()) {
         if ($doHeader) {
-            print "Unpublished Solar System Exposures ( obs_mode like %SS% or obs_mode like %BRIGHT%) with good camera quality :\n";
+            print "Unpublished Solar System Exposures WW diffs (obs_mode like %SS% or obs_mode like %BRIGHT%) with good camera quality :\n";
             printf "%12s %12s %12s | %-19s | %-16s\n", "exp_name", "warp_id", "diff_id", "dateobs", "comment";
             $doHeader = 0;