Purpose/Function
Allows you to extract specific rows and data from tables, e.g. to extract the first row of data only, or to extract data of a specific type, such as all Other IDs of the type Old Accession Number.
Argument syntax and parameters
EXTRACT.AMV!arg2!arg3!arg4!arg5
arg2 |
Required |
Internal field name of the field to be checked and the system ID of the value to check for, delimited by a semi-colon, e.g. OTHER_ID_TYPE;ETH (where 'ETH' is the system ID of the Other Id Type 'Ethnology No'). To check for multiple values, e.g. multiple other ID types, delimit system IDs with a comma, e.g. OTHER_ID_TYPE;ETH,ANT (where 'ANT' is the system ID of the Other Id Type 'Anthropology No'). OR #NULL to extract all rows with data entered in the check field, i.e. where the check field is not null. #n (where 'n' is the row number) to extract a particular row, e.g. #1 to extract the first row of data. #LAST to extract the last row of the table.
|
arg3 |
Required |
Internal field names of fields to be displayed, delimited by ';' e.g. OTHER_ID;OTHER_ID_TYPE;OTHER_ID_NOTES.
|
arg4 |
Optional |
Maximum number of rows to be returned. If this is not specified, then maximum is set to 999.
|
arg5 |
Optional |
Conversion. If set to 1, then no conversion. Otherwise, enter an aligned set of conversion overrides , delimited by ';' If this part of the argument is not specified, convert as per dictionary (i.e. use the default conversion).
|
Parts of the argument are delimited by an exclamation mark.
Example:
EXTRACT.AMV!OTHER_ID_TYPE;ETH!OTHER_ID;OTHER_ID_NOTES
where ETH is the system ID of the Other ID Type Ethnology No.
The above argument will extract rows where the Other ID Type is Ethnology No and will display the Other ID and Other ID Notes fields.
