MDN self-hosted library · e01.org

IDBIndex: getAll() method

IndexedDB

IndexedDB

The getAll() method of the IDBIndex interface retrieves all objects that are inside the index.

There is a performance cost associated with looking at the value property of a cursor, because the object is created lazily. To use a feature like getAll(), the browser has to create all the objects at once. If you are just interested in looking at each of the keys, for instance, it is more efficient to use a cursor. If you are trying to get an array of all the objects in an object store, though, you should use getAll().

Syntax

getAll()
getAll(query)
getAll(query, count)
getAll(options)

Parameters

The getAll() method can take separate parameters or a single options object containing the parameters as properties.

The parameters can include:

  • query
  • : A key or an IDBKeyRange identifying the records to retrieve. If this value is null or not specified, the browser will use an unbound key range.
  • count
  • : The number of records to return. If this value exceeds the number of records in the query, the browser will only retrieve the queried records. If it is lower than 0 or greater than 2^32 - 1 a TypeError exception will be thrown.

If an object parameter is specified, its properties can include:

  • query
  • : See the earlier query definition.
  • count
  • : See the earlier count definition.
  • direction
  • : An enumerated value specifying the direction in which the objects are traversed. Possible values are:
    • next
    • : The objects are traversed from the beginning, in increasing key order. This is the default value.
    • nextunique
    • : The objects are traversed from the beginning, in increasing key order. For every key with duplicate objects, only the object closest to the start is yielded.
    • prev
    • : The objects are traversed from the end, in decreasing key order.
    • prevunique
    • : The objects are traversed from the end, in decreasing key order. For every key with duplicate objects, only the object closest to the start is yielded.

Return value

An IDBRequest object on which subsequent events related to this operation are fired.

If the operation is successful, the value of the request's result property is an Array of the values of all records matching the given query, up to the value of count, if count was supplied.

Exceptions

This method may raise a DOMException of the following types:

  • TransactionInactiveError DOMException
  • : Thrown if this IDBIndex's transaction is inactive.
  • InvalidStateError DOMException
  • : Thrown if the IDBIndex has been deleted or removed.
  • TypeError
  • : Thrown if the count parameter is not between 0 and 2^32 - 1, inclusive.

Examples

const myIndex = objectStore.index("index");
const getAllRequest = myIndex.getAll();
getAllRequest.onsuccess = () => {
  console.log(getAllRequest.result);
};

Specifications

Browser compatibility

See also