{"action":"created","issue":{"url":"https://api.github.com/repos/CARLI/web-reports/issues/63","repository_url":"https://api.github.com/repos/CARLI/web-reports","labels_url":"https://api.github.com/repos/CARLI/web-reports/issues/63/labels{/name}","comments_url":"https://api.github.com/repos/CARLI/web-reports/issues/63/comments","events_url":"https://api.github.com/repos/CARLI/web-reports/issues/63/events","html_url":"https://github.com/CARLI/web-reports/issues/63","id":151515814,"number":63,"title":"Report \"Fines and Fees\" not returning complete results","user":{"login":"gibsonjc","id":17598357,"avatar_url":"https://avatars.githubusercontent.com/u/17598357?v=3","gravatar_id":"","url":"https://api.github.com/users/gibsonjc","html_url":"https://github.com/gibsonjc","followers_url":"https://api.github.com/users/gibsonjc/followers","following_url":"https://api.github.com/users/gibsonjc/following{/other_user}","gists_url":"https://api.github.com/users/gibsonjc/gists{/gist_id}","starred_url":"https://api.github.com/users/gibsonjc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gibsonjc/subscriptions","organizations_url":"https://api.github.com/users/gibsonjc/orgs","repos_url":"https://api.github.com/users/gibsonjc/repos","events_url":"https://api.github.com/users/gibsonjc/events{/privacy}","received_events_url":"https://api.github.com/users/gibsonjc/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/CARLI/web-reports/labels/Accepted","name":"Accepted","color":"542b5e"},{"url":"https://api.github.com/repos/CARLI/web-reports/labels/Ready%20for%20Prod","name":"Ready for Prod","color":"542b5e"}],"state":"closed","locked":false,"assignee":{"login":"csaundrs","id":18536549,"avatar_url":"https://avatars.githubusercontent.com/u/18536549?v=3","gravatar_id":"","url":"https://api.github.com/users/csaundrs","html_url":"https://github.com/csaundrs","followers_url":"https://api.github.com/users/csaundrs/followers","following_url":"https://api.github.com/users/csaundrs/following{/other_user}","gists_url":"https://api.github.com/users/csaundrs/gists{/gist_id}","starred_url":"https://api.github.com/users/csaundrs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/csaundrs/subscriptions","organizations_url":"https://api.github.com/users/csaundrs/orgs","repos_url":"https://api.github.com/users/csaundrs/repos","events_url":"https://api.github.com/users/csaundrs/events{/privacy}","received_events_url":"https://api.github.com/users/csaundrs/received_events","type":"User","site_admin":false},"assignees":[{"login":"csaundrs","id":18536549,"avatar_url":"https://avatars.githubusercontent.com/u/18536549?v=3","gravatar_id":"","url":"https://api.github.com/users/csaundrs","html_url":"https://github.com/csaundrs","followers_url":"https://api.github.com/users/csaundrs/followers","following_url":"https://api.github.com/users/csaundrs/following{/other_user}","gists_url":"https://api.github.com/users/csaundrs/gists{/gist_id}","starred_url":"https://api.github.com/users/csaundrs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/csaundrs/subscriptions","organizations_url":"https://api.github.com/users/csaundrs/orgs","repos_url":"https://api.github.com/users/csaundrs/repos","events_url":"https://api.github.com/users/csaundrs/events{/privacy}","received_events_url":"https://api.github.com/users/csaundrs/received_events","type":"User","site_admin":false}],"milestone":null,"comments":5,"created_at":"2016-04-27T23:31:19Z","updated_at":"2016-06-29T16:58:05Z","closed_at":"2016-06-29T16:58:05Z","body":"(Local Circulation Maintenance > Fines and Fees)\r\n\r\nRunning this report in Access on KNXdb from 1/1/2016 to 1/15/2016 results in 47 lines.\r\nRunning this report in web-reports on KNXdb from 1/1/2016 to 1/15/2016 results in 1 line (which does appear on the Access version, this is just missing the 46 others!).\r\n\r\nOriginal SQL: https://www.carli.illinois.edu/products-services/i-share/reports/secure/sql-local-man#fandf\r\n\r\nAlso, the name needs to be changed to \"Fines and Fees\", instead of \"Fine and Fees\" (plural instead of singular fine).\r\n"},"comment":{"url":"https://api.github.com/repos/CARLI/web-reports/issues/comments/229419975","html_url":"https://github.com/CARLI/web-reports/issues/63#issuecomment-229419975","issue_url":"https://api.github.com/repos/CARLI/web-reports/issues/63","id":229419975,"user":{"login":"patrickzurek","id":6615138,"avatar_url":"https://avatars.githubusercontent.com/u/6615138?v=3","gravatar_id":"","url":"https://api.github.com/users/patrickzurek","html_url":"https://github.com/patrickzurek","followers_url":"https://api.github.com/users/patrickzurek/followers","following_url":"https://api.github.com/users/patrickzurek/following{/other_user}","gists_url":"https://api.github.com/users/patrickzurek/gists{/gist_id}","starred_url":"https://api.github.com/users/patrickzurek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/patrickzurek/subscriptions","organizations_url":"https://api.github.com/users/patrickzurek/orgs","repos_url":"https://api.github.com/users/patrickzurek/repos","events_url":"https://api.github.com/users/patrickzurek/events{/privacy}","received_events_url":"https://api.github.com/users/patrickzurek/received_events","type":"User","site_admin":false},"created_at":"2016-06-29T16:58:05Z","updated_at":"2016-06-29T16:58:05Z","body":"Moved to prod."}}
{"actor":{"display_login":"patrickzurek"}}