{"action":"created","issue":{"url":"https://api.github.com/repos/learning-unlimited/ESP-Website/issues/1810","labels_url":"https://api.github.com/repos/learning-unlimited/ESP-Website/issues/1810/labels{/name}","comments_url":"https://api.github.com/repos/learning-unlimited/ESP-Website/issues/1810/comments","events_url":"https://api.github.com/repos/learning-unlimited/ESP-Website/issues/1810/events","html_url":"https://github.com/learning-unlimited/ESP-Website/issues/1810","id":110903558,"number":1810,"title":"Comm panel \"teachers who have taught for a previous program\" doesn't work","user":{"login":"benjaminjkraft","id":111238,"avatar_url":"https://avatars.githubusercontent.com/u/111238?v=3","gravatar_id":"","url":"https://api.github.com/users/benjaminjkraft","html_url":"https://github.com/benjaminjkraft","followers_url":"https://api.github.com/users/benjaminjkraft/followers","following_url":"https://api.github.com/users/benjaminjkraft/following{/other_user}","gists_url":"https://api.github.com/users/benjaminjkraft/gists{/gist_id}","starred_url":"https://api.github.com/users/benjaminjkraft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/benjaminjkraft/subscriptions","organizations_url":"https://api.github.com/users/benjaminjkraft/orgs","repos_url":"https://api.github.com/users/benjaminjkraft/repos","events_url":"https://api.github.com/users/benjaminjkraft/events{/privacy}","received_events_url":"https://api.github.com/users/benjaminjkraft/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/learning-unlimited/ESP-Website/labels/Error","name":"Error","color":"e10c02"},{"url":"https://api.github.com/repos/learning-unlimited/ESP-Website/labels/MIT","name":"MIT","color":"e10c02"},{"url":"https://api.github.com/repos/learning-unlimited/ESP-Website/labels/UserSearchController","name":"UserSearchController","color":"bfe5bf"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-10-12T03:32:34Z","updated_at":"2015-10-12T03:53:05Z","closed_at":null,"body":"Reported by MIT:\r\n> In the E-mail pane, when I go to select all teachers teaching an approved class, I get a reasonable number -- something like 440.\r\n> \r\n> When I combine that with \"AND NOT teachers who have taught for a previous program,\" I get something like 230.\r\n> \r\n> But when I combine that with \"AND teachers who have taught for a previous program,\" I get 0."},"comment":{"url":"https://api.github.com/repos/learning-unlimited/ESP-Website/issues/comments/147285915","html_url":"https://github.com/learning-unlimited/ESP-Website/issues/1810#issuecomment-147285915","issue_url":"https://api.github.com/repos/learning-unlimited/ESP-Website/issues/1810","id":147285915,"user":{"login":"benjaminjkraft","id":111238,"avatar_url":"https://avatars.githubusercontent.com/u/111238?v=3","gravatar_id":"","url":"https://api.github.com/users/benjaminjkraft","html_url":"https://github.com/benjaminjkraft","followers_url":"https://api.github.com/users/benjaminjkraft/followers","following_url":"https://api.github.com/users/benjaminjkraft/following{/other_user}","gists_url":"https://api.github.com/users/benjaminjkraft/gists{/gist_id}","starred_url":"https://api.github.com/users/benjaminjkraft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/benjaminjkraft/subscriptions","organizations_url":"https://api.github.com/users/benjaminjkraft/orgs","repos_url":"https://api.github.com/users/benjaminjkraft/repos","events_url":"https://api.github.com/users/benjaminjkraft/events{/privacy}","received_events_url":"https://api.github.com/users/benjaminjkraft/received_events","type":"User","site_admin":false},"created_at":"2015-10-12T03:53:05Z","updated_at":"2015-10-12T03:53:05Z","body":"I'm guessing that the issue is with the way we combine Q objects meaning that for \"taught for a previous program\" you essentially end up filtering for \"teachers with a class in this program that isn't in this program\", rather than \"teachers with a class in this program and a class that isn't in this program\"."}}