Changeset 10044 for trunk/Mars


Ignore:
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:
2 edited

Legend:

Unmodified
Added
Removed

  • trunk/Mars/Changelog

    r10043 r10044  
    1818
    1919                                                 -*-*- END OF LINE -*-*-
     20
     21 2010/10/28 Daniela Dorner
     22
     23   * datacenter/scripts/writemcsequencefile:
     24     - bug fix (every run was listed several times)
     25
     26
    2027
    2128 2010/10/27 Daniela Dorner

  • trunk/Mars/datacenter/scripts/writemcsequencefile

    r10019 r10044  
    6666   
    6767   # data runs
    68    query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=2 AND fSequenceNumber="$sequence
     68   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=2 AND fSequenceNumber="$sequence" GROUP BY fRunNumber, fFileNumber "
    6969   datruns=`sendquery`
    7070   if [ "$datruns" = "" ]
    … …  
    7474   fi
    7575   # pedestal runs
    76    query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=3 AND fSequenceNumber="$sequence
     76   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=3 AND fSequenceNumber="$sequence" GROUP BY fRunNumber, fFileNumber "
    7777   pedruns=`sendquery`
    7878   if [ "$pedruns" = "" ]
    … …  
    8282   fi
    8383   # calibration runs
    84    query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=4 AND fSequenceNumber="$sequence
     84   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=4 AND fSequenceNumber="$sequence" GROUP BY fRunNumber, fFileNumber "
    8585   calruns=`sendquery`
    8686   if [ "$calruns" = "" ]
Note: See TracChangeset for help on using the changeset viewer.