Zmiany pomiędzy wersją 29 and wersją 30 dla DeployerGuide/Customization/ProcessAutomation/Examples

Data i czas:

05/22/12 14:13:52 (13 years temu)

Autor:

JP (IP: 213.227.67.33)

Komentarz:

--

DeployerGuide/Customization/ProcessAutomation/Examples

@@ -202 +202 @@
 FROM vatnote_costs INNER JOIN types_of_vcosts USING (tovcid) 
 WHERE doc_id = {DOC_ID} GROUP BY res HAVING substring(type__,1,1) = '4' )
-}}}
-
+
+
+# Wyślij email (do parametry Do - ustawienie emaili osób przypisanych do etapu)
+SELECT text_sum(o2.e_mail) FROM 
+stages s3 INNER JOIN orgtree_view o2 ON o2.orunid = ANY(s3.orgarr)
+WHERE s3.sop_id = {SOP_ID}
+
+}}}
+