--工作流的定义表
--ITEMTYPE
select * from wf_item_types wit where wit.name = 'CUXTEST'; --wf_item_types_vl
--ATTRIBUTES
select * from wf_item_attributes wia where wia.item_type = 'CUXTEST';
--Processes/Functions/Notifications
select * from wf_activities wa where wa.item_type = 'CUXTEST';
select * from wf_activity_attributes waa where waa.activity_item_type = 'CUXTEST';
select * from wf_process_activities wpa where wpa.process_item_type = 'CUXTEST';
--messages
select * from wf_messages wm where wm.type = 'CUXTEST';
select * from wf_message_attributes wma where wma.message_type = 'CUXTEST';
---工作流实例表
select * from wf_items wi where wi.item_type = 'CUXTEST';
select * from wf_item_activity_statuses wias where wias.item_type = 'CUXTEST'
and wias.item_key = '1062-37';
select * from wf_item_attribute_values wiav where wiav.item_type = 'CUXTEST'
and wiav.item_key = '1062-37';
select * from wf_activity_attr_values waav where waav.name = 230112;
select * from wf_notifications wn where wn.message_type = 'CUXTEST';
select * from wf_notification_attributes wna where wna.notification_id =41563164;
--工作流用户表
wf_roles --角色视图,工作流引用角色的依据,有mail地址等信息
wf_user_roles--用户和角色关系视图,工作流可以根据它进行“群发”
--ITEMTYPE
select * from wf_item_types wit where wit.name = 'CUXTEST'; --wf_item_types_vl
--ATTRIBUTES
select * from wf_item_attributes wia where wia.item_type = 'CUXTEST';
--Processes/Functions/Notifications
select * from wf_activities wa where wa.item_type = 'CUXTEST';
select * from wf_activity_attributes waa where waa.activity_item_type = 'CUXTEST';
select * from wf_process_activities wpa where wpa.process_item_type = 'CUXTEST';
--messages
select * from wf_messages wm where wm.type = 'CUXTEST';
select * from wf_message_attributes wma where wma.message_type = 'CUXTEST';
---工作流实例表
select * from wf_items wi where wi.item_type = 'CUXTEST';
select * from wf_item_activity_statuses wias where wias.item_type = 'CUXTEST'
and wias.item_key = '1062-37';
select * from wf_item_attribute_values wiav where wiav.item_type = 'CUXTEST'
and wiav.item_key = '1062-37';
select * from wf_activity_attr_values waav where waav.name = 230112;
select * from wf_notifications wn where wn.message_type = 'CUXTEST';
select * from wf_notification_attributes wna where wna.notification_id =41563164;
--工作流用户表
wf_roles --角色视图,工作流引用角色的依据,有mail地址等信息
wf_user_roles--用户和角色关系视图,工作流可以根据它进行“群发”
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10321978/viewspace-693666/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10321978/viewspace-693666/