资源描述:
《移植流程图的数据库》由会员上传分享,免费在线阅读,更多相关内容在应用文档-天天文库。
1、a.移植工作流b.移植“角色”当遇到插不进去时,删去对于的字段。processrev=4想要倒的流程图的版本号app='DXMADD'修改为相应的应用程序名字selectMAXROLE,DESCRIPTION,ISEMAILDATASET,PARAMETER,ISBROADCAST,OBJECTNAME,'MAXROLEseq.nextval'MAXROLEID,TYPE,VALUE,LANGCODE,HASLD,SENDERSYSIDfrommaxrolewhereMAXROLEin(selectdistinctroleidfro
2、mWFASSIGNMENTwhereapp='DXMADD'andrecordkeyisnullandprocessrev=4)方法:首先执行上面语句,查出结果,如图导出SQL语句,导出结果如下:当执行插入到新的数据库中时,记得去掉'MAXROLEseq.nextval'左右的单引号c.移植“操作”select'ACTIONseq.nextval'ACTIONID,ACTION,DESCRIPTION,OBJECTNAME,TYPE,VALUE,PARAMETER,LANGCODE,MEMO,USEWITH,HASLD,SENDER
3、SYSID,VALUE2fromactionwhereactionin(selectdistinctactionfromWFACTIONwhereprocessNAME='DXMADD'andprocessrev=4)d.移植操作角色相对应的“人员组”,及“人员组中的人”。1---->用下面的句子导出人员组。select'PERSONGROUPseq.nextval'PERSONGROUPID,PERSONGROUP,DESCRIPTION,LANGCODE,HASLDfrompersongroupwherepersongroupi
4、n(selectvaluefrommaxrolewhereMAXROLEin(selectdistinctroleidfromWFASSIGNMENTwhereapp='DXMADD'andrecordkeyisnullandprocessrev=4))2---->用下面的句子导出人员组中的人员。selectRESPPARTYGROUP,RESPPARTY,RESPPARTYGROUPSEQ,RESPPARTYSEQ,USEFORORG,USEFORSITE,GROUPDEFAULT,ORGDEFAULT,SITEDEFAULT,'
5、PERSONGROUPTEAMseq.nextval'PERSONGROUPTEAMID,PERSONGROUPfromPersongroupteamwherePERSONGROUPin(selectPERSONGROUPfrompersongroupwherepersongroupin(selectvaluefrommaxrolewhereMAXROLEin(selectdistinctroleidfromWFASSIGNMENTwhereapp='DXMADD'andrecordkeyisnullandprocessrev=4)
6、))