Error: Cannot sort on field(s) "XXX" when using the default index
- 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
Assessment
This issue has not been assessed yet.