Cosmos DB: MongoDB sort query returning blank resultset

Question

I am using Mongoose.js 4.11.6 Node.js 6.0.

I have a user document which looks like bellow -

var UserSchema = new Schema({
  name: { type: String, default: '' },
  email: { type: String, default: '' },
  phone: { type: String, default: '' },
  hashed_password: { type: String, default: '' },
  role: { type: String, default: '' },
  created_at: { type: Date, default: Date.now }
});

I am running following mongoose query -

UserSchema.find({ role: options.role }) .select(options.select) .sort({ 'email': -1 }) .exec(cb);

Ideally this should return the list matching user sorted by email id. The query works exactly what it is expected to do in our AWS deployment. But in the Cosmos DB MongoDB hosting it is returning the empty resultset. But the query return results (but not in desired order) when the .sort({ 'email': -1 }) is removed.

Have you opted into proper range indexing for the email? You can't do sorts on strings without setting the precision appropriately — Jesse Carter
– Jesse Carter, Commented Aug 9, 2017 at 16:13

Marc Gagne · Accepted Answer · 2017-08-09 17:17:29Z

1

as discussed in a separate thread this does indeed work. Below is the complete sample code showing sorting working as expected with CosmosDB & the Mongo API via Mongoose.

https://gist.github.com/m-gagne/00893a32a0e4c7f593a1676ba1380e63

var mongoose = require('mongoose');

mongoose.connect('<COSMOS DB CONNECTION STRING>');

var Schema = mongoose.Schema;

var userSchema = new Schema({
  email: { type: String, default: '' },
});

var User = mongoose.model('User', userSchema, "users");

User.find({}).select(['email']).sort({ 'email': -1 }).exec(function(err, results) {
  if(err) {
    console.log("!!! ERROR !!!");
    console.log(err);
    return;
  }
  console.log(results);
});

edited Aug 9, 2017 at 17:17

answered Aug 9, 2017 at 15:19

Marc Gagne

8195 silver badges7 bronze badges

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

Comments

Wolf · Accepted Answer · 2017-12-29 04:10:43Z

0

i'm using Cosmos Db document, has same issue with string field. Problem is when I create collection, policyIndex default was

{
                    "kind": "Hash",
                    "dataType": "String",
                    "precision": 3
                }

Hash Type is not good for order, change it to Range and working well

{
                    "kind": "Range",
                    "dataType": "String",
                    "precision": -1
                },

answered Dec 29, 2017 at 4:10

Wolf

6,5372 gold badges32 silver badges28 bronze badges

Collectives™ on Stack Overflow

Cosmos DB: MongoDB sort query returning blank resultset

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related