{"action":"created","issue":{"url":"https://api.github.com/repos/dimagi/commcare-hq/issues/5691","labels_url":"https://api.github.com/repos/dimagi/commcare-hq/issues/5691/labels{/name}","comments_url":"https://api.github.com/repos/dimagi/commcare-hq/issues/5691/comments","events_url":"https://api.github.com/repos/dimagi/commcare-hq/issues/5691/events","html_url":"https://github.com/dimagi/commcare-hq/pull/5691","id":59049978,"number":5691,"title":"Fix bug in UCR dynamic choice list filter","user":{"login":"NoahCarnahan","id":2117127,"avatar_url":"https://avatars.githubusercontent.com/u/2117127?v=3","gravatar_id":"","url":"https://api.github.com/users/NoahCarnahan","html_url":"https://github.com/NoahCarnahan","followers_url":"https://api.github.com/users/NoahCarnahan/followers","following_url":"https://api.github.com/users/NoahCarnahan/following{/other_user}","gists_url":"https://api.github.com/users/NoahCarnahan/gists{/gist_id}","starred_url":"https://api.github.com/users/NoahCarnahan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/NoahCarnahan/subscriptions","organizations_url":"https://api.github.com/users/NoahCarnahan/orgs","repos_url":"https://api.github.com/users/NoahCarnahan/repos","events_url":"https://api.github.com/users/NoahCarnahan/events{/privacy}","received_events_url":"https://api.github.com/users/NoahCarnahan/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/dimagi/commcare-hq/labels/No%20lint%20errors","name":"No lint errors","color":"bfe5bf"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-02-26T10:15:53Z","updated_at":"2015-02-26T13:09:59Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/dimagi/commcare-hq/pulls/5691","html_url":"https://github.com/dimagi/commcare-hq/pull/5691","diff_url":"https://github.com/dimagi/commcare-hq/pull/5691.diff","patch_url":"https://github.com/dimagi/commcare-hq/pull/5691.patch"},"body":"Postgres column labels in sql `WHERE` clauses were not being quoted. This caused errors to occur with filters that referenced data source columns that were also reserved postgres words, like `user` for example. The filter would fail silently because the query produced was syntactically valid but did not select the expected rows.\r\nResolves this ticket: http://manage.dimagi.com/default.asp?158629"},"comment":{"url":"https://api.github.com/repos/dimagi/commcare-hq/issues/comments/76175145","html_url":"https://github.com/dimagi/commcare-hq/pull/5691#issuecomment-76175145","issue_url":"https://api.github.com/repos/dimagi/commcare-hq/issues/5691","id":76175145,"user":{"login":"snopoke","id":249606,"avatar_url":"https://avatars.githubusercontent.com/u/249606?v=3","gravatar_id":"","url":"https://api.github.com/users/snopoke","html_url":"https://github.com/snopoke","followers_url":"https://api.github.com/users/snopoke/followers","following_url":"https://api.github.com/users/snopoke/following{/other_user}","gists_url":"https://api.github.com/users/snopoke/gists{/gist_id}","starred_url":"https://api.github.com/users/snopoke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/snopoke/subscriptions","organizations_url":"https://api.github.com/users/snopoke/orgs","repos_url":"https://api.github.com/users/snopoke/repos","events_url":"https://api.github.com/users/snopoke/events{/privacy}","received_events_url":"https://api.github.com/users/snopoke/received_events","type":"User","site_admin":false},"created_at":"2015-02-26T13:09:59Z","updated_at":"2015-02-26T13:09:59Z","body":"Seems like the other filters would suffer from the same issue and could do with similar treatment."}}