Example no_gen File

The following no_gen file can be used in a default Clarify database to generate a purge/archive directives file that archives similarly to the Clarify case.arc file.

case:stop_if:table_case t2::table_r_rqst t1::(t1.source_type = 0) and (t1.source_lowid=t2.objid)

case:stop_if:table_case t1::table_subcase t2::table_cls_factory t3::(t2.subcase2case=t1.objid) and (t3.factory2subcase=t2.objid)

case:stop_if:table_case t2::table_trans_record t1::(t1.trans_record2case=t2.objid)

case:stop_if:table_case t2::table_case t1::(t2.case_victim2case=t1.objid)

case:case2part_used:reference

case:caseinfo2demand_hdr:reference

subcase:subcase2cls_factory:reference

subcase:subcaseinfo2demand_hdr:reference

doc_inst:attach_info2doc_path:export

bug

probdesc

case:player2cas_cas_role

case:super2case

case:case_escal2escalation

case:case_info2fcs_detail

case:case_info2fcs_header

case:case_orig2job

case:case2r_rqst

case:chk_onhold2svc_intrup

case:case2trans_record

case:case2life_cycle

case:case_view2monitor

case:task2opportunity

case:case_rip2ripbin

subcase:aux_subcase2act_entry

subcase:subcase2escalation

subcase:subc_info2fcs_detail

subcase:subc_info2fcs_header

subcase:subcase2case

subcase:subcase2job

subcase:subc_view2monitor

subcase:subc_rip2ripbin

act_entry:act_entry2subcase

act_entry:act_entry2probdesc

act_entry:act_entry2workaround

act_entry:act_entry2notes_log

act_entry:act_entry2phone_log

act_entry:act_entry2resrch_log

act_entry:act_entry2commit_log

act_entry:act_entry2escalation

act_entry:act_entry2onsite_log

act_entry:act_entry2close_case

act_entry:act_entry2status_chg

act_entry:act_entry2svc_intrup

act_entry:act_entry2email_log

act_entry:act_entry2site_part

act_entry:act_entry2site

act_entry:act_entry2bug

act_entry:act_entry2close_bug

act_entry:act_entry2fix_bug

act_entry:act_xentry2subcase

act_entry:act_entry_child2parent

act_entry:act_entry_parent2child

act_entry:act_entry2biz_cal_hdr

act_entry:act_entry2schedule

act_entry:act_entry2disptchfe

act_entry:act_entry2employee

act_entry:act_entry2demand_dtl

act_entry:act_entry2todo

act_entry:act_entry2doc_inst

act_entry:act_entry2part_trans

act_entry:act_entry2to_do_entry

act_entry:act_entry2opportunity

act_entry:act_entry2contract

act_entry:act_entry2job

act_entry:act_entry2contact

act_entry:act_entry2module

act_entry:act_entry2task

act_entry:act_entry2exchange

act_entry:act_entry2exch_log

act_entry:act_entry2contr_itm

act_entry:entry2exch_timebomb

act_entry:act_entry2count_setup

act_entry:act_entry2case

act_entry:act_entry2reject_msg

participant:participant2act_entry

reject_msg:reject_reason2case

reject_msg:reject_reason2subcase

reject_msg:rej_reason2probdesc

reject_msg:reject_reason2bug

reject_msg:reject_msg2demand_dtl

reject_msg:reject_msg2opportunity

reject_msg:reject_msg2contract

reject_msg:reject_reason2job

reject_msg:reject_msg2task

reject_msg:reject_msg2dialogue

notes_log:case_notes2case

notes_log:subc_notes2subcase

notes_log:bug_notes2bug

notes_log:notes_log2bug_desc

notes_log:opp_notes2opportunity

notes_log:contr_notes2contract

notes_log:job_notes2job

notes_log:task_notes2task

notes_log:qq_notes2quick_quote

phone_log:case_phone2case

phone_log:subc_phone2subcase

phone_log:phone_log2condition

phone_log:opp_phone2opportunity

phone_log:task_phone2task

phone_log:contr_phone2contract

condition:case_condition2case

condition:subc_conditn2subcase

condition:cond_custsts2gbst_elm

condition:condition2probdesc

condition:bug_condition2bug

condition:condition2demand_dtl

condition:condition2contract

condition:opp_condition2opportunity

condition:job_condition2job

condition:task_condition2task

condition:condition2dialogue

workaround:solution2case

workaround:workaround2probdesc

workaround:workaround2act_entry

workaround:wa_attch2doc_inst

workaround:resolution2gbst_elm

workaround:workaround2template

resrch_log:case_resrch2case

resrch_log:subc_resrch2subcase

commit_log:commit_empl2employee

commit_log:bug_commit2bug

commit_log:opp_commit2opportunity

commit_log:job_commit2job

onsite_log:disfe_onsit2disptchfe

onsite_log:onsite_doer2employee

onsite_log:detail_onsite2demand_dtl

onsite_log:onsite_log2part_inst

onsite_log:onsite_log2exchange

status_chg:status_chg2bug

status_chg:status_chg2demand_dtl

status_chg:status_chg2opportunity

status_chg:job_status_chg2job

status_chg:contr_status_chg2contract

status_chg:status_chg2task

status_chg:status_chg2dialogue

email_log:bug_email2bug

email_log:old_email_stat2gbst_elm

email_log:new_email_stat2gbst_elm

email_log:contr_email2contract

email_log:opp_email2opportunity

email_log:cont_email2contact

email_log:task_email2task

doc_inst:attachment2workaround

doc_inst:doc_info2diag_hint

doc_inst:doc_inst2contract

doc_inst:doc_inst2site

doc_inst:doc_inst2site_part

doc_inst:doc_inst2act_entry

doc_inst:doc_inst2campaign

doc_inst:doc_inst2eco_hdr

doc_inst:doc_inst2eco_dtl

doc_inst:doc_inst2interact

doc_inst:doc_inst2demand_hdr

doc_inst:doc_inst2mod_level

doc_inst:doc_inst2bus_org

doc_inst:doc_inst2lit_req

doc_inst:doc_inst2lit_ship_req

doc_inst:doc_inst2opportunity

doc_inst:doc_inst2lead

doc_inst:doc_inst2contact

doc_inst:doc_inst2communication

doc_inst:doc_inst2template

disptchfe:disptchfe2onsite_log

disptchfe:disptchfe2fcs_detail

acd_call:acd_call_site2site

acd_call:acd_call_empl2user

scr_run:scr_run2contact

scr_run:scr_run2scr_response

scr_run:run_with2scr_run

scr_run:scr_run2campaign

scr_run:scr_run2lead_source

scr_run:scr_run2site_part

scr_run:scr_run2opportunity

scr_run:scr_run2contract

scr_run:scr_run2contr_itm

scr_run:scr_run2demand_dtl

scr_run:scr_run2site

scr_run:scr_run2task

scr_run:scr_run2bus_org

scr_run:scr_run2interact

scr_run:scr_run2lead

scr_response:response2scr_run

exchange:partner2site

exchange:exchange2act_entry

exchange:exchange2contract

exchange:exchange2onsite_log

exchange:exchange2exc_usr_role

exchange:exchange2exc_con_role

exchange:exchange2biz_cal_hdr

exchange:exchange2close_exch

exchange:exchange2exc_sit_role

exchange:exchange2exc_bch_role

exchange:last_close2close_exch

exch_log:exch_log2contact_role

exch_log:exch_log2user

exch_log:exch_log2close_exch

interact:interact2user

interact:interact2contact

interact:interact2lead_source

interact:interact2scr_run

interact:interact2mod_level

interact:interact2interact_txt

interact:member2interact

interact:interact2opportunity

hint_inst:hint_logic2prog_logic

workaround:Unique_field:id_number

workaround:Unique_relation:workaround2probdesc

wipbin:Unique_Field:title

wipbin:Unique_Relation:wipbin_owner2user

gbst_elm:Unique_Field:title

gbst_elm:Unique_Relation:gbst_elm2gbst_lst

participant

employee:Unique_Relation:employee2user

scrqstn_rspns:unique_field:seq_num

appointment:appt2schedule:export

schedule:no_delete

schedule:schedule2act_entry

doc_path:no_delete

demand_hdr:Unique_Field:header_number

script_qstn:Unique_Field:seq_num

script_qstn:Unique_Relation:question2call_script

hint_inst:hint_info2diag_hint:export

diag_hint:no_delete

case:case2address:export

address:no_delete

address:primary_addr2site

address:ship_addr2site

address:bill_addr2site

address:address2time_zone

address:address2country

address:address2state_prov

address:address2bus_addr_role

address:addr2site_addr_role

address:address2per_addr_role

address:bill_addr2contr_schedule

address:ship_addr2contr_schedule

address:bus_primary2bus_org

address:bill_addr2contr_itm

Did this topic help you? Email us your feedback.
Last updated: 8/1/2007 9:08:55 AM
© by Dovetail Software, Inc.