Zmiany pomiędzy wersją 28 and wersją 29 dla DeployerGuide/Customization/ProcessAutomation/Examples
- Data i czas:
- 04/11/12 15:02:30 (13 years temu)
Legend:
- Bez zmian
- Dodane
- Usunięte
- Zmienione
-
DeployerGuide/Customization/ProcessAutomation/Examples
v28 v29 56 56 SELECT sum(res) = 0 FROM 57 57 (SELECT 58 (CASE WHEN s.ptsttp = 'END' THEN 0 ELSE 1 END) AS res 58 (CASE WHEN s.ptsttp = 'END' THEN 0 ELSE 1 END) AS res, d.dscrpt, s.ptstnm, d.prtpid 59 59 FROM documents d 60 INNER JOIN stages s ON s.procid = d.procid AND ((s.is_act IS TRUE AND s.is_fix IS FALSE) OR (s.ptsttp = 'END' AND s.is_fix IS TRUE)) 61 WHERE prtpid = 5 AND prc_id = {PRC_ID}) AS x 60 INNER JOIN stages s ON d.is_del IS NOT TRUE AND s.procid = d.procid AND ((s.is_act IS TRUE AND s.is_fix IS FALSE) OR (s.ptsttp = 'END' AND s.is_fix IS TRUE)) 61 WHERE d.prtpid = 5 AND d.prc_id = {PRC_ID}) AS x 62 62 63 63 64 W7.
