{"action":"closed","number":49,"pull_request":{"url":"https://api.github.com/repos/cherimarie/LibraryCollection/pulls/49","id":35362029,"html_url":"https://github.com/cherimarie/LibraryCollection/pull/49","diff_url":"https://github.com/cherimarie/LibraryCollection/pull/49.diff","patch_url":"https://github.com/cherimarie/LibraryCollection/pull/49.patch","issue_url":"https://api.github.com/repos/cherimarie/LibraryCollection/issues/49","number":49,"state":"closed","locked":false,"title":"more sortability with joins","user":{"login":"forplayplay","id":2886826,"avatar_url":"https://avatars.githubusercontent.com/u/2886826?v=3","gravatar_id":"","url":"https://api.github.com/users/forplayplay","html_url":"https://github.com/forplayplay","followers_url":"https://api.github.com/users/forplayplay/followers","following_url":"https://api.github.com/users/forplayplay/following{/other_user}","gists_url":"https://api.github.com/users/forplayplay/gists{/gist_id}","starred_url":"https://api.github.com/users/forplayplay/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/forplayplay/subscriptions","organizations_url":"https://api.github.com/users/forplayplay/orgs","repos_url":"https://api.github.com/users/forplayplay/repos","events_url":"https://api.github.com/users/forplayplay/events{/privacy}","received_events_url":"https://api.github.com/users/forplayplay/received_events","type":"User","site_admin":false},"body":"sortability that required join tables now implemented\r\n\r\nstill missing more complicated queries which require primary author info","created_at":"2015-05-13T19:30:18Z","updated_at":"2015-05-27T16:32:55Z","closed_at":"2015-05-27T16:32:55Z","merged_at":"2015-05-27T16:32:55Z","merge_commit_sha":"52e6ae6012d3ebac6e5f1944b0002f180b62a9a3","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/cherimarie/LibraryCollection/pulls/49/commits","review_comments_url":"https://api.github.com/repos/cherimarie/LibraryCollection/pulls/49/comments","review_comment_url":"https://api.github.com/repos/cherimarie/LibraryCollection/pulls/comments{/number}","comments_url":"https://api.github.com/repos/cherimarie/LibraryCollection/issues/49/comments","statuses_url":"https://api.github.com/repos/cherimarie/LibraryCollection/statuses/6e82a7334f82577fa582f694dbd4a9ac5380216a","head":{"label":"cherimarie:full_sortability","ref":"full_sortability","sha":"6e82a7334f82577fa582f694dbd4a9ac5380216a","user":{"login":"cherimarie","id":2523812,"avatar_url":"https://avatars.githubusercontent.com/u/2523812?v=3","gravatar_id":"","url":"https://api.github.com/users/cherimarie","html_url":"https://github.com/cherimarie","followers_url":"https://api.github.com/users/cherimarie/followers","following_url":"https://api.github.com/users/cherimarie/following{/other_user}","gists_url":"https://api.github.com/users/cherimarie/gists{/gist_id}","starred_url":"https://api.github.com/users/cherimarie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cherimarie/subscriptions","organizations_url":"https://api.github.com/users/cherimarie/orgs","repos_url":"https://api.github.com/users/cherimarie/repos","events_url":"https://api.github.com/users/cherimarie/events{/privacy}","received_events_url":"https://api.github.com/users/cherimarie/received_events","type":"User","site_admin":false},"repo":{"id":28752205,"name":"LibraryCollection","full_name":"cherimarie/LibraryCollection","owner":{"login":"cherimarie","id":2523812,"avatar_url":"https://avatars.githubusercontent.com/u/2523812?v=3","gravatar_id":"","url":"https://api.github.com/users/cherimarie","html_url":"https://github.com/cherimarie","followers_url":"https://api.github.com/users/cherimarie/followers","following_url":"https://api.github.com/users/cherimarie/following{/other_user}","gists_url":"https://api.github.com/users/cherimarie/gists{/gist_id}","starred_url":"https://api.github.com/users/cherimarie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cherimarie/subscriptions","organizations_url":"https://api.github.com/users/cherimarie/orgs","repos_url":"https://api.github.com/users/cherimarie/repos","events_url":"https://api.github.com/users/cherimarie/events{/privacy}","received_events_url":"https://api.github.com/users/cherimarie/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/cherimarie/LibraryCollection","description":"A public web interface for patrons to view and search library collection","fork":true,"url":"https://api.github.com/repos/cherimarie/LibraryCollection","forks_url":"https://api.github.com/repos/cherimarie/LibraryCollection/forks","keys_url":"https://api.github.com/repos/cherimarie/LibraryCollection/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cherimarie/LibraryCollection/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cherimarie/LibraryCollection/teams","hooks_url":"https://api.github.com/repos/cherimarie/LibraryCollection/hooks","issue_events_url":"https://api.github.com/repos/cherimarie/LibraryCollection/issues/events{/number}","events_url":"https://api.github.com/repos/cherimarie/LibraryCollection/events","assignees_url":"https://api.github.com/repos/cherimarie/LibraryCollection/assignees{/user}","branches_url":"https://api.github.com/repos/cherimarie/LibraryCollection/branches{/branch}","tags_url":"https://api.github.com/repos/cherimarie/LibraryCollection/tags","blobs_url":"https://api.github.com/repos/cherimarie/LibraryCollection/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cherimarie/LibraryCollection/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cherimarie/LibraryCollection/git/refs{/sha}","trees_url":"https://api.github.com/repos/cherimarie/LibraryCollection/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cherimarie/LibraryCollection/statuses/{sha}","languages_url":"https://api.github.com/repos/cherimarie/LibraryCollection/languages","stargazers_url":"https://api.github.com/repos/cherimarie/LibraryCollection/stargazers","contributors_url":"https://api.github.com/repos/cherimarie/LibraryCollection/contributors","subscribers_url":"https://api.github.com/repos/cherimarie/LibraryCollection/subscribers","subscription_url":"https://api.github.com/repos/cherimarie/LibraryCollection/subscription","commits_url":"https://api.github.com/repos/cherimarie/LibraryCollection/commits{/sha}","git_commits_url":"https://api.github.com/repos/cherimarie/LibraryCollection/git/commits{/sha}","comments_url":"https://api.github.com/repos/cherimarie/LibraryCollection/comments{/number}","issue_comment_url":"https://api.github.com/repos/cherimarie/LibraryCollection/issues/comments{/number}","contents_url":"https://api.github.com/repos/cherimarie/LibraryCollection/contents/{+path}","compare_url":"https://api.github.com/repos/cherimarie/LibraryCollection/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cherimarie/LibraryCollection/merges","archive_url":"https://api.github.com/repos/cherimarie/LibraryCollection/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cherimarie/LibraryCollection/downloads","issues_url":"https://api.github.com/repos/cherimarie/LibraryCollection/issues{/number}","pulls_url":"https://api.github.com/repos/cherimarie/LibraryCollection/pulls{/number}","milestones_url":"https://api.github.com/repos/cherimarie/LibraryCollection/milestones{/number}","notifications_url":"https://api.github.com/repos/cherimarie/LibraryCollection/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cherimarie/LibraryCollection/labels{/name}","releases_url":"https://api.github.com/repos/cherimarie/LibraryCollection/releases{/id}","created_at":"2015-01-03T19:11:27Z","updated_at":"2015-05-08T07:35:02Z","pushed_at":"2015-05-27T16:32:55Z","git_url":"git://github.com/cherimarie/LibraryCollection.git","ssh_url":"git@github.com:cherimarie/LibraryCollection.git","clone_url":"https://github.com/cherimarie/LibraryCollection.git","svn_url":"https://github.com/cherimarie/LibraryCollection","homepage":null,"size":4578,"stargazers_count":1,"watchers_count":1,"language":"JavaScript","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":2,"forks":0,"open_issues":2,"watchers":1,"default_branch":"master"}},"base":{"label":"cherimarie:master","ref":"master","sha":"bb4bcdc877b1bb0e8edc90f0f765e1bed37be122","user":{"login":"cherimarie","id":2523812,"avatar_url":"https://avatars.githubusercontent.com/u/2523812?v=3","gravatar_id":"","url":"https://api.github.com/users/cherimarie","html_url":"https://github.com/cherimarie","followers_url":"https://api.github.com/users/cherimarie/followers","following_url":"https://api.github.com/users/cherimarie/following{/other_user}","gists_url":"https://api.github.com/users/cherimarie/gists{/gist_id}","starred_url":"https://api.github.com/users/cherimarie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cherimarie/subscriptions","organizations_url":"https://api.github.com/users/cherimarie/orgs","repos_url":"https://api.github.com/users/cherimarie/repos","events_url":"https://api.github.com/users/cherimarie/events{/privacy}","received_events_url":"https://api.github.com/users/cherimarie/received_events","type":"User","site_admin":false},"repo":{"id":28752205,"name":"LibraryCollection","full_name":"cherimarie/LibraryCollection","owner":{"login":"cherimarie","id":2523812,"avatar_url":"https://avatars.githubusercontent.com/u/2523812?v=3","gravatar_id":"","url":"https://api.github.com/users/cherimarie","html_url":"https://github.com/cherimarie","followers_url":"https://api.github.com/users/cherimarie/followers","following_url":"https://api.github.com/users/cherimarie/following{/other_user}","gists_url":"https://api.github.com/users/cherimarie/gists{/gist_id}","starred_url":"https://api.github.com/users/cherimarie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cherimarie/subscriptions","organizations_url":"https://api.github.com/users/cherimarie/orgs","repos_url":"https://api.github.com/users/cherimarie/repos","events_url":"https://api.github.com/users/cherimarie/events{/privacy}","received_events_url":"https://api.github.com/users/cherimarie/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/cherimarie/LibraryCollection","description":"A public web interface for patrons to view and search library collection","fork":true,"url":"https://api.github.com/repos/cherimarie/LibraryCollection","forks_url":"https://api.github.com/repos/cherimarie/LibraryCollection/forks","keys_url":"https://api.github.com/repos/cherimarie/LibraryCollection/keys{/key_id}","collaborators_url":"https://api.github.com/repos/cherimarie/LibraryCollection/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/cherimarie/LibraryCollection/teams","hooks_url":"https://api.github.com/repos/cherimarie/LibraryCollection/hooks","issue_events_url":"https://api.github.com/repos/cherimarie/LibraryCollection/issues/events{/number}","events_url":"https://api.github.com/repos/cherimarie/LibraryCollection/events","assignees_url":"https://api.github.com/repos/cherimarie/LibraryCollection/assignees{/user}","branches_url":"https://api.github.com/repos/cherimarie/LibraryCollection/branches{/branch}","tags_url":"https://api.github.com/repos/cherimarie/LibraryCollection/tags","blobs_url":"https://api.github.com/repos/cherimarie/LibraryCollection/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/cherimarie/LibraryCollection/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/cherimarie/LibraryCollection/git/refs{/sha}","trees_url":"https://api.github.com/repos/cherimarie/LibraryCollection/git/trees{/sha}","statuses_url":"https://api.github.com/repos/cherimarie/LibraryCollection/statuses/{sha}","languages_url":"https://api.github.com/repos/cherimarie/LibraryCollection/languages","stargazers_url":"https://api.github.com/repos/cherimarie/LibraryCollection/stargazers","contributors_url":"https://api.github.com/repos/cherimarie/LibraryCollection/contributors","subscribers_url":"https://api.github.com/repos/cherimarie/LibraryCollection/subscribers","subscription_url":"https://api.github.com/repos/cherimarie/LibraryCollection/subscription","commits_url":"https://api.github.com/repos/cherimarie/LibraryCollection/commits{/sha}","git_commits_url":"https://api.github.com/repos/cherimarie/LibraryCollection/git/commits{/sha}","comments_url":"https://api.github.com/repos/cherimarie/LibraryCollection/comments{/number}","issue_comment_url":"https://api.github.com/repos/cherimarie/LibraryCollection/issues/comments{/number}","contents_url":"https://api.github.com/repos/cherimarie/LibraryCollection/contents/{+path}","compare_url":"https://api.github.com/repos/cherimarie/LibraryCollection/compare/{base}...{head}","merges_url":"https://api.github.com/repos/cherimarie/LibraryCollection/merges","archive_url":"https://api.github.com/repos/cherimarie/LibraryCollection/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/cherimarie/LibraryCollection/downloads","issues_url":"https://api.github.com/repos/cherimarie/LibraryCollection/issues{/number}","pulls_url":"https://api.github.com/repos/cherimarie/LibraryCollection/pulls{/number}","milestones_url":"https://api.github.com/repos/cherimarie/LibraryCollection/milestones{/number}","notifications_url":"https://api.github.com/repos/cherimarie/LibraryCollection/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/cherimarie/LibraryCollection/labels{/name}","releases_url":"https://api.github.com/repos/cherimarie/LibraryCollection/releases{/id}","created_at":"2015-01-03T19:11:27Z","updated_at":"2015-05-08T07:35:02Z","pushed_at":"2015-05-27T16:32:55Z","git_url":"git://github.com/cherimarie/LibraryCollection.git","ssh_url":"git@github.com:cherimarie/LibraryCollection.git","clone_url":"https://github.com/cherimarie/LibraryCollection.git","svn_url":"https://github.com/cherimarie/LibraryCollection","homepage":null,"size":4578,"stargazers_count":1,"watchers_count":1,"language":"JavaScript","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":2,"forks":0,"open_issues":2,"watchers":1,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/cherimarie/LibraryCollection/pulls/49"},"html":{"href":"https://github.com/cherimarie/LibraryCollection/pull/49"},"issue":{"href":"https://api.github.com/repos/cherimarie/LibraryCollection/issues/49"},"comments":{"href":"https://api.github.com/repos/cherimarie/LibraryCollection/issues/49/comments"},"review_comments":{"href":"https://api.github.com/repos/cherimarie/LibraryCollection/pulls/49/comments"},"review_comment":{"href":"https://api.github.com/repos/cherimarie/LibraryCollection/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/cherimarie/LibraryCollection/pulls/49/commits"},"statuses":{"href":"https://api.github.com/repos/cherimarie/LibraryCollection/statuses/6e82a7334f82577fa582f694dbd4a9ac5380216a"}},"merged":true,"mergeable":null,"mergeable_state":"unknown","merged_by":{"login":"cherimarie","id":2523812,"avatar_url":"https://avatars.githubusercontent.com/u/2523812?v=3","gravatar_id":"","url":"https://api.github.com/users/cherimarie","html_url":"https://github.com/cherimarie","followers_url":"https://api.github.com/users/cherimarie/followers","following_url":"https://api.github.com/users/cherimarie/following{/other_user}","gists_url":"https://api.github.com/users/cherimarie/gists{/gist_id}","starred_url":"https://api.github.com/users/cherimarie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cherimarie/subscriptions","organizations_url":"https://api.github.com/users/cherimarie/orgs","repos_url":"https://api.github.com/users/cherimarie/repos","events_url":"https://api.github.com/users/cherimarie/events{/privacy}","received_events_url":"https://api.github.com/users/cherimarie/received_events","type":"User","site_admin":false},"comments":0,"review_comments":0,"commits":1,"additions":52,"deletions":35,"changed_files":12}}