D2 - Context

#Finding Context

#===================================================================================

select r_object_id,object_name,dql_from,dql_where,parent_names,parent_order_no,order_no from d2_documentset where object_name ='{context_name}'

 

#Specific Config against Contexts

#===================================================================================

select cnf.r_object_id, cnf.config_name,cnf.documentset_name from d2_documentset_switch cnf where cnf.object_name='{config_name}' and any cnf.config_name='{config_element_name}' and i_position=i_position enable(ROW_BASED);

 

#All Config against context

#==================================================================================

select cnf.r_object_id,cnf.object_name, cnf.config_name,cnf.documentset_name from d2_documentset_switch cnf where cnf.object_name IN (select distinct object_name from d2_documentset_switch ) and any cnf.documentset_name like '%{config_element_name}' and i_position=i_position enable(ROW_BASED);

 

#Config Name

#=======================================================

select distinct object_name from d2_documentset_switch

 

c2_export_config

c2_print_config

c2_rendition_config

c2_view_config

cd_controlledprint_profiles

d2_acl_config

d2_audit_config

d2_checkin_config

d2_checkout_config

d2_extended_create_config

d2_filter_config

d2_inheritance_config

d2_lifecycle_batch_config

d2_lifecycle_config

d2_link_config

d2_linked_document_config

d2_mailing_config

d2_mass_update_config

d2_menus_config

d2_naming_config

d2_pdfrender_config

d2_portalmenus_config

d2_property_config

d2_queryform_config

d2_search_config

d2_sendmail_config

d2_skin_config

d2_subscription_config

d2_template_config

d2_toolbars_config

d2_treeview_config

d2_uniqueness_config

d2_user_preferences_config

d2_vdtemplate_config

d2_workflow_config

o2_attribute_config

x3_graphic_config

x3_skin_config

x3_space_config

x3_widget_config