Shared Events – Sort Witnesses by Consanguinity plus Name #sharedevent

Problem

The order in which witnesses of an event (sharers other than the Principal(s) are listed on screen and in reports is set by the order they were entered. Users have no control over it.

A Workaround

The WitnessOrder field in WitnessTable controls the order of output in the display of witnesses and in narrative reports but RootsMagic 7 provides no control for it.

This script modifies the WitnessOrder values so that they are sorted:

  1. Primary: Consanguinity of witness to reference person used by the RootsMagic SET RELATIONSHIPS function
  2. Secondary: Alphabetical order of the primary name of each person, including those not in a tree.

Clearing the relationships prior to execution results in a purely alphabetical sort.

It sets negative values in WitnessOrder so inspection of the WitnessTable readily reveals those set by the script.

WitnessOrderByRelationship+Name.JPG
Example of the WitnessTable modified by the script with negative values under WitnessOrder.

WitnessOrderByRelationship+Name.sql

Leave a Reply

Your email address will not be published. Required fields are marked *