Reference Data

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.

Copy Reference Data

The population editor allows using data from this reference data. Multiple rows can be selected, and by pressing the Copy Refs. button, these rows are copied in the population of the model itself.

Copy and Paste

A more traditional manner of working with this population is to use the Copy and Paste buttons. It allows the entire population to be copied to and from an external editor such as a spreadsheet.