Show/Hide Toolbars

Thereforeā„¢ Help

Reference > Solution Designer > Design

Referenced Tables

Scroll

hmtoggle_arrow0 See Also

 

Referenced Tables allow a category's or case definition's index fields to reference data in an external database. This provides a convenient way to link an index field to a database table from another system. Typically, this is done by setting up a view of the external database within the Thereforeā„¢ database.

 

The table needs to be in the Thereforeā„¢ database. Typically this is done by creating a view on the external database. Another option is using table replication:

Tutorial: Table Replication

 

It is also possible to define a referenced table in Thereforeā„¢ which references data from a web service as opposed to data in a database. This is done by specifying REST calls to retrieve the data from a web service.

Reference: Referenced Web Service

Tutorial: Referenced Web Service

 

Right-clicking on the Referenced Tables object opens its context menu.

SD_R_Design_Data_Types_001

 

New Referenced Table...

Opens a dialog for creating a new referenced table (see Creating a new referenced table).

 

New Referenced Web Service...

Opens a dialog for configuring a new referenced web service.

Reference: Referenced Web Service

 

New Folder...

Create a folder (sub folder) to help organize referenced tables.

 

Export...

Export the configuration definition.

 

Security Report...

The security report contains all security settings. It allows you to document the final security configuration after installing a system. The security report is stored as a ".csv" file.

 

Security

View and edit role-based access for anything below this node.

Reference: Role-based access

 

Right-clicking on a particular referenced table opens up a different context menu.

 

SD_R_Design_Data_Types_002

 

Open Referenced Table

Opens the Referenced Table dialog. A name for the referenced table must be specified, the table or view must be chosen and the column must be specified. This column will be the unique identifier for all dependent fields based on this referenced table.

SD_R_Design_Data_Types_003

Delete Referenced Table

Deletes the selected referenced table.

 

Info

It is not possible to delete a referenced table if it is being used by one or more categories. You must first delete the field in every category that references the table.

 

Note

When you remove an index field from a category definition, all of the existing values in every document saved to Thereforeā„¢ for that category will be removed.

 

Export...

Export the configuration definitions for the selected referenced table.

 

Security

View and edit role-based access for anything below this node.

Reference: Role-based access

Ā© 2024 Therefore Corporation, all rights reserved.