Nested property where clause with Sails.js 1.0 not working anymore

[ndabAP]

Sails version: 1.0.0-36
Node version: 7.9.0
NPM version: 4.2.0
Operating system: Ubuntu
Data base: MongoDB

---

I use a decorator pattern to react to user input. The user can filter data by range or bigger/smaller as. The properties are nested. After upgrading to Sails.js 1.0 this stopped working. It looks something like this:

let dataset = Data
  .find({
    table: table.id
})

// ...

if (startValue && endValue) {
  dataset
    .where({
        [`data.${columnLabel}`]: {
          '<': endValue,
          '>': startValue
        }
  })
}

// ...

This results in error:

Could not use the provided where clause. Could not filter by data.property: data.property is not a valid name for an attribute in Waterline. Even though this model (data) declares schema: false, this is not allowed.

[sailsbot]

@ndabAP Thanks for posting, we'll take a look as soon as possible.

---

For help with questions about Sails, click here. If you’re interested in hiring @sailsbot and her minions in Austin, click here.

[sgress454]

Hi @ndabAP -- it looks like you were relying on some undocumented features of Waterline that just happened to work in previous versions; namely using native Mongo query syntax within a Waterline query. In 1.0, you'll need to use the lower-level datastore functionality.

[ndabAP]

@sgress454, thank you for the clarification.

I ended up using your solution plus mquery which supports dot notation (e. g. nested.property).

[sean-clayton]

@sgress454 Is it possible to do this with Waterline on the client? I understand with .manager you can make it work on the server side, but we would like to be able to do a query like find({'nested.object': 'value'}) on the client.