Zmiany pomiędzy wersją 4 and wersją 5 dla DeployerGuide/Customization/ProcessAutomation/Loops

Data i czas:

07/28/15 09:19:14 (9 years temu)

Autor:

MK (IP: 79.188.124.105)

Komentarz:

--

DeployerGuide/Customization/ProcessAutomation/Loops

@@ -21 +21 @@
 select sop_id,procid,ptstid, sop_id as prn_id, stdver,ptstnm,ptsttp, unnest(orgarr) as orgarr, params,end___,duratn,is_fix,fixdat,fixper,orunid,sysdat,is_act,errlog,assign,props_,in_set,outset,TRUE as isinst,actdat,state_,trbyev,prcref,allow_,commen
 from stages
-where ptstid = 1075 AND orgarr != '{}' AND is_act AND NOT isinst AND sop_id NOT IN (SELECT sop_id FROM stages WHERE ptstid = 1075 AND isinst)
+where ptstid = {ID ETAPU stages_def.ptstid} AND orgarr != '{}' AND is_act AND NOT isinst AND sop_id NOT IN (SELECT sop_id FROM stages WHERE ptstid = {ID ETAPU stages_def.ptstid} AND isinst)
 ) aa
 order by procid,sop_id;