Changeset 7625 for trunk/MagicSoft/Mars/datacenter/macros

Timestamp:

04/04/06 17:29:06 (19 years ago)

Author:

tbretz

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/macros/plotdb.C (modified) (1 diff)

trunk/MagicSoft/Mars/datacenter/macros/plotdb.C

@@ -350 +350 @@
         query += Form("on %s.%s=%s.%s ",       tabled.Data(), join.Data(), tablev.Data(), join.Data());
 
-        if (!fRequestFrom.IsNull() && !fRequestTo.IsNull())
-            query += Form("where fRunStart between '%s' and '%s' ",
+        const Bool_t interval = !fRequestFrom.IsNull() && !fRequestTo.IsNull();
+
+        if (!fDataSet && !interval)
+        {
+            if (!query.Contains("Star.fSequenceFirst"))
+                query += "left join Star on Sequences.fSequenceFirst=Star.fSequenceFirst ";
+            query += "where Star.fEffOnTime>300 ";
+        }
+
+        if (interval)
+        {
+            query += query.Contains(" where ") ? "and " : "where ";
+            query += Form("fRunStart between '%s' and '%s' ",
                           fRequestFrom.Data(), fRequestTo.Data());
+        }
 
         query += "order by fRunStart";
-
-        //cout << "q: " << query << endl;
 
         TSQLResult *res = fServer.Query(query);