文档介绍：
“角色”
当遇到插不进去时,删去对于的字段。
processrev=4 想要倒的流程图的版本号
app='DXMADD' 修改为相应的应用程序名字
select MAXROLE, DESCRIPTION, ISEMAILDATASET, PARAMETER, ISBROADCAST, OBJECTNAME,'' MAXROLEID, TYPE, VALUE, LANGCODE, HASLD, SENDERSYSID
from maxrole
where MAXROLE in(select distinct roleid from WFASSIGNMENT where app='DXMADD' and recordkey is null and processrev=4)
方法:首先执行上面语句,查出结果,如图
导出SQL语句,
导出结果如下:
当执行插入到新的数据库中时,记得去掉''左右的单引号
“操作”
select '' ACTIONID, ACTION, DESCRIPTION, OBJECTNAME, TYPE, VALUE, PARAMETER,
LANGCODE, MEMO, USEWITH, HASLD, SENDERSYSID, VALUE2
from action
where action in(select distinct action from WFACTION where processNAME ='DXMADD' and processrev=4)
“人员组”,及“人员组中的人”。
1---->用下面的句子导出人员组。
select '' PERSONGROUPID, PERSONGROUP, DESCRIPTION, LANGCODE, HASLD
from persongroup
where persongroup in (select value from maxrole where MAXROLE in(select distinct roleid from WFASSIGNMENT where app='DXMADD' and recordkey is null and processrev=4
))
2---->用下面的句子导出人员组中的人员。
select RESPPARTYGROUP, RESPPARTY, RESPPARTYGROUPSEQ,
RESPPARTYSEQ, , USEFORSITE, GROUPDEFAULT, ORGDEFAULT, SITEDEFAULT,'' PERSONGROUPTEAMID, PERSONGROUP
from Persongroupteam where PERSONGROUP in (select PERSONGROUP from persongroup where persongroup in (select value from ma