--- title: IDBKeyRange slug: Web/API/IDBKeyRange tags: - API - Database - IDBKeyRange - IndexedDB - Interface - NeedsTranslation - Reference - Storage - TopicStub translation_of: Web/API/IDBKeyRange ---
{{APIRef("IndexedDB")}}
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 {{domxref("IDBObjectStore")}} and {{domxref("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 | {{domxref("IDBKeyRange.upperBound")}}(x) |
All keys < x | {{domxref("IDBKeyRange.upperBound")}}(x, true) |
All keys ≥ y | {{domxref("IDBKeyRange.lowerBound")}}(y) |
All keys > y | {{domxref("IDBKeyRange.lowerBound")}}(y, true) |
All keys ≥ x && ≤ y | {{domxref("IDBKeyRange.bound")}}(x, y) |
All keys > x &&< y | {{domxref("IDBKeyRange.bound")}}(x, y, true, true) |
All keys > x && ≤ y | {{domxref("IDBKeyRange.bound")}}(x, y, true, false) |
All keys ≥ x &&< y | {{domxref("IDBKeyRange.bound")}}(x, y, false, true) |
The key = z | {{domxref("IDBKeyRange.only")}}(z) |
A key is in a key range if the following conditions are true:
undefined
lowerOpen
is false
.undefined
upperOpen
is false
.{{AvailableInWorkers}}
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 {{domxref("IDBTransaction")}}) and an object store, and open a Cursor with {{domxref("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 (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.'); } }; }
Specification | Status | Comment |
---|---|---|
{{SpecName('IndexedDB', '#idl-def-IDBKeyRange', 'IDBKeyRange')}} | {{Spec2('IndexedDB')}} | Initial definition. |
{{SpecName('IndexedDB 2', '#keyrange', 'IDBKeyRange')}} | {{Spec2('IndexedDB 2')}} | Adds includes() . |
{{Compat("api.IDBKeyRange")}}