Zmiany pomiędzy wersją 46 and wersją 47 dla DeployerGuide/Customization/ProcessAutomation/Examples

Data i czas:

06/06/14 10:57:03 (10 years temu)

Autor:

JP (IP: 188.146.60.19)

Komentarz:

--

DeployerGuide/Customization/ProcessAutomation/Examples

@@ -175 +175 @@
 SELECT ARRAY(SELECT o.orunid FROM orgtree_view o WHERE o.orunid IN (SELECT o.orunid FROM users_link_group ulg INNER JOIN orgtree_view o ON o.usr_id = ulg.usr_id AND ulg.grp_id = 2))
 
+--
+P12
+Przypisanie wartości cechy - pracownik
+
+SELECT ARRAY[o.orunid]
+FROM documents d
+LEFT JOIN features_text_view f26 ON d.doc_id = f26.tbl_id AND f26.featid = 26
+LEFT JOIN orgtree_view o ON o.usr_id = f26.data__::int
+WHERE d.doc_id = {DOC_ID}
 
 }}}