apache / apache/pouchdb

Error: Cannot sort on field(s) "XXX" when using the default index

Open
#8,963 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

### Issue
```Error: Cannot sort on field(s) "XXX" when using the default index```

### Info
- Environment: Node.js
- Platform: -
- Adapter: memory
- Server: local

Hey, I am having trouble using created index for some unknown reason :) Grateful for any advice. When I add the `ddoc` prop and `use_index` and get the following error: `'There is no index available for this selector.'`
``` ts
await db
.createIndex({
index: {
fields: ["reservedModelType", "recordDate"],
partial_filter_selector: {
reservedModelType: DocModelType.RECORD,
},
},
})
.then(async () =>
db
.find({
selector: {
reservedModelType: DocModelType.RECORD,
recordDate: { $gt: null },
},
sort: [{ recordDate: "desc" }],
})
.catch((error) => console.error("Error fetching records", error)),
)
.catch((error) => console.error("Error creating index:", error))
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.