Changeset 40651 for trunk/ippScripts

Timestamp:

Mar 28, 2019, 8:14:53 AM (7 years ago)

Author:

eugene

Message:

do not restrict to %SS.DATE for diff data_group in unpublished query: euclid data has format EU.DATE

File:

• trunk/ippScripts/scripts/night_report.pl (modified) (1 diff)

trunk/ippScripts/scripts/night_report.pl

@@ -708 +708 @@
 ##  $query .= "    AND exp_id > $refExpID"; -- adding this restriction here slows the query way down1
     $query .= "    AND stack2 IS NULL";
-    $query .= "    AND diffRun.data_group LIKE '%SS.$dataGroupDate'";
+    $query .= "    AND diffRun.data_group LIKE '%.$dataGroupDate'";
     $query .= "    GROUP BY exp_name";
     $query .= "   ) AS exppub";