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 |
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