文档介绍:a. 移植工作流 b. 移植“角色”当遇到插不进去时,删去对于的字段。 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 语句, 导出结果如下: 当执行插入到新的数据库中时,记得去掉'' 左右的单引号 c. 移植“操作” 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) d. 移植操作角色相对应的“人员组”,及“人员组中的人”。 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