Zmiany pomiędzy wersją 112 and wersją 113 dla DeployerGuide/Customization/ProcessAutomation

Pokaż
Ignoruj:
Data i czas:
12/14/16 13:03:37 (7 years temu)
Autor:
MK (IP: 213.5.203.190)
Komentarz:

--

Legend:

Bez zmian
Dodane
Usunięte
Zmienione

  • DeployerGuide/Customization/ProcessAutomation

    v112 v113  
    202202 
    203203{{{ 
    204 DELETE FROM stages WHERE sop_id IN (SELECT sop_id FROM stages s LEFT JOIN procedures p USING(procid) WHERE p.comple AND NOT (s.is_act OR s.is_fix)) 
    205 }}} 
    206  
    207  
    208  
     204DELETE FROM stages 
     205USING procedures p 
     206WHERE p.procid = stages.procid AND NOT (stages.is_act OR stages.is_fix) AND (p.comple OR p.cancel); 
     207}}} 
     208 
     209 
     210