javascript - IndexedDB: Query index where value "contains" - Stack Overflow

admin管理员组

文章数量:1334124

I think the answer is "you can't do it that way", but I wanted to be sure. Let's say I have an object:

var person = {
    name: 'Joe',
    phoneNumbers: [ '5555554455', '4445554455' ]
};

I want to create an index on phoneNumbers:

objectStore.createIndex('phoneNumberIndex', 'phoneNumbers');

Later I want to query for persons with a particular phoneNumber:

index.get('4445554455').onsuccess = function(event) {
    // Anything?
};

Will that produce a result? If not, is there another way to do this?

I think the answer is "you can't do it that way", but I wanted to be sure. Let's say I have an object:

var person = {
    name: 'Joe',
    phoneNumbers: [ '5555554455', '4445554455' ]
};

I want to create an index on phoneNumbers:

objectStore.createIndex('phoneNumberIndex', 'phoneNumbers');

Later I want to query for persons with a particular phoneNumber:

index.get('4445554455').onsuccess = function(event) {
    // Anything?
};

Will that produce a result? If not, is there another way to do this?

• javascript
• indexeddb

Share Improve this question Follow asked Jan 18, 2012 at 18:51 MatthewMatthew 11.6k99 gold badges4040 silver badges4545 bronze badges

Add a ment  | 

2 Answers 2

Sorted by: Reset to default 5

Something like this should work:

objectStore.createIndex("phoneNumberIndex", "phoneNumber", { multiEntry: true });
objectStore.index("phoneNumberIndex").get("4445554455").onsuccess = function(e) {
  console.log(JSON.stringify(e.target.result));
}

I think you can use the {multientry: true} parameter of createIndex for that.

本文标签： javascriptIndexedDB Query index where value quotcontainsquotStack Overflow