Use Populate method with datatables in Node js + Mongo DB

Question

I am working with this code link. Datatable is created but how can i use populate method with query. As according to provide code:

exports.getDataForDataTable = function getData (request, response)
{
  MyModel.dataTable(request.query, function (err, data) {
    response.send(data);
  });
};

possible duplicate http://stackoverflow.com/questions/17598712/how-should-i-properly-use-populate-with-mongoose — Asif Saeed, Mar 07 '17 at 11:35
I am using datatable so i need syntax with datatable. Populate normally works but how it works with datatable syntax. — Anshul, Mar 07 '17 at 11:45

score 1 · Accepted Answer · answered Mar 07 '17 at 11:59

1

Add populate field in the request.query object

exports.getDataForDataTable = function getData (request, response)
{
   request.query.populate = 'Model';
   MyModel.dataTable(request.query, function (err, data) {
   response.send(data);
});
};

answered Mar 07 '17 at 11:59

Asif Saeed

1,985
14
24

After apply this search is not working for other columns, it is only work on first column. – Anshul Mar 07 '17 at 12:47
Fields must be defined in the search object fields: ['username'] in which you want to search. Can you conosle.log you request.query object and paste it here so i can see what is wrong. – Asif Saeed Mar 07 '17 at 13:15
conditions: { '$and': [ { '$or': [ { title: { '$in': [ /2/i ] } } ] } ] }, This condition is generated only – Anshul Mar 07 '17 at 13:37
It must consists of other columns also. – Anshul Mar 07 '17 at 13:38
search: { value: '', regex: 'false' }, this is coming when i console query object for search. – Anshul Mar 08 '17 at 09:10
@Anshul hey did you get any solution about search with populate ? – sagar patel Apr 13 '18 at 05:05

Use Populate method with datatables in Node js + Mongo DB

1 Answers1