GMishx commented on issue #5756:
URL: https://github.com/apache/couchdb/issues/5756#issuecomment-3562437898

   Thank you for the quick response @willholley !
   
   Adding the fields to the selector worked. However, according to the docs, 
what I understood is the fields should be selected => Thus I added them in the 
`fields`. That I guess caused the issue.
   
   About the helpful suggestion to use the views, it makes sense but I would 
loose the ability to use sorting. I would have to create 3 different views 
sorted by 3 fields then.
   
   ====
   
   With the provided index, I can only sort by `fullname` as it is the second 
field in the order. If I sort by `shortname` and replace the 
`"shortname":{"$exists":true}` with `"fullname":{"$exists":true}` (or without), 
CouchDB does not use the index anymore.
   
   I guess using 3 different views, one sorted by `shortname`, one by 
`fullname` and one by `url`.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to