Purpose/Function
Allows you to extract particular records related to a role or sub-role.
For example, you can extract all Object records that have Crown Lynn Potteries as the Primary Maker.
Argument syntax and parameters
EXTRACT.ROLES!arg2!arg3!arg4!arg5
arg2 |
Required |
The System ID of the related file, e.g. OBJECT, VE, or TR. |
arg3 |
Required |
The role code of the related field. For example to retrieve all objects where the person is a Primary Maker, use the role code PD.
For more examples, see the list below or contact us at support@vernonsystems.com. |
arg4 |
Optional |
The System ID of sub-role, e.g. ’3’ (where 3 may be the System ID for the sub-role Artist). |
arg5 |
Optional |
Conversion e.g. 1 – do not convert, returns System ID. If left blank, it will display the One Line Display for the record. |
Examples
EXTRACT.ROLES!OBJECT!PD!3!1
This argument will extract the Object records (as System IDs) that have the Person as a Primary Maker with the role Artist.
PD is the role code of ‘Primary Maker’ and 3 is the System ID for the sub-role ‘Artist’.
EXTRACT.ROLES!EN!OW!!1
This argument will extract and report the System IDs for the Entry records where the selected Person is the Owner.
EN is the Entry file, OW is the Owner role and there is no sub-role.
Example Role Codes
AS Association Person
CL Classifier
CO Controlling Institution
FU Funder
PD Production Person (pri & sec)
PP Production Person (primary)
PS Production Person (secondary)
FC Field Coll Person
Contact Vernon Systems for more examples, or other file role codes.