{"action":"created","issue":{"url":"https://api.github.com/repos/metabase/metabase/issues/3816","repository_url":"https://api.github.com/repos/metabase/metabase","labels_url":"https://api.github.com/repos/metabase/metabase/issues/3816/labels{/name}","comments_url":"https://api.github.com/repos/metabase/metabase/issues/3816/comments","events_url":"https://api.github.com/repos/metabase/metabase/issues/3816/events","html_url":"https://github.com/metabase/metabase/issues/3816","id":191754561,"number":3816,"title":"Dashboard filters send filter value as string - invalid Postgres query","user":{"login":"c2h5oh","id":446070,"avatar_url":"https://avatars.githubusercontent.com/u/446070?v=3","gravatar_id":"","url":"https://api.github.com/users/c2h5oh","html_url":"https://github.com/c2h5oh","followers_url":"https://api.github.com/users/c2h5oh/followers","following_url":"https://api.github.com/users/c2h5oh/following{/other_user}","gists_url":"https://api.github.com/users/c2h5oh/gists{/gist_id}","starred_url":"https://api.github.com/users/c2h5oh/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/c2h5oh/subscriptions","organizations_url":"https://api.github.com/users/c2h5oh/orgs","repos_url":"https://api.github.com/users/c2h5oh/repos","events_url":"https://api.github.com/users/c2h5oh/events{/privacy}","received_events_url":"https://api.github.com/users/c2h5oh/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-11-25T19:03:54Z","updated_at":"2016-12-02T19:07:54Z","closed_at":null,"body":"- Your browser and the version: (e.x. Chrome 52.1, Firefox 48.0, IE 10)\r\nChrome 54.0.2840.100\r\n\r\n- Your operating system:\r\nLinux\r\n\r\n- Your databases: (e.x. MySQL, Postgres, MongoDB, …)\r\nPostgreSQL 9.6\r\n\r\n- Metabase version:\r\nv0.20.3\r\n\r\n- Metabase hosting environment:\r\nUbuntu 16.04\r\n\r\n- Metabase internal database:\r\nH2\r\n\r\n- *Repeatable steps to reproduce the issue*\r\n1. Create a question and add it to a dashboard\r\n2. Add dashboard filter that filters by a numeric column (doesn't matter if it's a PK or category)\r\n3. Enter filter value (default or user entry - doesn't matter)\r\n\r\nExpected: updated, filtered values\r\nActual: `There was a problem displaying this chart.`\r\nError: `operator does not exist: bigint = character varying\\n  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.`\r\n\r\nForeign keys seem to be working fine.\r\n\r\nPayload modification experimentation results:\r\nthis fails\r\n```json\r\n{\r\n   \"cardID\":5,\r\n   \"parameters\":[\r\n      {\r\n         \"type\":\"id\",\r\n         \"target\":[\r\n            \"dimension\",\r\n            [\r\n               \"field-id\",\r\n               119\r\n            ]\r\n         ],\r\n         \"value\":\"2158\"\r\n      }\r\n   ]\r\n}\r\n```\r\n\r\nthis works: \r\n```json\r\n{\r\n   \"cardID\":5,\r\n   \"parameters\":[\r\n      {\r\n         \"type\":\"number\",\r\n         \"target\":[\r\n            \"dimension\",\r\n            [\r\n               \"field-id\",\r\n               119\r\n            ]\r\n         ],\r\n         \"value\":\"2158\"\r\n      }\r\n   ]\r\n}\r\n```"},"comment":{"url":"https://api.github.com/repos/metabase/metabase/issues/comments/264535874","html_url":"https://github.com/metabase/metabase/issues/3816#issuecomment-264535874","issue_url":"https://api.github.com/repos/metabase/metabase/issues/3816","id":264535874,"user":{"login":"LukeAbell","id":3343530,"avatar_url":"https://avatars.githubusercontent.com/u/3343530?v=3","gravatar_id":"","url":"https://api.github.com/users/LukeAbell","html_url":"https://github.com/LukeAbell","followers_url":"https://api.github.com/users/LukeAbell/followers","following_url":"https://api.github.com/users/LukeAbell/following{/other_user}","gists_url":"https://api.github.com/users/LukeAbell/gists{/gist_id}","starred_url":"https://api.github.com/users/LukeAbell/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/LukeAbell/subscriptions","organizations_url":"https://api.github.com/users/LukeAbell/orgs","repos_url":"https://api.github.com/users/LukeAbell/repos","events_url":"https://api.github.com/users/LukeAbell/events{/privacy}","received_events_url":"https://api.github.com/users/LukeAbell/received_events","type":"User","site_admin":false},"created_at":"2016-12-02T19:07:53Z","updated_at":"2016-12-02T19:07:53Z","body":"I'm having this same issue. \r\n\r\n<img width=\"1920\" alt=\"screenshot_1422\" src=\"https://cloud.githubusercontent.com/assets/3343530/20846634/9aa04f78-b898-11e6-9aa9-0affdd95157d.png\">\r\n<img width=\"1920\" alt=\"screenshot_1426\" src=\"https://cloud.githubusercontent.com/assets/3343530/20846636/9aa274ba-b898-11e6-9539-48ed9d8ed0cb.png\">\r\n<img width=\"1920\" alt=\"screenshot_1427\" src=\"https://cloud.githubusercontent.com/assets/3343530/20846635/9aa15c4c-b898-11e6-916e-a2e9633be2f2.png\">\r\n<img width=\"1684\" alt=\"screenshot_1428\" src=\"https://cloud.githubusercontent.com/assets/3343530/20846633/9aa008ec-b898-11e6-854d-7181506fea19.png\">\r\n\r\n\r\n"}}
{"actor":{"display_login":"LukeAbell"}}