Changeset 10044 for trunk

Timestamp:

10/28/10 11:47:07 (14 years ago)

Author:

Daniela Dorner

Message:

bugfix (every run was listed several times)

Location:

trunk/Mars

Files:

• Changelog (modified) (1 diff)
• datacenter/scripts/writemcsequencefile (modified) (3 diffs)

trunk/Mars/Changelog

@@ -18 +18 @@
 
                                                  -*-*- END OF LINE -*-*-
+
+ 2010/10/28 Daniela Dorner
+
+   * datacenter/scripts/writemcsequencefile:
+     - bug fix (every run was listed several times)
+
+
 
  2010/10/27 Daniela Dorner

trunk/Mars/datacenter/scripts/writemcsequencefile

@@ -66 +66 @@
    
    # data runs
-   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=2 AND fSequenceNumber="$sequence
+   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=2 AND fSequenceNumber="$sequence" GROUP BY fRunNumber, fFileNumber "
    datruns=`sendquery`
    if [ "$datruns" = "" ]
@@ -74 +74 @@
    fi
    # pedestal runs
-   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=3 AND fSequenceNumber="$sequence
+   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=3 AND fSequenceNumber="$sequence" GROUP BY fRunNumber, fFileNumber "
    pedruns=`sendquery`
    if [ "$pedruns" = "" ]
@@ -82 +82 @@
    fi
    # calibration runs
-   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=4 AND fSequenceNumber="$sequence
+   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=4 AND fSequenceNumber="$sequence" GROUP BY fRunNumber, fFileNumber "
    calruns=`sendquery`
    if [ "$calruns" = "" ]