Zmiany pomiędzy wersją 59 and wersją 60 dla DeployerGuide/Customization/ProcessAutomation/Examples

Data i czas:

10/13/16 14:00:34 (8 years temu)

Autor:

MK (IP: 213.5.203.190)

Komentarz:

--

DeployerGuide/Customization/ProcessAutomation/Examples

@@ -533 +533 @@
         array [r.who___]::INT [] AS path
     FROM replacements r
-    WHERE r.bywhom IN (29)
+    WHERE r.bywhom IN ({ORUNID})
         AND (now() BETWEEN r.from__ AND r.to____)
         AND NOT r.suspen
@@ -550 +550 @@
 ),
 all_orunids as (
-        SELECT array_agg(who___)||29 as val
+        SELECT array_agg(who___)||{ORUNID} as val
         FROM (
                 SELECT DISTINCT r.who___ FROM user_all_replacements r
@@ -658 +658 @@
             OR (
                 s.orgarr IS NULL
-                AND p.emp_id = 14
+                AND p.emp_id = {USR_ID}
                 )
             )