{"action":"created","issue":{"url":"https://api.github.com/repos/pardom/ActiveAndroid/issues/351","repository_url":"https://api.github.com/repos/pardom/ActiveAndroid","labels_url":"https://api.github.com/repos/pardom/ActiveAndroid/issues/351/labels{/name}","comments_url":"https://api.github.com/repos/pardom/ActiveAndroid/issues/351/comments","events_url":"https://api.github.com/repos/pardom/ActiveAndroid/issues/351/events","html_url":"https://github.com/pardom/ActiveAndroid/issues/351","id":63797014,"number":351,"title":"SELECT NULL values","user":{"login":"warrendeleon","id":6538899,"avatar_url":"https://avatars.githubusercontent.com/u/6538899?v=3","gravatar_id":"","url":"https://api.github.com/users/warrendeleon","html_url":"https://github.com/warrendeleon","followers_url":"https://api.github.com/users/warrendeleon/followers","following_url":"https://api.github.com/users/warrendeleon/following{/other_user}","gists_url":"https://api.github.com/users/warrendeleon/gists{/gist_id}","starred_url":"https://api.github.com/users/warrendeleon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/warrendeleon/subscriptions","organizations_url":"https://api.github.com/users/warrendeleon/orgs","repos_url":"https://api.github.com/users/warrendeleon/repos","events_url":"https://api.github.com/users/warrendeleon/events{/privacy}","received_events_url":"https://api.github.com/users/warrendeleon/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2015-03-23T18:29:17Z","updated_at":"2016-09-30T16:20:44Z","closed_at":null,"body":"Hello,\r\n\r\nI'm trying to SELECT all rows of table Measurement which column remoiteId is NULL. I'm using SQL sintax \"ISNULL\" or \"IS NULL\" but is not working. I'm using this code:\r\n\r\nList<Measurement> measurements = new Select()\r\n\t\t\t\t.from(Measurement.class)\r\n\t\t\t\t.where(\"remoteId IS NULL\")\r\n\t\t\t\t.execute();\r\n\r\n\r\nIs there any way to accomplish this goal?\r\n\r\nThank you very much.\r\n\r\nWarren de León Ofalla http://warrendeleon.com"},"comment":{"url":"https://api.github.com/repos/pardom/ActiveAndroid/issues/comments/250788109","html_url":"https://github.com/pardom/ActiveAndroid/issues/351#issuecomment-250788109","issue_url":"https://api.github.com/repos/pardom/ActiveAndroid/issues/351","id":250788109,"user":{"login":"sultanofcardio","id":14842108,"avatar_url":"https://avatars.githubusercontent.com/u/14842108?v=3","gravatar_id":"","url":"https://api.github.com/users/sultanofcardio","html_url":"https://github.com/sultanofcardio","followers_url":"https://api.github.com/users/sultanofcardio/followers","following_url":"https://api.github.com/users/sultanofcardio/following{/other_user}","gists_url":"https://api.github.com/users/sultanofcardio/gists{/gist_id}","starred_url":"https://api.github.com/users/sultanofcardio/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sultanofcardio/subscriptions","organizations_url":"https://api.github.com/users/sultanofcardio/orgs","repos_url":"https://api.github.com/users/sultanofcardio/repos","events_url":"https://api.github.com/users/sultanofcardio/events{/privacy}","received_events_url":"https://api.github.com/users/sultanofcardio/received_events","type":"User","site_admin":false},"created_at":"2016-09-30T16:20:44Z","updated_at":"2016-09-30T16:20:44Z","body":"As I'm sure you've figured out by now, your query should look something like\r\n new Select()\r\n.all()\r\n.from(Measurement.class)\r\n.where(\"remoteId IS NULL\")\r\n.execute();\r\n\r\nIssue can be closed, yeah?"}}
{"actor":{"display_login":"sultanofcardio"}}