Calculated Registry entry

Specify a semi-colon separated list of fields where each field's value is calculated by a Standards module Field Definition record.

EMu 10 introduced the option to calculate field values in a module via a Standards module Field Definition record (Record Type = Field Definition). A Field Definition record includes a script that is executed whenever a record is created or modified, the result of which is a value that is assigned to a field immediately before the record is saved

The Calculated Registry entry value is a semi-colon separated list of back-end field names. For each field in the list, the Standards module is checked to see whether a corresponding Field Definition record exists. If it does, the associated script code is executed and the resulting value is assigned to the field. The field values are calculated in the order they are defined in the Registry entry, and a calculated value is therefore available to fields calculated later in the list. As such, a Calculated Registry entry value of SummaryData;ExtendedData would make the calculated value of SummaryData available when calculating the value of ExtendedData.

Details about how to define Standards records to calculate field values can be found here.

Here we see an example Field Definition record where the Summary Data is to be calculated:

Field Definition

Here is some of the associated script code used to calculate the Summary Data value:

Field Definition code

Note: Standards module record definitions for Summary Data and Extended Data for the base EMu modules (excluding the Catalogue) have been provided with EMu 10. These can be modified to suit each institution's specific requirements.

Usage

This Registry entry can be assigned to users, groups and system-wide:

Key User Group System
Key 1 User Group System
Key 2 user group Setting
Key 3 Setting Table
Key 4 Table Default or table
Key 5 Default or table Calculated
Key 6

Calculated

 
Value fieldlist
User user Setting Table Default or table Calculated fieldlist
Group group Setting Table Default or table Calculated fieldlist
System Setting Table Default or table

Calculated

fieldlist

where:

fieldlist

is in the format:

field;field;...

where field is the back-end name for a field whose value is to be calculated.

See Field Level Help for details of how to find a field's back-end name.

Example

This entry specifies that the Summary Data and Extended Data values for the Thesaurus module are calculated via their respective Field Definition records in the Standards module:

Key Setting
Key 1 System
Key 2 Setting
Key 3 Table
Key 4 ethesaurus
Key 5 Calculated
Value SummaryData;ExtendedData