{"action":"created","issue":{"url":"https://api.github.com/repos/CARLI/web-reports/issues/94","repository_url":"https://api.github.com/repos/CARLI/web-reports","labels_url":"https://api.github.com/repos/CARLI/web-reports/issues/94/labels{/name}","comments_url":"https://api.github.com/repos/CARLI/web-reports/issues/94/comments","events_url":"https://api.github.com/repos/CARLI/web-reports/issues/94/events","html_url":"https://github.com/CARLI/web-reports/issues/94","id":170005397,"number":94,"title":"More newly entered reports","user":{"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},"labels":[{"url":"https://api.github.com/repos/CARLI/web-reports/labels/Ready%20for%20Testing","name":"Ready for Testing","color":"542b5e"}],"state":"open","locked":false,"assignee":{"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},"assignees":[{"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},{"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":10,"created_at":"2016-08-08T19:33:15Z","updated_at":"2016-08-23T22:01:02Z","closed_at":null,"body":"If these check out ok, they are ready for production:  ( I found that one  of them, designated by ** does not work, but the rest return either results or zero rows)\r\n\r\n\r\n- Bib record 035 $a contains (XXXdb)nnnn   (Local Cat Maint > Bibliographic Records: Control Numbers)\r\n\r\n- Bib record without UT but title contains transl\t(Local Cat Maint > Bibliographic Records: Titles)\r\n\r\n- Bib record without UT but 700 field contains tr\t(Local Cat Maint > Bibliographic Records: Titles)\r\n\r\n- Bib record without UT but 6xx field contains Translations into (Local Cat Maint > Bibliographic Records: Titles)\r\n\r\n- ** Unindexed Call Numbers\t  (Local Cat Maint > MFHD Records: Call Numbers)\r\n** This one seems not to be working.  Likely because we are specifically searching for a $ in the SQL query and it is probably being interpreted as if it is a variable.\r\n\r\n- Serial bib records without an ISSN\t  (Local Cat Maint > Bibliographic Records: Control Numbers)\r\n\r\n- Find 020's with multiple $'s\t (Local Cat Maint > Bibliographic Records: Control Numbers)\r\n\r\n- Bib records with an ISSN but format is not for serials\t(Local Cat Maint > Bibliographic Records: Control Numbers)\r\n\r\n\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/CARLI/web-reports/issues/comments/241894409","html_url":"https://github.com/CARLI/web-reports/issues/94#issuecomment-241894409","issue_url":"https://api.github.com/repos/CARLI/web-reports/issues/94","id":241894409,"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-08-23T22:01:01Z","updated_at":"2016-08-23T22:01:01Z","body":"> KNXdb does have bibs with more than two 020 $a's like this one that can be found in both the Access and the web-reports output:\r\n\r\nI was confused why my first regex that I posted would return bibs with more than two ISBNs when I expected it to match two and only two ISBNs.  But I made a really dumb mistake in my regexp: \"`.*`\"\r\n\r\nThe error is obviously present in` ([0-9]{9}).*([0-9]{9}).*{1,}` too.\r\n\r\nI'll work on refining it further."}}
{"actor":{"display_login":"patrickzurek"}}