Populate Two collection by reftype about mongoose-datatable HOT 6 OPEN

Hi,

Thank you for your feedback.

I see you are using 'options.populate' on the dataTable function but there is no populate option.
I added fields and models to the test (in test folder of this module) and the way you are building sensors field is not working with the actual implementation. If you use sub-document to do the same then it is working... I believe maybe there is a limitation in mongoose...

You can transform your model to achieve your needs:

 var sensorSchema = new mongoose.Schema({
    id: { type: String, unique: true },
    description: String,
    timeCreated: { type: Date, default: Date.now },
    timeRegistered: { type: Date, default: Date.now }
  });
 mongoose.model('Sensor', sensorSchema);

var SensorSubDocSchema = new mongoose.Schema({
      mac: { type: String, unique: true },
      alias: { type: String, default: 'SENSOR' },
      status: String,
      type: { type: mongoose.Schema.Types.ObjectId, ref: 'Sensor' }
});

var controlunitSchema = new mongoose.Schema({
    osver: String,
    sensors: [ SensorSubDocSchema ]
  });
mongoose.model('ControlUnit', sensorSchema);

/* Data fetch */
req.query.mDataProp_1 = 'types.type'
app.db.models.ControlUnit.dataTable(req.query, function (err, data) {
    if (req.xhr) {
      res.send(data);
    }
  });

Tell me if it works for you !

from mongoose-datatable.

Hi eherve,
thanks for reply. Unfortunately not work for me.
In your code: req.query.mDataProp_1 = 'types.type' i've substitute with req.query.mDataProp_1 = 'sensors.type' but with us i've only access to object type ex: id, description and two date time but: mac, alias and status not exist.
Must I declare more field??
ex:
req.query.mDataProp_1 = 'sensors.type' for get same data
req.query.mDataProp_2 = 'sensors' for get another data

Thanks in advance

from mongoose-datatable.

Ref to docs at: mongoose populate it's possible add this feature by options? ex: options.populate? Should be very great!! 👍

from mongoose-datatable.

Hi,

The module load only what you are requesting nothing more. So you need to specify each data you want to fetch.
You need to add all the field you want in your request.

Regarding populate by option, you don't need it since the request of underlying fields will trigger the populate you need.

Regards,

from mongoose-datatable.

@lags have you find a solution to your issue? I'm facing a similar problem

from mongoose-datatable.

@eherve i'm having the same problem any solutions?

from mongoose-datatable.