You can’t do this in a single query because MongoDB doesn’t support joins. Instead, you have to break it into a couple steps: // Get the _ids of people with the last name of Robertson. Person.find({lastname: ‘Robertson’}, {_id: 1}, function(err, docs) { // Map the docs into an array of just the _ids var ids … Read more
Or you can use the built-in Blue Bird Promise feature to make it. (Working on Sails@v0.10.5) See the codes below: var _ = require(‘lodash’); … Post .findOne(req.param(‘id’)) .populate(‘user’) .populate(‘comments’) .then(function(post) { var commentUsers = User.find({ id: _.pluck(post.comments, ‘user’) //_.pluck: Retrieves the value of a ‘user’ property from all elements in the post.comments collection. }) .then(function(commentUsers) … Read more
if you’re in a situation like me where procedures are prohibited, and your sql user does not have permissions for insert, therefore insert not allowed, but you want to generate a list of dates in a specific period, say current year to do some aggregation, use this select * from (select adddate(‘1970-01-01’,t4*10000 + t3*1000 + … Read more