Reference Data

From CaseTalk Wiki
Revision as of 04:26, 11 May 2022 by Marcow (talk | contribs)
Jump to: navigation, search

Reference Data

This is an experimental option in CaseTalk 11.0. Future versions may drop this functionality to replace it with more consistent user interface.

This is a four step procedure:

  1. Declare an annotation in the custom attributes called Reference Data.
  2. Turn on reference data linking in Tools\Preferences\Advanced\Link Reference Data.
  3. Enter a SQL Query in the Reference Data Annotation of a specific Object/Fact Type.
  4. Open the Population Editor, open the Reference Data Tab, mark the desired rows, and click Copy Refs.

Specify SQL

The Custom Attribute Definition is extended with an annotation called 'Reference Data', and Object/Fact Types have this annotation filled.

To make proper use of this feature, the selected fields need to match label types in the information model. And some data may require a cast to render into visible text in the user interface. OtftReferenceData.png

Copy Reference Data

The population editor allows using data from this reference data.

PopulationReferenceData.png