{"action":"created","issue":{"url":"https://api.github.com/repos/strongloop/loopback/issues/1009","repository_url":"https://api.github.com/repos/strongloop/loopback","labels_url":"https://api.github.com/repos/strongloop/loopback/issues/1009/labels{/name}","comments_url":"https://api.github.com/repos/strongloop/loopback/issues/1009/comments","events_url":"https://api.github.com/repos/strongloop/loopback/issues/1009/events","html_url":"https://github.com/strongloop/loopback/issues/1009","id":54354400,"number":1009,"title":"isSet query operator","user":{"login":"ritch","id":462228,"avatar_url":"https://avatars.githubusercontent.com/u/462228?v=3","gravatar_id":"","url":"https://api.github.com/users/ritch","html_url":"https://github.com/ritch","followers_url":"https://api.github.com/users/ritch/followers","following_url":"https://api.github.com/users/ritch/following{/other_user}","gists_url":"https://api.github.com/users/ritch/gists{/gist_id}","starred_url":"https://api.github.com/users/ritch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ritch/subscriptions","organizations_url":"https://api.github.com/users/ritch/orgs","repos_url":"https://api.github.com/users/ritch/repos","events_url":"https://api.github.com/users/ritch/events{/privacy}","received_events_url":"https://api.github.com/users/ritch/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/strongloop/loopback/labels/feature","name":"feature","color":"bfe5bf"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":27,"created_at":"2015-01-14T17:59:16Z","updated_at":"2016-10-03T18:37:04Z","closed_at":null,"body":"We should add support for something like this:\r\n\r\n```js\r\n{\r\n  where: {\r\n    someField: {\r\n      isSet: false\r\n    }\r\n  }\r\n}\r\n```\r\n\r\nThis would allow you to query for undefined fields using `$isset` in mongodb and `NULL` in SQL databases. "},"comment":{"url":"https://api.github.com/repos/strongloop/loopback/issues/comments/251188265","html_url":"https://github.com/strongloop/loopback/issues/1009#issuecomment-251188265","issue_url":"https://api.github.com/repos/strongloop/loopback/issues/1009","id":251188265,"user":{"login":"sundeepgupta","id":2365037,"avatar_url":"https://avatars.githubusercontent.com/u/2365037?v=3","gravatar_id":"","url":"https://api.github.com/users/sundeepgupta","html_url":"https://github.com/sundeepgupta","followers_url":"https://api.github.com/users/sundeepgupta/followers","following_url":"https://api.github.com/users/sundeepgupta/following{/other_user}","gists_url":"https://api.github.com/users/sundeepgupta/gists{/gist_id}","starred_url":"https://api.github.com/users/sundeepgupta/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sundeepgupta/subscriptions","organizations_url":"https://api.github.com/users/sundeepgupta/orgs","repos_url":"https://api.github.com/users/sundeepgupta/repos","events_url":"https://api.github.com/users/sundeepgupta/events{/privacy}","received_events_url":"https://api.github.com/users/sundeepgupta/received_events","type":"User","site_admin":false},"created_at":"2016-10-03T18:37:04Z","updated_at":"2016-10-03T18:37:04Z","body":"I'm finding that the `nlike` operator is working as a workaround in my particular case, which is for a MongoDB connector and `string` type property.\r\n\r\n`Account.find({where: {analyticsId: {nlike: ''}}})`"}}
{"actor":{"display_login":"sundeepgupta"}}