Loopback: Filters that allows for comparison of model properties

Created on 14 Jul 2016 · 6Comments · Source: strongloop/loopback

Using loopback where filter would be a lot more versatile if you could do queries that relate the model's instance properties to one another:

{
  where: {
    modelId: id,
    someProp: {
      neq: {
        property: someOtherProp
      }
    }
  }
}

The neq I'm referencing denotes 'not equal' .. eg. someProp != someOtherProp.

Right now, If i want to compare 2 properties I need to go to SQL and do a manual query there. Can this be a feature for future release?

Source

sidewaiise

Most helpful comment

Ok @gunjpan I think my point wasn't conveyed very well. Yes I'm aware there is a neq operator already available.

The important part is the property: someOtherProp part - where someOtherProp is actually another property name within the model. It would be similar to doing an SQL query like:

SELECT * FROM myTable WHERE column_A != column_B;

Does that make sense?

-> if using the above as a reference it would be: SELECT * FROM myTable WHERE someProp != someOtherProp;

sidewaiise on 16 Jul 2016

👍4

All 6 comments

@sidewaiise see this sections Operators. There is neq operator for your use case.

mrbatista on 14 Jul 2016

@mrbatista thanks for chiming in.
@sidewaiise: Did above suggestion help you? The where filter supports _almost_ all comparison operators.
Closing this now. Should you need further assistance with it, please mention me in the comments and I'll be happy to help. Thank you and have a great weekend :smiley_cat:

gunjpan on 15 Jul 2016

Ok @gunjpan I think my point wasn't conveyed very well. Yes I'm aware there is a neq operator already available.

The important part is the property: someOtherProp part - where someOtherProp is actually another property name within the model. It would be similar to doing an SQL query like:

SELECT * FROM myTable WHERE column_A != column_B;

Does that make sense?

-> if using the above as a reference it would be: SELECT * FROM myTable WHERE someProp != someOtherProp;

sidewaiise on 16 Jul 2016

👍4

@gunjpan Any update of this?

MarcBanc on 1 Mar 2017

it seem so far this issue persists. only mongodb connector has some thing like this with allowExtendedOperators: true setting so your can add $where "this.xxx != this.yyy"