Zmiany pomiędzy wersją 116 and wersją 117 dla DeployerGuide/Customization/ProcessAutomation

Data i czas:

01/04/17 17:00:53 (7 years temu)

Autor:

mkrolikowski (IP: 193.0.209.17)

Komentarz:

--

DeployerGuide/Customization/ProcessAutomation

@@ -211 +211 @@
 
 {{{
-delete from stages where sop_id = any(
-select sop_id from stages s join procedures p using(procid) where NOT (s.is_act OR s.is_fix) AND (p.comple OR p.cancel)  order by p.adddat asc  )
-}}}
-
+DELETE
+FROM stages
+WHERE sop_id = any
+    (SELECT sop_id
+     FROM stages s
+     JOIN procedures p USING(procid)
+     WHERE NOT (s.is_act
+                OR s.is_fix)
+       AND (p.comple
+            OR p.cancel)
+     ORDER BY p.adddat ASC)
+}}}
+