IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Apr 7, 2009, 10:36:16 AM (17 years ago)
Author:
bills
Message:

insure that the run to be distributed is in the appropriate state

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/disttool_pendingcomponent.sql

    r23717 r23721  
    7676    AND distComponent.dist_id IS NULL
    7777    AND (distRun.clean OR chipRun.magicked OR distRun.no_magic)
     78    AND (chipRun.state = 'full' OR (distRun.clean AND chipRun.state = 'cleaned'))
    7879    -- where hook 2 %s
    7980UNION
    … …  
    108109    AND distComponent.dist_id IS NULL
    109110    AND (distRun.clean OR chipRun.magicked OR distRun.no_magic)
     111    AND (camRun.state = 'full' OR (distRun.clean AND camRun.state = 'cleaned'))
    110112    -- where hook 3 %s
    111113UNION
    … …  
    172174    AND distComponent.dist_id IS NULL
    173175    AND (distRun.clean OR warpRun.magicked OR distRun.no_magic)
     176    AND (warpRun.state = 'full' OR (distRun.clean AND warpRun.state = 'cleaned'))
    174177    -- where hook 5 %s
    175178UNION
    … …  
    204207    AND distComponent.dist_id IS NULL
    205208    AND (distRun.clean OR diffRun.magicked OR distRun.no_magic)
     209    AND (diffRun.state = 'full' OR (distRun.clean AND diffRun.state = 'cleaned'))
    206210    -- where hook 6 %s
    207211UNION
    … …  
    252256    AND distRun.stage = 'stack'
    253257    AND distComponent.dist_id IS NULL
     258    AND (stackRun.state = 'full' OR (distRun.clean AND stackRun.state = 'cleaned'))
    254259    -- where hook 7 %s
    255260) as Foo
Note: See TracChangeset for help on using the changeset viewer.