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

Pokaż
Ignoruj:
Data i czas:
10/13/16 14:00:34 (7 years temu)
Autor:
MK (IP: 213.5.203.190)
Komentarz:

--

Legend:

Bez zmian
Dodane
Usunięte
Zmienione
  • DeployerGuide/Customization/ProcessAutomation/Examples

    v59 v60  
    533533        array [r.who___]::INT [] AS path 
    534534    FROM replacements r 
    535     WHERE r.bywhom IN (29) 
     535    WHERE r.bywhom IN ({ORUNID}) 
    536536        AND (now() BETWEEN r.from__ AND r.to____) 
    537537        AND NOT r.suspen 
     
    550550), 
    551551all_orunids as ( 
    552         SELECT array_agg(who___)||29 as val 
     552        SELECT array_agg(who___)||{ORUNID} as val 
    553553        FROM ( 
    554554                SELECT DISTINCT r.who___ FROM user_all_replacements r 
     
    658658            OR ( 
    659659                s.orgarr IS NULL 
    660                 AND p.emp_id = 14 
     660                AND p.emp_id = {USR_ID} 
    661661                ) 
    662662            )