Item list

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

The item list can 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.


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


Example 1

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

 list md '*a0'

Example 2

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

Example 3

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