SailsJS relations not working as expected

Question

SailsJS with MongoDB adapter not working as expected. I have following relations defined:

Post.js:

module.exports = {
  connection: 'mongodb',

  attributes: {
    title: 'string',
    categories: {
      collection: 'postCategory',
      via: 'posts'
    }
  }
};

PostCategory.js

module.exports = {
  connection: 'mongodb',

  attributes: {
    name: 'string',
    posts: {
      collection: 'post',
      via: 'categories'
    }
  }
};

When I query without criteria and populate categories like:

Post.find()
       .populate('categories')
       .then(...)

it gives me correct result, the document has categories nested.

But when I try to pass criteria it returns no result. e.g.

Post.find({categories: 'food'})
       .populate('categories')
       .then(...)

Note: I inserted category _id as string (food, travel, etc) in database

Please help

See [this answer](http://stackoverflow.com/questions/22940626/sails-js-query-on-a-associated-value) — Alexis N-o, Aug 04 '15 at 12:48

score 1 · Answer 1 · answered Aug 04 '15 at 06:50

1

You will not get any results because in categories it will store the _id.

You can get the results by doing the following query.

PostCategory.find({name: 'food'})
       .populate('posts')
       .then(...)

answered Aug 04 '15 at 06:50

Vishnu

11,614
6
51
90

As I said before `_id` is the string `food`, but not getting records – mahadazad Aug 04 '15 at 11:05
@mahadazad can you add the records from the mongodb to the question. – Vishnu Aug 04 '15 at 11:17

SailsJS relations not working as expected

Post.js:

PostCategory.js

1 Answers1