{"action":"created","issue":{"url":"https://api.github.com/repos/tgriesser/knex/issues/638","repository_url":"https://api.github.com/repos/tgriesser/knex","labels_url":"https://api.github.com/repos/tgriesser/knex/issues/638/labels{/name}","comments_url":"https://api.github.com/repos/tgriesser/knex/issues/638/comments","events_url":"https://api.github.com/repos/tgriesser/knex/issues/638/events","html_url":"https://github.com/tgriesser/knex/issues/638","id":55032193,"number":638,"title":"The operator \"in\" is not permitted","user":{"login":"ozum","id":1497060,"avatar_url":"https://avatars2.githubusercontent.com/u/1497060?v=4","gravatar_id":"","url":"https://api.github.com/users/ozum","html_url":"https://github.com/ozum","followers_url":"https://api.github.com/users/ozum/followers","following_url":"https://api.github.com/users/ozum/following{/other_user}","gists_url":"https://api.github.com/users/ozum/gists{/gist_id}","starred_url":"https://api.github.com/users/ozum/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ozum/subscriptions","organizations_url":"https://api.github.com/users/ozum/orgs","repos_url":"https://api.github.com/users/ozum/repos","events_url":"https://api.github.com/users/ozum/events{/privacy}","received_events_url":"https://api.github.com/users/ozum/received_events","type":"User","site_admin":false},"labels":[{"id":23356640,"url":"https://api.github.com/repos/tgriesser/knex/labels/feature%20request","name":"feature request","color":"84b6eb","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2015-01-21T15:21:21Z","updated_at":"2018-02-26T07:18:31Z","closed_at":"2018-02-26T07:18:31Z","author_association":"CONTRIBUTOR","body":"I need to use \"in\" operator inside leftJoin.\n\n```\nknex.select('*').from('users').leftJoin('accounts', function() {\n    this.on('accounts.id', 'in', '(1,2,3,4,5,6)');\n});\n```\n\nI got error: 'The operator \"in\" is not permitted'\n\nFor inner joins, as a workaround I may move conditions to \"where\" conditions. However for left joins it is difficult and error prone to move it to where condition.\n\nOf course my actual queries are much more complex than this.\n\nIs there a way to use \"in\" operator on \"on\"?\n"},"comment":{"url":"https://api.github.com/repos/tgriesser/knex/issues/comments/368410967","html_url":"https://github.com/tgriesser/knex/issues/638#issuecomment-368410967","issue_url":"https://api.github.com/repos/tgriesser/knex/issues/638","id":368410967,"user":{"login":"wubzz","id":10179061,"avatar_url":"https://avatars2.githubusercontent.com/u/10179061?v=4","gravatar_id":"","url":"https://api.github.com/users/wubzz","html_url":"https://github.com/wubzz","followers_url":"https://api.github.com/users/wubzz/followers","following_url":"https://api.github.com/users/wubzz/following{/other_user}","gists_url":"https://api.github.com/users/wubzz/gists{/gist_id}","starred_url":"https://api.github.com/users/wubzz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wubzz/subscriptions","organizations_url":"https://api.github.com/users/wubzz/orgs","repos_url":"https://api.github.com/users/wubzz/repos","events_url":"https://api.github.com/users/wubzz/events{/privacy}","received_events_url":"https://api.github.com/users/wubzz/received_events","type":"User","site_admin":false},"created_at":"2018-02-26T07:18:31Z","updated_at":"2018-02-26T07:18:31Z","author_association":"COLLABORATOR","body":"Closing, resolved by using `onIn`"}}
{"actor":{"display_login":"wubzz"}}