{"action":"created","issue":{"url":"https://api.github.com/repos/openEduConnect/eduextractor/issues/27","labels_url":"https://api.github.com/repos/openEduConnect/eduextractor/issues/27/labels{/name}","comments_url":"https://api.github.com/repos/openEduConnect/eduextractor/issues/27/comments","events_url":"https://api.github.com/repos/openEduConnect/eduextractor/issues/27/events","html_url":"https://github.com/openEduConnect/eduextractor/issues/27","id":100570859,"number":27,"title":"adhoc_studentemail query is broken. ","user":{"login":"hunterowens","id":1735650,"avatar_url":"https://avatars.githubusercontent.com/u/1735650?v=3","gravatar_id":"","url":"https://api.github.com/users/hunterowens","html_url":"https://github.com/hunterowens","followers_url":"https://api.github.com/users/hunterowens/followers","following_url":"https://api.github.com/users/hunterowens/following{/other_user}","gists_url":"https://api.github.com/users/hunterowens/gists{/gist_id}","starred_url":"https://api.github.com/users/hunterowens/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hunterowens/subscriptions","organizations_url":"https://api.github.com/users/hunterowens/orgs","repos_url":"https://api.github.com/users/hunterowens/repos","events_url":"https://api.github.com/users/hunterowens/events{/privacy}","received_events_url":"https://api.github.com/users/hunterowens/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/openEduConnect/eduextractor/labels/ready","name":"ready","color":"ededed"}],"state":"closed","locked":false,"assignee":{"login":"philngo","id":2687443,"avatar_url":"https://avatars.githubusercontent.com/u/2687443?v=3","gravatar_id":"","url":"https://api.github.com/users/philngo","html_url":"https://github.com/philngo","followers_url":"https://api.github.com/users/philngo/followers","following_url":"https://api.github.com/users/philngo/following{/other_user}","gists_url":"https://api.github.com/users/philngo/gists{/gist_id}","starred_url":"https://api.github.com/users/philngo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/philngo/subscriptions","organizations_url":"https://api.github.com/users/philngo/orgs","repos_url":"https://api.github.com/users/philngo/repos","events_url":"https://api.github.com/users/philngo/events{/privacy}","received_events_url":"https://api.github.com/users/philngo/received_events","type":"User","site_admin":false},"milestone":null,"comments":7,"created_at":"2015-08-12T15:33:10Z","updated_at":"2015-11-12T21:22:06Z","closed_at":"2015-11-12T21:22:06Z","body":"results come back in a form that looks like this: \r\n\r\n```\r\n\r\n1111,1111,emailaddress,\r\n2222,2222,emailaddress,\r\n```\r\n\r\nwith the exception of one student who does have an email address. \r\n\r\nOG query. \r\n\r\n```\r\nSELECT ID AS personid,\r\n       'emailaddress' AS key,\r\n       ps_customfields.getStudentscf(id, 'StudentEmail') AS value\r\nFROM students s\r\nWHERE s.enroll_status = 0;alternatecolor]\r\n\r\n<tr class=\"oddrow\" >\r\n\t<td><font size=\"1.5\">          ~(id;1)           </font>           </td>\r\n\t<td><font size=\"1.5\">          ~(personid;t)    </font>           </td>\r\n\t<td><font size=\"1.5\">          ~(value;t)    </font>           </td>\r\n</tr>\r\n[/tlist_sql]\r\n```"},"comment":{"url":"https://api.github.com/repos/openEduConnect/eduextractor/issues/comments/156238450","html_url":"https://github.com/openEduConnect/eduextractor/issues/27#issuecomment-156238450","issue_url":"https://api.github.com/repos/openEduConnect/eduextractor/issues/27","id":156238450,"user":{"login":"hunterowens","id":1735650,"avatar_url":"https://avatars.githubusercontent.com/u/1735650?v=3","gravatar_id":"","url":"https://api.github.com/users/hunterowens","html_url":"https://github.com/hunterowens","followers_url":"https://api.github.com/users/hunterowens/followers","following_url":"https://api.github.com/users/hunterowens/following{/other_user}","gists_url":"https://api.github.com/users/hunterowens/gists{/gist_id}","starred_url":"https://api.github.com/users/hunterowens/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hunterowens/subscriptions","organizations_url":"https://api.github.com/users/hunterowens/orgs","repos_url":"https://api.github.com/users/hunterowens/repos","events_url":"https://api.github.com/users/hunterowens/events{/privacy}","received_events_url":"https://api.github.com/users/hunterowens/received_events","type":"User","site_admin":false},"created_at":"2015-11-12T21:22:06Z","updated_at":"2015-11-12T21:22:06Z","body":"```SELECT id, student_web_id FROM STUDENTS```works to get the id. "}}