Web/API/IDBKeyRange

The IDBKeyRange interface of the IndexedDB API represents a continuous interval over some data type that is used for keys. Records can be retrieved from IDBObjectStore and IDBIndex objects using keys or a range of keys. You can limit the range using lower and upper bounds. For example, you can iterate over all values of a key in the value range A–Z.

A key range can be a single value or a range with upper and lower bounds or endpoints. If the key range has both upper and lower bounds, then it is bounded; if it has no bounds, it is unbounded. A bounded key range can either be open (the endpoints are excluded) or closed (the endpoints are included). To retrieve all keys within a certain range, you can use the following code constructs:

Range	Code
All keys ≥ x	`IDBKeyRange.lowerBound(x)`
All keys > x	`IDBKeyRange.lowerBound(x, true)`
All keys ≤ y	`IDBKeyRange.upperBound(y)`
All keys < y	`IDBKeyRange.upperBound(y, true)`
All keys ≥ x && ≤ y	`IDBKeyRange.bound(x, y)`
All keys > x &&< y	`IDBKeyRange.bound(x, y, true, true)`
All keys > x && ≤ y	`IDBKeyRange.bound(x, y, true, false)`
All keys ≥ x &&< y	`IDBKeyRange.bound(x, y, false, true)`
The key = z	`IDBKeyRange.only(z)`

A key is in a key range if the following conditions are true:

The lower value of the key range is one of the following:
- undefined
- Less than key value
- Equal to key value if lowerOpen is false.
The upper value of the key range is one of the following:
- undefined
- Greater than key value
- Equal to key value if upperOpen is false.

Note: This feature is available in Web Workers.

Properties

IDBKeyRange.lower Read only: Lower bound of the key range.
IDBKeyRange.upper Read only: Upper bound of the key range.
IDBKeyRange.lowerOpen Read only: Returns false if the lower-bound value is included in the key range.
IDBKeyRange.upperOpen Read only: Returns false if the upper-bound value is included in the key range.

Methods

Static methods

IDBKeyRange.bound(): Creates a new key range with upper and lower bounds.
IDBKeyRange.only(): Creates a new key range containing a single value.
IDBKeyRange.lowerBound(): Creates a new key range with only a lower bound.
IDBKeyRange.upperBound(): Creates a new upper-bound key range.

Instance methods

IDBKeyRange.includes(): Returns a boolean indicating whether a specified key is inside the key range.

Examples

The following example illustrates how you'd use a key range. Here we declare a keyRangeValue as a range between values of "A" and "F". We open a transaction (using IDBTransaction) and an object store, and open a Cursor with IDBObjectStore.openCursor, declaring keyRangeValue as its optional key range value. This means that the cursor will only retrieve records with keys inside that range. This range includes the values "A" and "F", as we haven't declared that they should be open bounds. If we used IDBKeyRange.bound("A", "F", true, true);, then the range would not include "A" and "F", only the values between them.

Note: For a more complete example allowing you to experiment with key range, have a look at our IDBKeyRange-example repo ([[../../../../../../mdn.github.io/indexeddb-examples/idbkeyrange/index|view the example live too]].)

function displayData() {
  var keyRangeValue = IDBKeyRange.bound("A", "F");

  var transaction = db.transaction(['fThings'], 'readonly');
  var objectStore = transaction.objectStore('fThings');

  objectStore.openCursor(keyRangeValue).onsuccess = function(event) {
    var cursor = event.target.result;
    if(cursor) {
      var listItem = document.createElement('li');
      listItem.innerHTML = '<strong>' + cursor.value.fThing + '</strong>, ' + cursor.value.fRating;
      list.appendChild(listItem);

      cursor.continue();
    } else {
      console.log('Entries all displayed.');
    }
  };
}

Specifications

Specification	Status	Comment
Indexed Database API 2.0The definition of 'IDBKeyRange' in that specification.	Recommendation	Initial definition.
Indexed Database API DraftThe definition of 'IDBKeyRange' in that specification.	Recommendation	Adds `includes()`.

Browser compatibility

Update compatibility data on GitHub

	Desktop						Mobile
	Chrome	Edge	Firefox	Internet Explorer	Opera	Safari	Android webview	Chrome for Android	Firefox for Android	Opera for Android	Safari on iOS	Samsung Internet
`IDBKeyRange`	Chrome Full support 24 Full support 24 No support 23 — 57 Prefixed' Prefixed' Implemented with the vendor prefix: webkit	Edge Full support 12	Firefox Full support 16 Full support 16 No support 10 — 16 Prefixed' Prefixed' Implemented with the vendor prefix: moz	IE Partial support 10	Opera Full support 15	Safari Full support 7	WebView Android Full support Yes	Chrome Android Full support Yes	Firefox Android Full support 22	Opera Android Full support 14	Safari iOS Full support 8	Samsung Internet Android Full support Yes
`bound`	Chrome Full support 24 Full support 24 No support 23 — 24 Prefixed' Prefixed' Implemented with the vendor prefix: webkit	Edge Full support 12	Firefox Full support 16 Full support 16 No support 10 — 16 Prefixed' Prefixed' Implemented with the vendor prefix: moz	IE Partial support 10	Opera Full support 15	Safari Full support 7	WebView Android Full support Yes	Chrome Android Full support Yes	Firefox Android Full support 22	Opera Android Full support 14	Safari iOS Full support 8	Samsung Internet Android Full support Yes
`includes`	Chrome Full support 52	Edge Full support ≤18	Firefox Full support 47	IE No support No	Opera Full support 39	Safari Full support 10.1	WebView Android Full support 52	Chrome Android Full support 52	Firefox Android Full support Yes	Opera Android Full support 41	Safari iOS Full support 10.3	Samsung Internet Android Full support 6.0
`lower`	Chrome Full support 24 Full support 24 No support 23 — 24 Prefixed' Prefixed' Implemented with the vendor prefix: webkit	Edge Full support 12	Firefox Full support 16 Full support 16 No support 10 — 16 Prefixed' Prefixed' Implemented with the vendor prefix: moz	IE Partial support 10	Opera Full support 15	Safari Full support 7	WebView Android Full support Yes	Chrome Android Full support Yes	Firefox Android Full support 22	Opera Android Full support 14	Safari iOS Full support 8	Samsung Internet Android Full support Yes
`lowerBound`	Chrome Full support 24 Full support 24 No support 23 — 24 Prefixed' Prefixed' Implemented with the vendor prefix: webkit	Edge Full support 12	Firefox Full support 16 Full support 16 No support 10 — 16 Prefixed' Prefixed' Implemented with the vendor prefix: moz	IE Partial support 10	Opera Full support 15	Safari Full support 7	WebView Android Full support Yes	Chrome Android Full support Yes	Firefox Android Full support 22	Opera Android Full support 14	Safari iOS Full support 8	Samsung Internet Android Full support Yes
`lowerOpen`	Chrome Full support 24 Full support 24 No support 23 — 24 Prefixed' Prefixed' Implemented with the vendor prefix: webkit	Edge Full support 12	Firefox Full support 16 Full support 16 No support 10 — 16 Prefixed' Prefixed' Implemented with the vendor prefix: moz	IE Partial support 10	Opera Full support 15	Safari Full support 7	WebView Android Full support Yes	Chrome Android Full support Yes	Firefox Android Full support 22	Opera Android Full support 14	Safari iOS Full support 8	Samsung Internet Android Full support Yes
`only`	Chrome Full support 24 Full support 24 No support 23 — 24 Prefixed' Prefixed' Implemented with the vendor prefix: webkit	Edge Full support 12	Firefox Full support 16 Full support 16 No support 10 — 16 Prefixed' Prefixed' Implemented with the vendor prefix: moz	IE Partial support 10	Opera Full support 15	Safari Full support 7	WebView Android Full support Yes	Chrome Android Full support Yes	Firefox Android Full support 22	Opera Android Full support 14	Safari iOS Full support 8	Samsung Internet Android Full support Yes
`upper`	Chrome Full support 24 Full support 24 No support 23 — 24 Prefixed' Prefixed' Implemented with the vendor prefix: webkit	Edge Full support 12	Firefox Full support 16 Full support 16 No support 10 — 16 Prefixed' Prefixed' Implemented with the vendor prefix: moz	IE Partial support 10	Opera Full support 15	Safari Full support 7	WebView Android Full support Yes	Chrome Android Full support Yes	Firefox Android Full support 22	Opera Android Full support 14	Safari iOS Full support 8	Samsung Internet Android Full support Yes
`upperBound`	Chrome Full support 24 Full support 24 No support 23 — 24 Prefixed' Prefixed' Implemented with the vendor prefix: webkit	Edge Full support 12	Firefox Full support 16 Full support 16 No support 10 — 16 Prefixed' Prefixed' Implemented with the vendor prefix: moz	IE Partial support 10	Opera Full support 15	Safari Full support 7	WebView Android Full support Yes	Chrome Android Full support Yes	Firefox Android Full support 22	Opera Android Full support 14	Safari iOS Full support 8	Samsung Internet Android Full support Yes
`upperOpen`	Chrome Full support 24 Full support 24 No support 23 — 24 Prefixed' Prefixed' Implemented with the vendor prefix: webkit	Edge Full support 12	Firefox Full support 16 Full support 16 No support 10 — 16 Prefixed' Prefixed' Implemented with the vendor prefix: moz	IE Partial support 10	Opera Full support 15	Safari Full support 7	WebView Android Full support Yes	Chrome Android Full support Yes	Firefox Android Full support 22	Opera Android Full support 14	Safari iOS Full support 8	Samsung Internet Android Full support Yes
Available in workers	Chrome Full support Yes	Edge Full support ≤18	Firefox Full support 37	IE ?	Opera Full support Yes	Safari ?	WebView Android Full support Yes	Chrome Android Full support Yes	Firefox Android Full support 37	Opera Android Full support Yes	Safari iOS ?	Samsung Internet Android Full support Yes

Legend

Full support: Full support
Partial support: Partial support
No support: No support
Compatibility unknown: Compatibility unknown
Requires a vendor prefix or different name for use.': Requires a vendor prefix or different name for use.