BuckupParfile.par

version=10.2.0.1.0  

 

CONTENT=DATA_ONLY

 

tables=WF_ASSISTANTITEM,MOD_UDFVALUE,WF_TRANSITION,WF_WIPARTICIPANT,WF_OPERATELOG,WF_WORKITEM,WF_ACTIVITYINST

 

query = MOD_UDFVALUE:"WHERE FK_ID IN (SELECT WORKITEMID FROM WF_WORKITEM WHERE PROCESSINSTID IN(SELECT PROCESSINSTID FROM WF_PROCESSINST WHERE PROJ_ID='%proj_id%'))"
query = WF_ASSISTANTITEM:"WHERE WORKITEMID IN (SELECT WORKITEMID FROM WF_WORKITEM WHERE PROCESSINSTID IN(SELECT PROCESSINSTID FROM WF_PROCESSINST WHERE PROJ_ID='%proj_id%'))"
query = WF_TRANSITION:"WHERE PROCESSINSTID IN(SELECT PROCESSINSTID FROM WF_PROCESSINST WHERE PROJ_ID='%proj_id%')"
query = WF_WIPARTICIPANT:"WHERE PROCESSINSTID IN(SELECT PROCESSINSTID FROM WF_PROCESSINST WHERE PROJ_ID='%proj_id%')"
query = WF_OPERATELOG:"WHERE WORKITEMID IN (SELECT WORKITEMID FROM WF_WORKITEM WHERE PROCESSINSTID IN(SELECT PROCESSINSTID FROM WF_PROCESSINST WHERE PROJ_id='%proj_id%'))"
query = WF_WORKITEM:"WHERE PROCESSINSTID IN(SELECT PROCESSINSTID FROM WF_PROCESSINST WHERE PROJ_ID='%proj_id%')"
query = WF_ACTIVITYINST:"WHERE PROCESSINSTID IN(SELECT PROCESSINSTID FROM WF_PROCESSINST WHERE PROJ_ID='%proj_id%')"

 

//  %proj_id%   项目id  该参数在执行前需要赋值