MongoDB.prototype.buildWhere doesn't $ nested specs about loopback-connector-mongodb

[srguiwiz]

pull request #110 has been opened

[fedebalderas]

Hi @srguiwiz any idea about why this query doesn't work?

I'm trying to do a query over a property which is a Date type using elemMatch. Take a look please (I've changed a little my model for this example).

My model

This query works fine:

But this doesn't work:

Or this:

Any idea?

[ssh24]

You can use nested specs on the query itself without having to use mongoDB syntaxes.

Here is an sample code snippet:

model-definition.js

{
  "name": "Bank",
  "base": "PersistedModel",
  "idInjection": true,
  "options": {
    "validateUpsert": true
  },
  "properties": {
    "id": {
      "type": "string",
      "required": true,
      "id": true
    },
    "name": {
      "type": "string"
    },
    "opens": {
      "type": "object"
    },
    "closes": {
      "type": "object"
    }
  },
  "validations": [],
  "relations": {},
  "acls": [],
  "methods": {}
}

boot-script.js

'use strict';
var util = require('util');

module.exports = function(app) {
  var db = app.dataSources.mongoDs;
  var Bank = app.models.Bank;

  var data = [{
    id: '1',
    name: 'TD',
    opens: {
      monday: '7:00am',
      tuesday: '7:00am',
      wednesday: '7:00am',
    },
    closes: {
      monday: '7:00pm',
      tuesday: '7:00pm',
      wednesday: '7:00pm',
    },
  }, {
    id: '2',
    name: 'BMO',
    opens: {
      monday: '9:00am',
      tuesday: '7:00am',
      wednesday: '10:00am',
    },
    closes: {
      monday: '5:00pm',
      tuesday: '7:00pm',
      wednesday: '8:00pm',
    },
  }];

  db.automigrate(function(err) {
    if (err) throw err;
    console.log('\nAutomigrate complete');

    Bank.create(data, function(err, result) {
      if (err) throw err;
      console.log('\nCreated instance: ' + util.inspect(result, 4));

      Bank.find({where: {'opens.monday': '9:00am'}},
      function(err, result) {
        if (err) throw err;
        console.log('\nFind instance: ' + util.inspect(result, 4));
      });
    });
  });
};

The above query results in all the banks that opens on monday at 9:00am.

Hopefully, this solves the issue. Closing this as a result. Feel free to reopen if needed.