apache / apache/pouchdb

Impossible to find with index

Open
#8,877 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
17.6k
Forks
1.5k
PR merge metrics
No merged PRs in 30d

Description

Hello,
I build a simple collection with several fields like "site" (string), "zone" (string), class" (string), "timeStamp" (int), "count" (int).
I have build indexes with all combinations of fields : site, site+zone, size+class....until site+zone+class+timeStamp
Depending of my search criteria (for exemple on site and timestamp), I call **.find** method with the corresponding index (i.e. site+timeStamp).
So I use it with "use_index" option : name_of_index.
Error is always : _"pouchdb Could not find that index or could not use that index for the query"_
Any idea ?
Best regards.

Contributor guide

Open the contributing guide

Research direction

Start with the reported .find call and its use_index option, comparing the requested site+timeStamp index with the actual index definition. Confirm whether the query can use that index and capture the exact index and query details needed to reproduce the error; done when the query succeeds or the unsupported combination is explained.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.