BuckupParfile.par

最新推荐文章于 2021-03-24 12:24:16 发布

zqd32

最新推荐文章于 2021-03-24 12:24:16 发布

阅读量546

点赞数

文章标签： transition query

本文链接：https://blog.csdn.net/zqd32/article/details/6441532

版权

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 该参数在执行前需要赋值