IndexedDB composite index partial match

Question

I can't find an answer to this anywhere.

I have an indexeddb composite index of a group id and a time, which I use to sort.

let tmp_CREATEDTIMEindex = texts.index('GROUP_ID, CREATEDTIME');

This works great, except I need to result to reflect only the group id, not the time. How do I get a result from a match on just the group id?

To clarify, this returns one record: let request = tmp_CREATEDTIMEindex.getAll(['someid', 'August, 25 2022 06:52:02']);

I need it to return all records. let request = tmp_CREATEDTIMEindex.getAll(['someid', '*']);

Joshua Bell · Accepted Answer · 2022-08-25 17:03:25Z

1

You can use a key range:

let range = IDBKeyRange.bound(['someid'], ['someid\x00'], true, true);
let request = tmp_CREATEDTIMEindex.getAll(range);

answered Aug 25, 2022 at 17:03

Joshua Bell

8,48531 silver badges34 bronze badges

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

1 Comment

Joshua Bell genius, many thanks! Works perfectly!