DQL - Method Execution

 Method Execution

=============================================================

EXECUTE do_method WITH method = '<method_name>', arguments = '-<parameter> <paramter_value>';

 

Applying D2 config to particular object in D2

============================================================== 

EXECUTE do_method with method = 'D2UpdateChildACLMethod',arguments = '-docbase_name <docbase> -user_name <username> -password <password> -acl_config_name "Cat 1-3 Controlled Document Security Model"';

 

Applying D2 config (Lifecyle) to particular object in LSQM/LSRD

==============================================================

EXECUTE do_method with method = 'CDFApplyD2ConfigurationsMethod',arguments = '-docbase_name "%REP_NAME%" -user_name "%INST_OWNER%" -password "%INST_OWNER_PASSWORD%" -qualifier "cd_common_ref_model(all) where r_object_id =''<r_object_id>''" -verbose true -auto_naming false -auto_linking false -new false -security false -state_transition "<Lifecycle_state_name>"'

 

Applying D2 config (Auto Linking) to particular domain in LSQM/LSRD

============================================================== 

EXECUTE do_method with method = 'CDFApplyD2ConfigurationsMethod',arguments = '-docbase_name "%REP_NAME%" -user_name "%INST_OWNER%" -password "%INST_OWNER_PASSWORD%" -qualifier "cd_common_ref_model(all) where domain in(''Labeling'',''Regulatory/Administrative'')" -verbose true -auto_naming false -auto_linking true -new false -security false -delete_empty_folders /Regulatory'

 

NOTE : Query criteria should be in double single quotes NOT double quotes

D2 - Autolink

 #AutoLink

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

select r_object_id,object_name,"path","type" from d2_link_config where object_name IN ('{auto_link_name}') and i_position = -1 enable(row_based);

 

#Autolink applied Context

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

select cnf.r_object_id,cnf.object_name as auto_link,mtx.documentset_name from d2_link_config cnf,d2_documentset_switch mtx where mtx.object_name='d2_link_config' and any mtx.config_name='{auto_link_name}' and any mtx.config_name=cnf.object_name and i_position=-1 enable(row_based);

D2 - Workflow

 #D2 Workflow Config

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

select r_object_id,object_name,associated_dm_process from d2_workflow_config where object_name IN('{workflow_config_name}');

 

#D2 Workflow Report

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

select w.r_object_id, w.object_name as task_subject, w.owner_name as user_name, ' ' as task_details, w.tracker_state as task_state, w.start_date as date_sent, w.scheduled_end_date as due_date, 'Workflow' as object_type from d2c_workflow_tracker w where r_object_id in (select distinct w.r_object_id  from dm_relation r, d2c_workflow_tracker w where r.relation_name = 'D2_WF_TRACKER_DOCUMENT' and r.child_id = '<r_object_id>' and r.parent_id = w.r_object_id) order by w.r_creation_date desc

D2-Public Searches

#Public Searches

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

SELECT   r_object_id, object_name,owner_name,is_public, a_status, dql  FROM   d2c_query_dql 

D2- C2 Print Configuration

 #D2 Uncontrolled Print Overlay

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

select * from c2_layer  where object_name='{overlay_name}';

 

#D2 Controlled Print Overlay

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

select * from cd_cp_overlay where object_name='{overlay_name}'

 

#D2 Print profiles

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

select r_object_id,object_name,overlay,cover_page,c2_print_profile from cd_controlledprint_profiles where object_name='{profile_name}';

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

D2 - Dictionary

#Dictionary Values(Display Values -Key)

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

select v.object_name as name,d.alias_name as alias, v.alias_value as val from d2_dictionary d,d2_dictionary_value v where d.object_name = v.dictionary_name and d.object_name = '{dictionary_name}' and  v.i_position=d.i_position  enable (ROW_BASED);

 

select v.object_name as name,d.alias_name as alias,v.alias_value as display_value from d2_dictionary d,d2_dictionary_value v where d.object_name = v.dictionary_name and d.object_name = '{dictionary_name}' and v.object_name='{site}' and  v.i_position=d.i_position enable (ROW_BASED);

 

#Dictionary Values (Alias Values)

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

select v.object_name as name,v.alias_value as display_value from d2_dictionary d,d2_dictionary_value v where d.object_name = v.dictionary_name and d.object_name = '{dictionary_name}' and d.alias_name='{alias_name}' and  v.i_position=d.i_position order by 1 enable (ROW_BASED);

 

#Taxonomy with 2 dictionary levels

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

select distinct d2.object_name as name, d2.locale_value as display_value from d2_taxonomy t, d2_dictionary_value d1, d2_dictionary_value d2, dm_relation r1, dm_relation r2 where t.object_name = '{taxonomy_name}' and r1.parent_id = t.r_object_id and r1.child_id = d1.r_object_id and r1.relation_name = 'D2_TAXONOMY' and d1.object_name = '{value}' and r2.parent_id = d1.r_object_id and r2.child_id = d2.r_object_id and any d2.locale_value != ' ' order by 1 enable(row_based)

D2 - Widgets Query

#User Inbox

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

select stamp,stamp as r_object_id,task_state,item_type,priority,item_name,item_id,item_id as associate_id,task_name,task_subject,event,name,sent_by,date_sent,due_date,instruction_page,content_type,read_flag,router_id,supervisor_name from dmi_queue_item,dmi_workitem w where delete_flag=false and dequeued_by is nullstring and task_state<>'finished' and event<>'dm_changedactivityinstancestate' and  name = USER and item_id=w.r_object_id and w.a_wq_policy_id='0000000000000000';

 

 

#Workflow Overview

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

select w.r_object_id, w.object_name as task_subject, w.owner_name as user_name, ' ' as task_details, w.tracker_state as task_state, w.start_date as date_sent, w.scheduled_end_date as due_date, 'Workflow' as object_type from d2c_workflow_tracker w where r_object_id in (select distinct w.r_object_id  from dm_relation r, d2c_workflow_tracker w where r.relation_name = 'D2_WF_TRACKER_DOCUMENT' and r.child_id = '0901819780922762' and r.parent_id = w.r_object_id) order by w.r_creation_date desc