Changeset 18644 for branches/eam_branch_20080719/ippTools/share/difftool_inputskyfile.sql

Timestamp:

Jul 21, 2008, 2:14:39 PM (18 years ago)

Author:

eugene

Message:

change from old state names (run, stop) to new ones (new, full, goto_cleaned, etc)

File:

• branches/eam_branch_20080719/ippTools/share/difftool_inputskyfile.sql (modified) (2 diffs)

branches/eam_branch_20080719/ippTools/share/difftool_inputskyfile.sql

@@ -30 +30 @@
         ON chipRun.exp_id = rawExp.exp_id
     WHERE
-        diffRun.state = 'run'
-        AND warpRun.state = 'stop'
-        AND fakeRun.state = 'stop'
-        AND camRun.state = 'stop'
+        diffRun.state = 'new'
+        AND warpRun.state = 'full'
+        AND fakeRun.state = 'full'
+        AND camRun.state = 'full'
         AND chipRun.state = 'full'
     UNION
@@ -66 +66 @@
         ON chipRun.exp_id = rawExp.exp_id
     WHERE
-        diffRun.state = 'run'
-        AND warpRun.state = 'stop'
-        AND fakeRun.state = 'stop'
-        AND camRun.state = 'stop'
+        diffRun.state = 'new'
+        AND warpRun.state = 'full'
+        AND fakeRun.state = 'full'
+        AND camRun.state = 'full'
         AND chipRun.state = 'full'
     ) as Foo