Index: trunk/ippScripts/scripts/night_report.pl
===================================================================
--- trunk/ippScripts/scripts/night_report.pl	(revision 40701)
+++ trunk/ippScripts/scripts/night_report.pl	(revision 40746)
@@ -68,5 +68,5 @@
 }
 
-##################33
+##################
 ### testing the diff grouping -- this does not work for the Euclid data taken 2018.07.29 because the OBJECT
 ### field is missing
@@ -382,5 +382,5 @@
     $query .= "     AND exp_type = 'OBJECT'";
     $query .= "     AND obs_mode NOT LIKE 'ENGINEERING'";
-    $query .= "     AND obs_mode like '%SS%'";
+    $query .= "     AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
     $query .= "     AND rawExp.comment like '%visit%'";
     $query .= "     AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";
@@ -438,5 +438,5 @@
     $query .= "     AND exp_type = 'OBJECT'";
     $query .= "     AND obs_mode NOT LIKE 'ENGINEERING'";
-    $query .= "     AND obs_mode like '%SS%'";
+    $query .= "     AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
     $query .= "     AND rawExp.comment like '%visit%'";
     $query .= "     AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";
@@ -474,5 +474,5 @@
     $query .= "     AND exp_type = 'OBJECT'";
     $query .= "     AND obs_mode NOT LIKE 'ENGINEERING'";
-    $query .= "     AND obs_mode like '%SS%'";
+    $query .= "     AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
     $query .= "     AND rawExp.comment like '%visit%'";
     $query .= "     AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";
@@ -660,5 +660,5 @@
     $query .= "   AND exp_type = 'OBJECT'";
     $query .= "   AND obs_mode NOT LIKE 'ENGINEERING'";
-    $query .= "   AND obs_mode NOT like '%SS%'";
+    $query .= "   AND (obs_mode NOT LIKE '%SS%' AND obs_mode NOT LIKE '%BRIGHT%')";
     $query .= "   AND rawExp.comment like '%visit%'";
     $query .= "   AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";
@@ -694,5 +694,5 @@
     $query .= "    WHERE dateobs like '$date%'";
     $query .= "    AND exp_id > $refExpID"; #REF
-    $query .= "    AND obs_mode like '%SS%'";
+    $query .= "    AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
     $query .= "    AND (camProcessedExp.quality = 0)";
     $query .= "  ) AS expall";
@@ -724,5 +724,5 @@
     while (@row = $result->fetchrow_array()) {
 	if ($doHeader) {
-	    print "Unpublished Solar System Exposures ( obs_mode like %SS% ) with good camera quality :\n";
+	    print "Unpublished Solar System Exposures ( 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;
@@ -751,5 +751,5 @@
     $query .= "     AND exp_type = 'OBJECT'";
     $query .= "     AND obs_mode NOT LIKE 'ENGINEERING'";
-    $query .= "     AND obs_mode like '%SS%'";
+    $query .= "     AND (obs_mode LIKE '%SS%' OR obs_mode LIKE '%BRIGHT%')";
     $query .= "     AND rawExp.comment like '%visit%'";
     $query .= "     AND (camProcessedExp.quality IS NULL or camProcessedExp.quality = 0)";