{"action":"created","issue":{"url":"https://api.github.com/repos/metabase/metabase/issues/9109","repository_url":"https://api.github.com/repos/metabase/metabase","labels_url":"https://api.github.com/repos/metabase/metabase/issues/9109/labels{/name}","comments_url":"https://api.github.com/repos/metabase/metabase/issues/9109/comments","events_url":"https://api.github.com/repos/metabase/metabase/issues/9109/events","html_url":"https://github.com/metabase/metabase/issues/9109","id":389749267,"node_id":"MDU6SXNzdWUzODk3NDkyNjc=","number":9109,"title":"SQL Parameters - I have PSQLException when I try to use field filter","user":{"login":"dyesseyumba","id":5528931,"node_id":"MDQ6VXNlcjU1Mjg5MzE=","avatar_url":"https://avatars3.githubusercontent.com/u/5528931?v=4","gravatar_id":"","url":"https://api.github.com/users/dyesseyumba","html_url":"https://github.com/dyesseyumba","followers_url":"https://api.github.com/users/dyesseyumba/followers","following_url":"https://api.github.com/users/dyesseyumba/following{/other_user}","gists_url":"https://api.github.com/users/dyesseyumba/gists{/gist_id}","starred_url":"https://api.github.com/users/dyesseyumba/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dyesseyumba/subscriptions","organizations_url":"https://api.github.com/users/dyesseyumba/orgs","repos_url":"https://api.github.com/users/dyesseyumba/repos","events_url":"https://api.github.com/users/dyesseyumba/events{/privacy}","received_events_url":"https://api.github.com/users/dyesseyumba/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2018-12-11T12:50:04Z","updated_at":"2018-12-28T02:13:49Z","closed_at":null,"author_association":"NONE","body":"### Bugs\r\nI am trying to write a SQL question using a field parameter but each time I try I get this exception:\r\n`org.postgresql.util.PSQLException: ERROR: syntax error at or near \"\"public\"\" Position: 184`\r\nThe number of position change regarding the content of the query.\r\nHere is the query that returns this exception.\r\n\r\n![image](https://user-images.githubusercontent.com/5528931/49801376-4a414980-fd4a-11e8-8929-5b12d17bfc91.png)\r\n\r\nCan help me with this issue?\r\n\r\nHere is my sytème configuration:\r\n- Database: PostgreSQL 9.6.6\r\n- OS: RHEL\r\n- Browser: Chrome 70\r\n- Metabase version: 0.31.2\r\n- Metabase hosting environment: AWS\r\n- Metabase internal database: PostgreSQL 9.6.6\r\n"},"comment":{"url":"https://api.github.com/repos/metabase/metabase/issues/comments/450273403","html_url":"https://github.com/metabase/metabase/issues/9109#issuecomment-450273403","issue_url":"https://api.github.com/repos/metabase/metabase/issues/9109","id":450273403,"node_id":"MDEyOklzc3VlQ29tbWVudDQ1MDI3MzQwMw==","user":{"login":"salsakran","id":107439,"node_id":"MDQ6VXNlcjEwNzQzOQ==","avatar_url":"https://avatars0.githubusercontent.com/u/107439?v=4","gravatar_id":"","url":"https://api.github.com/users/salsakran","html_url":"https://github.com/salsakran","followers_url":"https://api.github.com/users/salsakran/followers","following_url":"https://api.github.com/users/salsakran/following{/other_user}","gists_url":"https://api.github.com/users/salsakran/gists{/gist_id}","starred_url":"https://api.github.com/users/salsakran/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/salsakran/subscriptions","organizations_url":"https://api.github.com/users/salsakran/orgs","repos_url":"https://api.github.com/users/salsakran/repos","events_url":"https://api.github.com/users/salsakran/events{/privacy}","received_events_url":"https://api.github.com/users/salsakran/received_events","type":"User","site_admin":false},"created_at":"2018-12-28T02:13:49Z","updated_at":"2018-12-28T02:13:49Z","author_association":"CONTRIBUTOR","body":"why are you repeating the variable name outside of the variable tags in\r\n`where c_district {{c_district}}`. Field filters are meant to replace an entire where sub-clause. "}}
{"actor":{"display_login":"salsakran"}}