{"action":"created","issue":{"url":"https://api.github.com/repos/fhirbase/fhirbase/issues/104","labels_url":"https://api.github.com/repos/fhirbase/fhirbase/issues/104/labels{/name}","comments_url":"https://api.github.com/repos/fhirbase/fhirbase/issues/104/comments","events_url":"https://api.github.com/repos/fhirbase/fhirbase/issues/104/events","html_url":"https://github.com/fhirbase/fhirbase/issues/104","id":68908622,"number":104,"title":"Search by date using \"not equals\" comparator returns empty results","user":{"login":"grzegorz-borczuch","id":10882650,"avatar_url":"https://avatars.githubusercontent.com/u/10882650?v=3","gravatar_id":"","url":"https://api.github.com/users/grzegorz-borczuch","html_url":"https://github.com/grzegorz-borczuch","followers_url":"https://api.github.com/users/grzegorz-borczuch/followers","following_url":"https://api.github.com/users/grzegorz-borczuch/following{/other_user}","gists_url":"https://api.github.com/users/grzegorz-borczuch/gists{/gist_id}","starred_url":"https://api.github.com/users/grzegorz-borczuch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/grzegorz-borczuch/subscriptions","organizations_url":"https://api.github.com/users/grzegorz-borczuch/orgs","repos_url":"https://api.github.com/users/grzegorz-borczuch/repos","events_url":"https://api.github.com/users/grzegorz-borczuch/events{/privacy}","received_events_url":"https://api.github.com/users/grzegorz-borczuch/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/fhirbase/fhirbase/milestones/5","html_url":"https://github.com/fhirbase/fhirbase/milestones/2015-may","labels_url":"https://api.github.com/repos/fhirbase/fhirbase/milestones/5/labels","id":1075734,"number":5,"title":"2015-may","description":"","creator":{"login":"niquola","id":32066,"avatar_url":"https://avatars.githubusercontent.com/u/32066?v=3","gravatar_id":"","url":"https://api.github.com/users/niquola","html_url":"https://github.com/niquola","followers_url":"https://api.github.com/users/niquola/followers","following_url":"https://api.github.com/users/niquola/following{/other_user}","gists_url":"https://api.github.com/users/niquola/gists{/gist_id}","starred_url":"https://api.github.com/users/niquola/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/niquola/subscriptions","organizations_url":"https://api.github.com/users/niquola/orgs","repos_url":"https://api.github.com/users/niquola/repos","events_url":"https://api.github.com/users/niquola/events{/privacy}","received_events_url":"https://api.github.com/users/niquola/received_events","type":"User","site_admin":false},"open_issues":3,"closed_issues":8,"state":"open","created_at":"2015-04-20T17:56:07Z","updated_at":"2015-10-30T17:17:34Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2015-04-16T11:59:33Z","updated_at":"2015-10-30T17:17:34Z","closed_at":"2015-10-30T17:17:34Z","body":"It's a duplicate of https://github.com/fhirbase/fhirbase/issues/93\r\n\r\nAfter the commit done by @niquola, I've tested this again and this is the result:\r\n\r\nUsing =!= comparator in FhirBase always returns empty results.\r\nLooks like this comparator is not recognised, because in SQL that get's generated it's comparing dates to NULL. See SQL code generated below:\r\n\r\n```\r\nSELECT patient.version_id, patient.logical_id, patient.resource_type, patient.updated, patient.published, patient.category, patient.content FROM patient\r\n\r\nWHERE (not  (fhirbase_date_idx.index_as_date(content, '{birthDate}'::text[], 'date'::text) && NULL))\r\nLIMIT 100\r\nOFFSET 0\r\n```"},"comment":{"url":"https://api.github.com/repos/fhirbase/fhirbase/issues/comments/152591730","html_url":"https://github.com/fhirbase/fhirbase/issues/104#issuecomment-152591730","issue_url":"https://api.github.com/repos/fhirbase/fhirbase/issues/104","id":152591730,"user":{"login":"niquola","id":32066,"avatar_url":"https://avatars.githubusercontent.com/u/32066?v=3","gravatar_id":"","url":"https://api.github.com/users/niquola","html_url":"https://github.com/niquola","followers_url":"https://api.github.com/users/niquola/followers","following_url":"https://api.github.com/users/niquola/following{/other_user}","gists_url":"https://api.github.com/users/niquola/gists{/gist_id}","starred_url":"https://api.github.com/users/niquola/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/niquola/subscriptions","organizations_url":"https://api.github.com/users/niquola/orgs","repos_url":"https://api.github.com/users/niquola/repos","events_url":"https://api.github.com/users/niquola/events{/privacy}","received_events_url":"https://api.github.com/users/niquola/received_events","type":"User","site_admin":false},"created_at":"2015-10-30T17:17:34Z","updated_at":"2015-10-30T17:17:34Z","body":"Moved to https://github.com/fhirbase/fhirbase-plv8/issues/27"}}