neq[Not equal (!=)] is not working properly

[Surender246]

Hi all,

I want to get the data whose "completeflag" is not equal to null.For this am using the following query.

"/api/v1/orderdetails?filter[where][completeflag][neq]=null" but i got following response

which i noticed is that the response data is for whose "completeflag" is null, But i want only the data whose completeflag is not null, please help me to achieve this(Am using Postgresql).

Thanks in Advance.

[bajtos]

Hi @Surender246, how did you arrive to the URL "/api/v1/orderdetails?filter[where][completeflag][neq]=null" from an AngularJS client? Can you provide a code snippet please?

[Surender246]

Actual URL with access token "http://converbiz-ul-api.herokuapp.com/api/v1/orderdetails?filter[where][completeflag][neq]=null&access_token=Xe81zQBCHRugqREHE5cNOVxj7iF05PcAZinGWAFwSXHyrYv4K85erT13W06lqiAQ" and trying using Postman.

[bajtos]

In that case it's not a bug in the AngularJS SDK, but in loopback, strong-remoting and/or a database connector.

I tried a different way of encoding the query string and it did not help either: http://converbiz-ul-api.herokuapp.com/api/v1/orderdetails?filter={%22where%22:{%22completeflag%22:{%22neq%22:null}}}&access_token=Xe81zQBCHRugqREHE5cNOVxj7iF05PcAZinGWAFwSXHyrYv4K85erT13W06lqiAQ

What connector are you using? I remember a similar bug was fixed in one of the connectors recently. Please upgrade the connector to the latest version from npmjs.org and try again.

[bajtos]

As part of our issue triage process, we are closing items that have been inactive for an extended period of time. Feel free to reopen this issue if you can provide any new information to help us with resolving the issue.

[soyacz]

I'm hitting the same issue when using neq in where filter used in model scope:

  "scope": {
    "where": {
      "and": [{
        "publishDate": {
          "neq": null
        }
      }, {
        "archiveDate": {
          "neq": null
        }
      }]
    }
  },

When debuging, I see the query:
SELECT "id", "title", "categoryId", "kindId", "shortDesc", "fullDesc", "picture", "city", "address", "postcode", "organizationId", "publishDate", "archiveDate" FROM "Article" WHERE ("organizationId" = 1) AND (("publishDate" IS NULL) AND ("archiveDate" IS NULL)) ORDER BY "id"

it should be "IS NOT NULL" for publisDate and archiveDate filter!

[jac1013]

This problem is still happening today, I think with @soyacz explanation it should be possible to get a fix for it.

[bajtos]

Fair enough, I am reopening the issue.

Please check what is the filter argument send in the query string to the server. Does it correctly contain neq operators? Can you reproduce this issue without AngularJS SDK, just by running a similar "neq" query either via API Explorer or by invoking MyModel.find from JavaScript at server side?

I suspect this will be a bug in the server part of LoopBack, not in the AngularJS SDK.

[bajtos]

I am closing this issue as abandoned. Please open a new one if the problem still persist and you can provide answers to the questions asked in my comment above.