Changeset 29493 for trunk/ippTools/share/magictool_toprocess_tree.sql

Timestamp:

Oct 20, 2010, 9:39:26 AM (16 years ago)

Author:

bills

Message:

changes to implment saving magic streaks file and verify outputs in nebulous and to add data_state to Background tables to support cleanup

File:

• trunk/ippTools/share/magictool_toprocess_tree.sql (modified) (2 diffs)

trunk/ippTools/share/magictool_toprocess_tree.sql

@@ -3 +3 @@
     magicRun.workdir,
     rawExp.exp_id,
+    rawExp.exp_name,
+    rawExp.workdir AS raw_workdir,
     rawExp.camera,
     -- convert magic_id into a boolean value (1 or 0)
@@ -16 +18 @@
 WHERE
     magicRun.state = 'new'
+    AND (Label.active OR Label.active IS NULL)
 -- WHERE hook %s
 ORDER BY