TITAN CMS - Data Relationship Information

Titan version details, chart on allowed columns & relationship functinality and how to configure a relationship!

Overview

Relationships allow you to define how content from within one or two Data Tables (v6.8) or two Data Tables (v6.7 & v6.6) under 1 Schema are related.

Content is related by establishing links, correlating data values, or using Tags and Lookups. Relationships are used by the Data Detail block to combine content from the related Tables and display it on a single page. 

Under 1 Schema, build Data tables with columns desired.  *To create relationships a Schema must have One or Two Tables (v6.8) or only two Tables (v6.7 & v6.6) with Columns that allow relationships. These Tables must also have Data Sites configured before a relationship record may be added.

v6.8:  Chart for columns that allow relationships:

Parent (A)

(column type)

Child (B)

(column type)

Display - Design
Text (1 line) Text (1 line) No extra design work needed
Text (1 line) Radio Buttons *Custom design
Text (1 line) External Key No extra design work needed
External Key Text (1 line) No extra design work needed
External Key Radio Buttons *Custom design
External Key External Key No extra design work needed
Number (Integer) Number (Integer) No extra design work needed
Lookup Lookup *Custom design
Radio Buttons Text (1 line) *Custom design
Radio Buttons Radio Buttons *Custom design
Radio Buttons External Key *Custom design
Page URL Links *dependent on Page URL to show in Parent List *Custom design *Table Name shows on tab, detail includes input name but no link to click. Links only work in the Freeform column type for detail.

v6.7 and Prior:  Chart for columns that allow relationships between 2 tables:

Table A Table B
Text (1 line) Text (1 line)
Text (1 line) Radio Buttons
External Key Text (1 line)
External Key Radio Buttons
Number (integer) Number (Integer)
Lookup Lookup
Radio Buttons Text (1 line)
Radio Buttons Radio Buttons
Page URL Data Links
v6.8 HINTS

Relationship Chart

  • If the input in column matches (A=B) a relationship record would display in the data detail display.  In v6.8 valid columns from a table can relate to a different column in the same table, or a column from a different table.
  • *Main use for this new enhancement will be used with Lookups.
  • The Tab Name in data detail relationship display will be the relationship name, not the table name.
  • The website display will display a tab for each valid relationship name that has a match.  Each tab will contain records that are there because of that specific relationship.
  • Relationships need to be configured under 1 Schema.
  • External Key inputs must still be unique.
  • Relationship Names may be the same name.   The name is mainly for XSL developers to discern which related data is which.  However, the fact that names could be the same gives the option to group content from separate relationships together on the display.
  • Sorting would need to be added through customization.
  • Basic Styling:  Related items will have alternating row colors and spacing so it's easier to differentiate between a list of related items on a tab.
  • Do not use the "ALL" attribute, the match of relationship inputs will not work.  Assign the specific ie. Lookup attribute such as "Manufacturing" 
Steps (v6.8)

1. Select Titan Admin module.

2.  Add Schema or select existing Schema and add your Table & Columns  *Verify columns desired to use in relationships allow relationships.

NOTE:  At this point adding a Relationship record is disabled

3. Add Data Site and link to your Schema/Table

NOTE:  At this point, you are able to Add Relationship record

6.  Select Add New and enter name for the Relationship record.

7. Make Relationship selections based on Tables and Columns

8. Save & Refresh

9.  Data List & Data Detail blocks need to be built.  *Data Detail will now include relationship checkbox.

*To See Example, view ____, select client from list and view detail - The inputs for the Address columns must match in order to pull in Industry relationship information.

 

 

Steps (v6.7 & v6.6)

1. In Titan Admin module, Build Table A & Columns

2. Build Table B & Columns

3. Verify columns desired to use in relationships allow relationships.

NOTE:  At this point adding a Relationship record is disabled

4. Add Data site and link to Table A

5. Add Data site and link to Table B

NOTE:  At this point, you are able to Add Relationship record to connect Tables & Columns - Table A to Table B

6.  Select Add New and add name, the relationship record with options displays.

7. Make relationship selections based on Tables and Columns

8. Save & Refresh

9.  Data List & Data Detail blocks need to be built.  *Data Detail will now include relationship checkbox.

*To See Example, view data list, select client from list and view detail - The inputs for the Address columns must match in order to pull in Industry relationship information.

 

 

Prerequisites
 

Log in to the workstation:

  1. Enter your TitanCMS URL in a browser address bar.
  2. The Titan Login screen will appear.
  3. Enter your User Name in the User Name field.
  4. Enter your Password in the Password field.
  5. Click Log In.  The TitanCMS application should open to the Titan Web Content Management Module.
Titan CMS Training

Check out upcoming Titan CMS Training Classes
 

Learn at Northwoods 

Workshops
 

Titan CMS Support

(414) 914-9200
Submit Questions
 

Northwoods Web Solutions

p: (414) 914-9100