INFOREAM部门级数据过滤.doc

以“材料计划 ” 为例1， 为用户基本信息添加部门信息 usr_mrc字段，和EVT_mrc 保持一致。2，复制 “所有记录”的dataspy 命名为：“本部门材料计划” ，勾选 “安全性筛选”在“高级”选择设置where过滤条件：1=1 and ( evt_mrc in (select usr_mrcfrom r5userswhere usr_code=o7sess.cur_user and usr_mrc is not null ) or (o7sess.cur_group=JXBJL and evt_mrc like %检修部%) or (o7sess.cur_group=YXBJL and evt_mrc like %运行部%)根据项目需要,客户化信息：3， 为相关需要过滤的用户组，将该用户的“材料计划”程序，安全性筛选设置为：”本部门材料计划”安全性过滤：select * from r5dddataspy t where t.dds_ddspyid= 100124select * from r5queryfield qf where qf.dqf_ddspyid= 100124 -&和dataspy 有关select * from r5home h where h.hom_ewsdataspyid= 100124 -该表和安全性过滤的DATASPY 无关联select * from r5hyperlink w where w.hyp_dataspy= 100124 -该表和安全性过滤的DATASPY 无关联select * from r5opvariables p where p.ovd_ddspyid= 100124 -该表和安全性过滤的DATASPY 无关联select * from r5permissions per where per.prm_securityddspyid= 100124 -该表为设置安全性过滤的DATASPY ，和新建无关select * from r5queryfield qf where qf.dqf_ddspyid= 100124 -&和dataspy 有关select * from r5tabpermissions tp where tp.trp_securityddspyid= 100124 -该表为设置安全性过滤的DATASPY ，和新建无关 select * from r5usegridgisdefault gg where gg.ugd_dataspyid= 100124 -该表和安全性过滤的DATASPY 无关联select * from r5usegridsysdefault gd where gd.usd_dataspyid= 100124 -该表和安全性过滤的DATASPY 无关联INSERT INTO r5dddataspy ( dds_ddspyname, dds_ddspyid, dds_autorun, dds_scope, dds_organization, dds_updatestamp, dds_updatebyuser, dds_createdstamp, dds_updateable, dds_filterstrxml, dds_sortstrxml, dds_fieldlist, dds_updatecount, dds_displayrow, dds_owner, dds_gridid, dds_type, dds_defaultflag, dds_fieldlist_portlet, dds_clientrows, dds_portletrows, dds_botname, dds_securitydataspy,dds_mekey ) VALUES ( j.dds_ddspyname, newddsid, j.dds_autorun, j.dds_scope, j.dds_organization, j.dds_updatestamp, j.dds_updatebyuser, j.dds_createdstamp, j.dds_updateable, j.dds_filterstrxml, j.dds_sortstrxml, j.dds_fieldlist, j.dds_updatecount, j.dds_displayrow, j.dds_owner, newgridid, j.dds_type, j.dds_defaultflag, j.dds_fieldlist_portlet,j.dds_clientrows, j.dds_portletrows, j.dds_botname, j.dds_securitydataspy, j.dds_mekey); INSERT INTO r5queryfield( dqf_ddspyid, dqf_fieldid, dqf_columnwidth, dqf_columnorder, dqf_updatecount, dqf_viewtype ) SELECT newddsid, dqf_fieldid, dqf_columnwidth, dqf_columnorder, dqf_updatecount, dqf_viewtype FROM r5queryfield WHERE dqf_ddspyid = j.dds_ddspyid;INSERT INTO r5dddataspy ( dds_ddspyname, DDS_USERFILTER, dds_ddspyid, dds_scope, dds_organization, dds_updatestamp, dds_updatebyuser, dds_createdstamp, dds_updateable, dds_filterstrxml, dds_sortstrxml, dds_fieldlist, dds_updatecount, dds_displayrow, dds_owner, dds_gridid, dds_type, dds_defaultflag, dds_fieldlist_portlet, dds_clientrows, dds_portletrows, dds_botname, dds_securitydataspy, dds_mekey ) ( select 后台插入的DATASPY材料计划, evt_mrc=设备部汽机,s5dds.nextval,j.dds_scope, j.dds_organization, j.dds_updatestamp, j.dds_updatebyuser, j.dds_createdstamp, j.dds_updateable, j.dds_filterstrxml, j.dds_sortstrxml, j.dds_fieldlist, j.dds_updatecount, j.dds_displayrow, j.dds_owner, j.dds_gridid, j.dds_type, j.dds_defaultflag, j.dds_fieldlist_portlet,j.dds_clientrows, j.dds_portletrows, j.dds_botname, j.dds_securitydataspy, j.dds_mekey from r5dddataspy j where dds_ddspyid=100124 );commit; INSERT INTO r5queryfield( dqf_ddspyid, dqf_fieldid, dqf_columnwidth, dqf_columnorder, dqf_updatecount, dqf_viewtype ) (SELECT (s