Distinct in sails js and mongodb

Question

Model.distinct("Age").done(function(err, ward) {
  if(err)
    return next(err);
  if(!ward)
    return next();
  res.json(ward);
});

After executing this code, it gives the following error:

TypeError: Object [object Object] has no method 'distinct'

But distinct works in robomongo. How can I rectify the error?

score 3 · Accepted Answer · edited Jan 25 '18 at 08:08

3

Currently Walterline (the ORM of sails) dont support distinct()-function.

But you can use the native()-function to get direct access to the native mongo driver:

Modelname.native(function(err,coll){
  coll.distinct("Age", function(err,result){
     res.json(result);
  });
});

edited Jan 25 '18 at 08:08

Shahriar

answered Jun 13 '14 at 08:59

mdunisch

score 0 · Answer 2 · answered Jun 13 '14 at 08:50

What you probably need is the ability for the SailsJS ORM (Waterlin) to give you back the native MongoDB collection: http://beta.sailsjs.org/#/documentation/reference/Models/Model-Methods/native.html

Once you've got it you will be able to call native MongoDB queries.

By design, Waterline is meant to be used with several databases while keeping the same code. And currently there is no "disctinct" feature.

2 Answers2