Changeset 24677 for trunk/ippTools/share/difftool_inputskyfile.sql

Timestamp:

Jul 5, 2009, 4:10:46 PM (17 years ago)

Author:

eugene

Message:

allow difftool -inputskyfile to list entries even if state is full

File:

• trunk/ippTools/share/difftool_inputskyfile.sql (modified) (4 diffs)

trunk/ippTools/share/difftool_inputskyfile.sql

@@ -32 +32 @@
         ON chipRun.exp_id = rawExp.exp_id
     WHERE
-        diffRun.state = 'new'
+        -- diffRun.state = 'new' AND 
+        warpRun.state = 'full'
         AND warpRun.state = 'full'
         AND fakeRun.state = 'full'
@@ -71 +72 @@
         ON chipRun.exp_id = rawExp.exp_id
     WHERE
-        diffRun.state = 'new'
-        AND warpRun.state = 'full'
+        -- diffRun.state = 'new' AND 
+        warpRun.state = 'full'
         AND fakeRun.state = 'full'
         AND camRun.state = 'full'
@@ -108 +109 @@
         ON chipRun.exp_id = rawExp.exp_id
     WHERE
-        diffRun.state = 'new'
+        (diffRun.state = 'new' or diffRun.state = 'full')
         -- where hook %s
     UNION
@@ -141 +142 @@
         ON chipRun.exp_id = rawExp.exp_id
     WHERE
-        diffRun.state = 'new'
+        (diffRun.state = 'new' or diffRun.state = 'full')
         -- where hook %s
     ) as Foo