Please enable JavaScript to view this site.

Vernon CMS Help

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.
For example, 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 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 ;
You can include a conversion to sort on the internal value of the field instead of the output.  Specify this by using a 1 to sort on internal value.
You can sort in either ascending or descending direction. Specify this with A for ascending or D for descending.
You can have left, right, or numeric justified sorting. Specify this with L for left, N or R for numeric or right justified.

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 ", ".
If you want to override this, you can use %VM% for Value marks, %SVM% for sub-value marks, or %TM% for text marks.

 

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.