Item list

The item list specifies one or more item-IDs in the file defined by the associated file reference.

The item list may be:

a single item-ID.
multiple item-IDs separated by spaces. Note: if there is a space in the item-ID, use single quotes to surround the item-ID.
an asterisk indicating all items.
an active list that can be generated by processes, such as select, sselect, qselect, get-list, form list (fl), and so on.
Null

If a select list is not active, a null item-ID implies a new item for Update processor and all items for the other processors.

Any command requiring a select list can obtain it from a previously selected list. To cause a processor to use the select list, the item list must be null. An item-ID with the same name as a language element in either the master dictionary or the dictionary of the file, must be enclosed in single quotation marks.

When a list is active, item.list is omitted from the (AQL) command:

select entity

17827971 items selected.

copy entity

If a specific list of item-IDs or asterisk is provided while a list is active, the active list is ignored.

If a valid AQL command is provided without a specific list of item-IDs, all items are implied.

Syntax

command file.reference item-ID
command file.reference item-ID item-ID item-ID...
command file.reference{*}

Example(s)

This lists the specific item *a0, from the master dictionary of the current account.

list md '*a0'

Since *a0 is a valid attribute-defining item (ADI), this sentence produces output showing attribute 0 of every item in the current master dictionary.

list md *a0

This sentence requests a specific set of item-IDs from the invoices file, and in D3.

list invoices 's1000' 's1010' 's1001'

It is also valid as:

list invoices s1000 s1010 s1001

Item list

Syntax

Example(s)

See also