{"action":"created","issue":{"url":"https://api.github.com/repos/aaberg/sql2o/issues/146","labels_url":"https://api.github.com/repos/aaberg/sql2o/issues/146/labels{/name}","comments_url":"https://api.github.com/repos/aaberg/sql2o/issues/146/comments","events_url":"https://api.github.com/repos/aaberg/sql2o/issues/146/events","html_url":"https://github.com/aaberg/sql2o/issues/146","id":42746951,"number":146,"title":"addParameter with a list","user":{"login":"aaberg","id":651812,"avatar_url":"https://avatars.githubusercontent.com/u/651812?v=3","gravatar_id":"","url":"https://api.github.com/users/aaberg","html_url":"https://github.com/aaberg","followers_url":"https://api.github.com/users/aaberg/followers","following_url":"https://api.github.com/users/aaberg/following{/other_user}","gists_url":"https://api.github.com/users/aaberg/gists{/gist_id}","starred_url":"https://api.github.com/users/aaberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aaberg/subscriptions","organizations_url":"https://api.github.com/users/aaberg/orgs","repos_url":"https://api.github.com/users/aaberg/repos","events_url":"https://api.github.com/users/aaberg/events{/privacy}","received_events_url":"https://api.github.com/users/aaberg/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/aaberg/sql2o/labels/feature%20request","name":"feature request","color":"009800"},{"url":"https://api.github.com/repos/aaberg/sql2o/labels/priority-normal","name":"priority-normal","color":"eb6420"}],"state":"open","locked":false,"assignee":{"login":"aaberg","id":651812,"avatar_url":"https://avatars.githubusercontent.com/u/651812?v=3","gravatar_id":"","url":"https://api.github.com/users/aaberg","html_url":"https://github.com/aaberg","followers_url":"https://api.github.com/users/aaberg/followers","following_url":"https://api.github.com/users/aaberg/following{/other_user}","gists_url":"https://api.github.com/users/aaberg/gists{/gist_id}","starred_url":"https://api.github.com/users/aaberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aaberg/subscriptions","organizations_url":"https://api.github.com/users/aaberg/orgs","repos_url":"https://api.github.com/users/aaberg/repos","events_url":"https://api.github.com/users/aaberg/events{/privacy}","received_events_url":"https://api.github.com/users/aaberg/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/aaberg/sql2o/milestones/12","html_url":"https://github.com/aaberg/sql2o/milestones/1.6.0","labels_url":"https://api.github.com/repos/aaberg/sql2o/milestones/12/labels","id":659127,"number":12,"title":"1.6.0","description":"","creator":{"login":"aaberg","id":651812,"avatar_url":"https://avatars.githubusercontent.com/u/651812?v=3","gravatar_id":"","url":"https://api.github.com/users/aaberg","html_url":"https://github.com/aaberg","followers_url":"https://api.github.com/users/aaberg/followers","following_url":"https://api.github.com/users/aaberg/following{/other_user}","gists_url":"https://api.github.com/users/aaberg/gists{/gist_id}","starred_url":"https://api.github.com/users/aaberg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aaberg/subscriptions","organizations_url":"https://api.github.com/users/aaberg/orgs","repos_url":"https://api.github.com/users/aaberg/repos","events_url":"https://api.github.com/users/aaberg/events{/privacy}","received_events_url":"https://api.github.com/users/aaberg/received_events","type":"User","site_admin":false},"open_issues":5,"closed_issues":9,"state":"open","created_at":"2014-05-14T19:15:22Z","updated_at":"2015-04-21T10:45:58Z","due_on":null,"closed_at":null},"comments":8,"created_at":"2014-09-15T07:25:35Z","updated_at":"2015-05-21T05:48:52Z","closed_at":null,"body":"It should be possible to add a parameter with a list or an array.\r\n\r\nExample:\r\n``` java\r\nint[] ids = new int[]{1,2,3};\r\nString sql = \"select * from mytable where id in (:idParam)\";\r\ntry (Connectio con = sql2o.open()) {\r\n    return con.createQuery(sql)\r\n            .addParameter(\"idParam\", ids)\r\n            .executeAndFetch(Pojo.class);\r\n}\r\n```"},"comment":{"url":"https://api.github.com/repos/aaberg/sql2o/issues/comments/104146696","html_url":"https://github.com/aaberg/sql2o/issues/146#issuecomment-104146696","issue_url":"https://api.github.com/repos/aaberg/sql2o/issues/146","id":104146696,"user":{"login":"jlogar","id":1444373,"avatar_url":"https://avatars.githubusercontent.com/u/1444373?v=3","gravatar_id":"","url":"https://api.github.com/users/jlogar","html_url":"https://github.com/jlogar","followers_url":"https://api.github.com/users/jlogar/followers","following_url":"https://api.github.com/users/jlogar/following{/other_user}","gists_url":"https://api.github.com/users/jlogar/gists{/gist_id}","starred_url":"https://api.github.com/users/jlogar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jlogar/subscriptions","organizations_url":"https://api.github.com/users/jlogar/orgs","repos_url":"https://api.github.com/users/jlogar/repos","events_url":"https://api.github.com/users/jlogar/events{/privacy}","received_events_url":"https://api.github.com/users/jlogar/received_events","type":"User","site_admin":false},"created_at":"2015-05-21T05:48:52Z","updated_at":"2015-05-21T05:48:52Z","body":"@dimzon not sure we are talking about the same thing here. The issue is not storing arrays in the database but doing a select where the WHERE clause contains the IN operator and requires an array of values."}}