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

Data i czas:

01/08/14 16:47:34 (10 years temu)

Autor:

MK (IP: 213.227.67.33)

Komentarz:

--

DeployerGuide/Customization/ProcessAutomation/Examples

@@ -340 +340 @@
 LEFT JOIN features_opt_view f32 ON d.doc_id = f32.tbl_id AND f32.featid = 263
 WHERE d.doc_id = {DOC_ID}
-
-
-
-}}}
+}}}
+
+== Zapytanie dla "moich zadań workflow" ==
+
+{{{
+SELECT keyval,
+       dscrpt,
+       clsnam,
+       ptstnm,
+       dctpid,
+       prtpnm,
+       end___,
+       ptstid
+FROM procedures_def
+RIGHT JOIN (
+    SELECT (doc_id) AS keyval,
+            p2.prtpid,
+            substr(d.dscrpt, 0, 100) AS dscrpt,
+            'DOCUMENT' AS clsnam,
+            end___,
+            s.ptstnm,
+            d.dctpid,
+            ptstid,
+            orgarr
+     FROM procedures pd
+     LEFT JOIN stages s USING(procid)
+     LEFT JOIN procedures p2 ON (p2.procid = pd.rootpr)
+     LEFT JOIN bpm_loops_def bld USING(ptstid)
+     RIGHT JOIN documents d ON (d.procid = p2.procid)
+     LEFT JOIN (
+        SELECT doc_id, text_sum(attrib::text) AS attrib
+        FROM (
+            SELECT *
+            FROM (
+                SELECT doc_id, coalesce(attrib, '-'::text) AS attrib, CASE WHEN grp_id IS NULL THEN -1 ELSE ul.prior_ END AS prior_, CASE WHEN dlu.usr_id IS NULL THEN ul.usr_id ELSE dlu.usr_id END AS usr_id
+                FROM doc_link_users dlu
+                LEFT JOIN users_link_group ul USING(grp_id)
+                WHERE TRUE AND (dlu.usr_id = 2 OR ul.usr_id = 2)
+            ) AS foo
+            ORDER BY usr_id, prior_ ASC
+        ) AS foo2
+        GROUP BY doc_id
+    ) AS dolu USING (doc_id)
+     WHERE (bld.multii IS NOT TRUE OR s.prn_id IS NOT NULL)
+         AND s.ptsttp != 'SUBPROCESS'
+         AND ((dolu.attrib ~ '^r') OR (dolu.attrib IS NULL AND (prionl IS NOT TRUE OR d.adduid = 2)))
+         AND ((ARRAY[1] && s.orgarr) OR (s.orgarr IS NULL AND d.target = ANY(ARRAY[1]))) AND d.is_del IS NOT TRUE AND gostof IS NULL AND sop_id IS NOT NULL AND s.is_act IS TRUE AND pd.comple IS NOT TRUE AND ptsttp != 'START' 
+         
+UNION 
+    SELECT (prc_id) AS keyval,
+           p2.prtpid,
+           substr(p.dscrpt, 0, 100) AS dscrpt,
+           'PROCESS' AS clsnam,
+           end___,
+           s.ptstnm,
+           0 AS dctpid,
+           ptstid,
+           orgarr
+    FROM procedures pd
+    LEFT JOIN stages s USING(procid)
+    LEFT JOIN procedures p2 ON (p2.procid = pd.rootpr)
+    LEFT JOIN bpm_loops_def bld USING(ptstid)
+    RIGHT JOIN processes p ON (p.procid = p2.procid)
+    WHERE (bld.multii IS NOT TRUE
+           OR s.prn_id IS NOT NULL)
+        AND s.ptsttp != 'SUBPROCESS'
+        AND p.is_fix IS FALSE
+        AND p.is_del IS FALSE
+        AND (ARRAY[1] && s.orgarr)
+        AND sop_id IS NOT NULL
+        AND s.is_act IS TRUE
+        AND pd.comple IS NOT TRUE
+        AND ptsttp != 'START'
+UNION 
+    SELECT (rcp_id) AS keyval,
+           p2.prtpid,
+           substr(p.dscrpt, 0, 100) AS dscrpt,
+           'RCP' AS clsnam,
+           end___,
+           s.ptstnm,
+           0 AS dctpid,
+           ptstid,
+           orgarr
+    FROM procedures pd
+    LEFT JOIN stages s USING(procid)
+    LEFT JOIN procedures p2 ON (p2.procid = pd.rootpr)
+    LEFT JOIN bpm_loops_def bld USING(ptstid)
+    RIGHT JOIN rcp_cards p ON (p.procid = p2.procid)
+    WHERE (bld.multii IS NOT TRUE
+           OR s.prn_id IS NOT NULL)
+        AND s.ptsttp != 'SUBPROCESS'
+        AND p.is_fix IS FALSE
+        AND p.is_del IS FALSE
+        AND ((ARRAY[1] && s.orgarr)
+             OR (s.orgarr IS NULL
+                 AND p.emp_id = 2))
+        AND sop_id IS NOT NULL
+        AND s.is_act IS TRUE
+        AND pd.comple IS NOT TRUE
+        AND ptsttp != 'START'
+) AS aa USING(prtpid)
+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
+}}}
+
 
 == Linki przydatne ==