Select from IndexedDB database, using multiple indexes

Question

Each of my IndexedDB objects have the following format:

object:
{
     objectName: "someName"
     objectTest: "someTest"
     objectAge: "someAge"
}

Then I have the following indexes already set:

storeObject.createIndex( "by_objectName", "objectName", { unique: false } );
storeObject.createIndex( "by_objectTest", "objectTest", { unique: false } );
storeObject.createIndex( "by_objectAge", "objectAge", { unique: false } );

So first I wanted to loop through all my objects by objectName (this is working):

var openedIndex = storeObject.index("by_objectName");
var numItemsInIndex = openedIndex.count();
if (openedIndex) {
    var curCursor = openedIndex.openCursor();               
    curCursor.onsuccess = function(evt) {                   
        var cursor = evt.target.result; 
        if (cursor) {
                //do something
                cursor.continue();
        }
    }
}

So the above code is taking all the objects and they are sorted by objectName. How can I take all the objects that have objectTest: "certainValue" and the sorting by objectName to remain the same as in the above example. I need to filter the list of result before the line if (openedIndex) { because I need to use the numItemsInIndex later in the loop.

So in other words, if this was relational database, how to implement:

SELECT * FROM objects WHERE objectTest = "certainValue" SORT BY objectName

possible duplicate of In IndexedDB, is there a way to make a sorted compound query? — Josh
– Josh, Commented May 24, 2014 at 22:18

Community · Accepted Answer · 2017-05-23 12:17:01Z

1

You can create an index on two properties at once by defining the keyPath parameter to createIndex as an array. Use the property you wish to sort by as the first item in the array. For example, see my other posts, like this one: In IndexedDB, is there a way to make a sorted compound query?

edited May 23, 2017 at 12:17

CommunityBot

11 silver badge

answered Mar 10, 2014 at 20:13

Josh

18.9k7 gold badges55 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Select from IndexedDB database, using multiple indexes

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related