Zmiany pomiędzy wersją 50 and wersją 51 dla DeployerGuide/Customization/ProcessAutomation/Examples

Data i czas:

10/22/14 12:57:53 (10 years temu)

Autor:

MK (IP: 213.227.67.33)

Komentarz:

--

DeployerGuide/Customization/ProcessAutomation/Examples

@@ -465 +465 @@
 ORDER BY prtpid, ptstid, (end___ IS NOT NULL AND orgarr IS NOT NULL) DESC, end___ IS NOT NULL DESC, end___ ASC, orgarr IS NOT NULL DESC, dscrpt ASC
 }}}
+[[BR]]
+
+zapytanie dla wszystkich zadań workflow z modułu Dokumenty:
+{{{
+SELECT doc.*, reg.regtyp,reg.ndenam, type.dctptp,type.dctpnm,type.dctpic, 
+    (SELECT ARRAY[count(f.fileid),min(f.fileid)] FROM attachments LEFT JOIN files f USING(fileid) WHERE is_del IS NOT TRUE AND doc_id = doc.doc_id) as files, 
+    (EXISTS (SELECT 1 FROM documents_history WHERE doc_id=doc.doc_id AND orunid = 1 AND strpos(dscrpt, 'Otwarcie')=1)) as is_ack 
+FROM documents doc 
+INNER JOIN (
+    SELECT doc_id, (array_agg(attrib))[1] as attrib 
+    FROM (
+        SELECT documents_view.doc_id, (CASE WHEN dlu_doc_id IS NULL THEN NULL ELSE coalesce(dlu.attrib, '') END) as attrib 
+        FROM documents documents_view 
+        LEFT JOIN storage_places stp using(strpid) 
+        LEFT JOIN (
+            SELECT dlu.doc_id as dlu_doc_id, dlu.attrib, dlu.usr_id, ul.prior_ 
+            FROM doc_link_users dlu 
+            LEFT JOIN users_link_group ul on(ul.grp_id = dlu.grp_id AND ul.usr_id = 2)
+            WHERE dlu.usr_id = 2 OR ul.usr_id = 2
+        ) dlu ON (dlu_doc_id = documents_view.doc_id)
+        WHERE is_del IS NOT TRUE AND gostof IS NULL 
+            AND procid IN (
+                SELECT p.rootpr 
+                FROM procedures p 
+                LEFT JOIN stages s USING(procid) 
+                WHERE (ARRAY(SELECT orunid FROM orgtree_view LEFT JOIN users_link_org_units ulo USING(orunid) WHERE orunid = 1 OR (ourpid = 1 AND EXISTS(SELECT 1 FROM (SELECT value_ FROM global_sys_conf WHERE ent_id = 2 AND objnam = 'Replacement_'||ulo.usr_id AND varnam = 'from__') as as1 WHERE value_::date <= now()::date) AND EXISTS(SELECT 1 FROM (SELECT value_ FROM global_sys_conf WHERE ent_id = 2 AND objnam = 'Replacement_'||ulo.usr_id AND varnam = 'to____') as sd2 WHERE value_::date >= now()::date))) && s.orgarr) AND s.ptsttp != 'SUBPROCESS' AND sop_id IS NOT NULL AND is_act IS TRUE
+            ) 
+            AND is_iso IS FALSE AND partof IS NULL ORDER BY dlu_doc_id, dlu.usr_id IS NOT NULL DESC, dlu.prior_ ASC 
+    ) foo2
+    GROUP BY doc_id
+) dolu USING (doc_id) 
+LEFT JOIN types_of_documents type USING(dctpid) 
+LEFT JOIN registers reg USING(reg_id) 
+WHERE (substr(dolu.attrib, 1, 1) = 'r') OR (dolu.attrib IS NULL AND (prionl IS NOT TRUE OR doc.adduid = 2))
+ORDER BY timest DESC,doc_id DESC
+}}}