{"action":"created","issue":{"url":"https://api.github.com/repos/ryancramerdesign/ProcessWire/issues/1438","labels_url":"https://api.github.com/repos/ryancramerdesign/ProcessWire/issues/1438/labels{/name}","comments_url":"https://api.github.com/repos/ryancramerdesign/ProcessWire/issues/1438/comments","events_url":"https://api.github.com/repos/ryancramerdesign/ProcessWire/issues/1438/events","html_url":"https://github.com/ryancramerdesign/ProcessWire/issues/1438","id":110169376,"number":1438,"title":"Subfield selector unexpectedly returns result in OR like fashion","user":{"login":"ruudalberts","id":13196129,"avatar_url":"https://avatars.githubusercontent.com/u/13196129?v=3","gravatar_id":"","url":"https://api.github.com/users/ruudalberts","html_url":"https://github.com/ruudalberts","followers_url":"https://api.github.com/users/ruudalberts/followers","following_url":"https://api.github.com/users/ruudalberts/following{/other_user}","gists_url":"https://api.github.com/users/ruudalberts/gists{/gist_id}","starred_url":"https://api.github.com/users/ruudalberts/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ruudalberts/subscriptions","organizations_url":"https://api.github.com/users/ruudalberts/orgs","repos_url":"https://api.github.com/users/ruudalberts/repos","events_url":"https://api.github.com/users/ruudalberts/events{/privacy}","received_events_url":"https://api.github.com/users/ruudalberts/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-10-07T07:50:00Z","updated_at":"2015-10-09T15:43:17Z","closed_at":null,"body":"The selector \"template=accommodationtype,availability.column=1194,availability.row=1889,availability.value=1\"\r\nshould return all accommodationtypes where all availability restrictions match: availablity.column = 1194 AND availability.row=1887 AND availability.value=1\r\n\r\nWhat actually happends (looking at the querylog), is that the availability field is joined 3 times, matching all 3 subfields seperately, then grouping the result and thus returning all accommodationtypes where either of the restrictions are met:\r\n\r\nMore info and a proposed fix here: https://processwire.com/talk/topic/11099-subfield-selector-unexpectedly-returning-result-in-or-like-fashion/\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/ryancramerdesign/ProcessWire/issues/comments/146907152","html_url":"https://github.com/ryancramerdesign/ProcessWire/issues/1438#issuecomment-146907152","issue_url":"https://api.github.com/repos/ryancramerdesign/ProcessWire/issues/1438","id":146907152,"user":{"login":"ryancramerdesign","id":328272,"avatar_url":"https://avatars.githubusercontent.com/u/328272?v=3","gravatar_id":"","url":"https://api.github.com/users/ryancramerdesign","html_url":"https://github.com/ryancramerdesign","followers_url":"https://api.github.com/users/ryancramerdesign/followers","following_url":"https://api.github.com/users/ryancramerdesign/following{/other_user}","gists_url":"https://api.github.com/users/ryancramerdesign/gists{/gist_id}","starred_url":"https://api.github.com/users/ryancramerdesign/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ryancramerdesign/subscriptions","organizations_url":"https://api.github.com/users/ryancramerdesign/orgs","repos_url":"https://api.github.com/users/ryancramerdesign/repos","events_url":"https://api.github.com/users/ryancramerdesign/events{/privacy}","received_events_url":"https://api.github.com/users/ryancramerdesign/received_events","type":"User","site_admin":false},"created_at":"2015-10-09T15:43:17Z","updated_at":"2015-10-09T15:43:17Z","body":"I'm wondering if you might be looking for the `@field.subfield` grouping that we introduced in PW 2.5? See here: https://processwire.com/blog/posts/processwire-2.5-changelog/#selectors-and-finding-pages"}}