cm group item link

Database Table

Name cm_group_item_link
Prefix cgl
Group Item Group Item Link
Initial Build 2006.02

Overview

cm_group_item_link is a navigation metadata table. It is used to store information about (Content) Group Item Links.

Columns

Name Description Datatype Notes
cgl_key Link Key av_key  
cgl_cgi_key Item Key av_key  
cgl_cgr_key Group Key av_key  
cgl_link_text Link Text nvarchar(50)  
cgl_link_path Link Path av_url  
cgl_link_file Link File nvarchar(50)  
cgl_link_param Link Parameters nvarchar(250)  
cgl_link_descr Link Description nvarchar(100)  
cgl_override_form_title Override Form Title nvarchar(50) Text to use in headers on Find, List and Query pages instead of using the Form Description.
cgl_target_new Open in New Window? av_flag  
cgl_order Link Order av_integer  
cgl_exclude_from_bar Exclude From Top Bar? av_flag  
cgl_dynamic_form Dynamic Form av_key  
cgl_rpt_key Report av_key  
cgl_wiz_key Wizard av_key  
cgl_list_add_flag List Add Icon av_flag  
cgl_help_flag Help Link av_flag Relates to online documentation.
cgl_new_browser_flag New Browser av_flag When checked, will open the link in a new browser window.
cgl_add_date Add Date av_date  
cgl_add_user Add User av_user  
cgl_change_date Change Date av_date  
cgl_change_user Change User av_user  
cgl_delete_flag Delete Flag av_delete_flag  
cgl_entity_key Entity Key av_key  

Parent Tables

Parent Table Parent Key Child Key Join
cm_group_item cgi_key cgl_cgi_key cgl_cgi_key = cgi_key
cm_group_item cgi_cgr_key cgl_cgr_key cgl_cgr_key = cgi_cgr_key
cm_group cgr_key cgl_cgr_key cgl_cgr_key = cgr_key
md_dynamic_form dyn_key cgl_dynamic_form cgl_dynamic_form = dyn_key
md_report rpt_key cgl_rpt_key cgl_rpt_key = rpt_key
md_wizard wiz_key cgl_wiz_key cgl_wiz_key = wiz_key

Child Tables

Child Table Parent Key Child Key Join
fw_group_x_link cgl_key fgl_cgl_key fgl_cgl_key = cgl_key
md_page_access cgl_key mpa_cgl_key mpa_cgl_key = cgl_key