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:

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

See Also

Access Query Language

AQL Command Categories

count Command

list Command

list-item Command

list-label Command

nselect Command

reformat Command

s-dump Command

select Command

Selection Criteria

sort Command

sort-label Command

stat Command

sum Command

t-load Command

touch Command