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!arg6!arg7
arg2 |
Optional |
Internal field name of the field to be checked and the system ID of the value to check for, delimited by a semi-colon. If arg2 is not specified, all rows are returned. 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 all rows are returned
|
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).
|
arg6 |
Optional |
Sort by. Specify the internal field name(s) of the fields you want to sort by. If this is not specified, the default sorting will be used. The sorting options are specified in this order, separated by a semi-colon ; For example, this would specify sorting on the Update User, and Update Date fields, with an conversion to sort on the internal value of the Date field, it will be sorting in ascending direction, and will be numerically justified, UPDATE_USER&UPDATE_DATE;1;A;N |
arg7 |
Optional |
Sub delimiter override. If this is not specified, default delimiters are Value Marks, if #n or #Last was specified in arg2, otherwise the delimiter is a comma and a space ", ". |
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.
Example:
EXTRACT.AMV!!UPDATE_USER;UPDATE_DATE!!!UPDATE_USER&UPDATE_DATE;1;A;N
This argument will return the Update History table, sorted by user and sorted in ascending order by date.