Please enable JavaScript to view this site.

Vernon CMS Help

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.