{"action":"opened","number":6173,"pull_request":{"url":"https://api.github.com/repos/mautic/mautic/pulls/6173","id":193000962,"node_id":"MDExOlB1bGxSZXF1ZXN0MTkzMDAwOTYy","html_url":"https://github.com/mautic/mautic/pull/6173","diff_url":"https://github.com/mautic/mautic/pull/6173.diff","patch_url":"https://github.com/mautic/mautic/pull/6173.patch","issue_url":"https://api.github.com/repos/mautic/mautic/issues/6173","number":6173,"state":"open","locked":false,"title":"Fix reports when a column is added to aggregator and not to select","user":{"login":"escopecz","id":1235442,"node_id":"MDQ6VXNlcjEyMzU0NDI=","avatar_url":"https://avatars2.githubusercontent.com/u/1235442?v=4","gravatar_id":"","url":"https://api.github.com/users/escopecz","html_url":"https://github.com/escopecz","followers_url":"https://api.github.com/users/escopecz/followers","following_url":"https://api.github.com/users/escopecz/following{/other_user}","gists_url":"https://api.github.com/users/escopecz/gists{/gist_id}","starred_url":"https://api.github.com/users/escopecz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/escopecz/subscriptions","organizations_url":"https://api.github.com/users/escopecz/orgs","repos_url":"https://api.github.com/users/escopecz/repos","events_url":"https://api.github.com/users/escopecz/events{/privacy}","received_events_url":"https://api.github.com/users/escopecz/received_events","type":"User","site_admin":false},"body":"**Please be sure you are submitting this against the _staging_ branch.**\r\n\r\n[//]: # ( Please answer the following questions: )\r\n\r\n| Q  | A\r\n| --- | ---\r\n| Bug fix? | Y\r\n| New feature? | N\r\n| Automated tests included? | N\r\n| Related user documentation PR URL | /\r\n| Related developer documentation PR URL | /\r\n| Issues addressed (#s or URLs) | /\r\n| BC breaks? | N\r\n| Deprecations? | N\r\n\r\n[//]: # ( Note that all new features should have a related user and/or developer documentation PR in their respective repositories. )\r\n\r\n[//]: # ( Required: )\r\n#### Description:\r\nAdding aggregator columns to the hasColumn check so joins would be prepared. Reports were throwing errors if an aggregator column was selected without selecting it in the select clause.\r\n\r\n[//]: # ( As applicable: )\r\n#### Steps to reproduce the bug:\r\n![screen shot 2018-06-06 at 14 41 08](https://user-images.githubusercontent.com/1235442/41038809-bfddea8c-6997-11e8-920e-7b38375ed822.png)\r\n\r\n1. Create similar Email Sends report as in the screenshot\r\n2. Save - error\r\n\r\n#### Steps to test this PR:\r\n1. Refresh - report shows correct data.","created_at":"2018-06-06T12:44:46Z","updated_at":"2018-06-06T12:44:46Z","closed_at":null,"merged_at":null,"merge_commit_sha":null,"assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/mautic/mautic/pulls/6173/commits","review_comments_url":"https://api.github.com/repos/mautic/mautic/pulls/6173/comments","review_comment_url":"https://api.github.com/repos/mautic/mautic/pulls/comments{/number}","comments_url":"https://api.github.com/repos/mautic/mautic/issues/6173/comments","statuses_url":"https://api.github.com/repos/mautic/mautic/statuses/080a19854e5d10cf7a7ae6c64d399cd591158739","head":{"label":"escopecz:bug-report-aggregator-columns","ref":"bug-report-aggregator-columns","sha":"080a19854e5d10cf7a7ae6c64d399cd591158739","user":{"login":"escopecz","id":1235442,"node_id":"MDQ6VXNlcjEyMzU0NDI=","avatar_url":"https://avatars2.githubusercontent.com/u/1235442?v=4","gravatar_id":"","url":"https://api.github.com/users/escopecz","html_url":"https://github.com/escopecz","followers_url":"https://api.github.com/users/escopecz/followers","following_url":"https://api.github.com/users/escopecz/following{/other_user}","gists_url":"https://api.github.com/users/escopecz/gists{/gist_id}","starred_url":"https://api.github.com/users/escopecz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/escopecz/subscriptions","organizations_url":"https://api.github.com/users/escopecz/orgs","repos_url":"https://api.github.com/users/escopecz/repos","events_url":"https://api.github.com/users/escopecz/events{/privacy}","received_events_url":"https://api.github.com/users/escopecz/received_events","type":"User","site_admin":false},"repo":{"id":31202004,"node_id":"MDEwOlJlcG9zaXRvcnkzMTIwMjAwNA==","name":"mautic","full_name":"escopecz/mautic","owner":{"login":"escopecz","id":1235442,"node_id":"MDQ6VXNlcjEyMzU0NDI=","avatar_url":"https://avatars2.githubusercontent.com/u/1235442?v=4","gravatar_id":"","url":"https://api.github.com/users/escopecz","html_url":"https://github.com/escopecz","followers_url":"https://api.github.com/users/escopecz/followers","following_url":"https://api.github.com/users/escopecz/following{/other_user}","gists_url":"https://api.github.com/users/escopecz/gists{/gist_id}","starred_url":"https://api.github.com/users/escopecz/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/escopecz/subscriptions","organizations_url":"https://api.github.com/users/escopecz/orgs","repos_url":"https://api.github.com/users/escopecz/repos","events_url":"https://api.github.com/users/escopecz/events{/privacy}","received_events_url":"https://api.github.com/users/escopecz/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/escopecz/mautic","description":"Mautic: Open Source Marketing Automation Software.","fork":true,"url":"https://api.github.com/repos/escopecz/mautic","forks_url":"https://api.github.com/repos/escopecz/mautic/forks","keys_url":"https://api.github.com/repos/escopecz/mautic/keys{/key_id}","collaborators_url":"https://api.github.com/repos/escopecz/mautic/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/escopecz/mautic/teams","hooks_url":"https://api.github.com/repos/escopecz/mautic/hooks","issue_events_url":"https://api.github.com/repos/escopecz/mautic/issues/events{/number}","events_url":"https://api.github.com/repos/escopecz/mautic/events","assignees_url":"https://api.github.com/repos/escopecz/mautic/assignees{/user}","branches_url":"https://api.github.com/repos/escopecz/mautic/branches{/branch}","tags_url":"https://api.github.com/repos/escopecz/mautic/tags","blobs_url":"https://api.github.com/repos/escopecz/mautic/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/escopecz/mautic/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/escopecz/mautic/git/refs{/sha}","trees_url":"https://api.github.com/repos/escopecz/mautic/git/trees{/sha}","statuses_url":"https://api.github.com/repos/escopecz/mautic/statuses/{sha}","languages_url":"https://api.github.com/repos/escopecz/mautic/languages","stargazers_url":"https://api.github.com/repos/escopecz/mautic/stargazers","contributors_url":"https://api.github.com/repos/escopecz/mautic/contributors","subscribers_url":"https://api.github.com/repos/escopecz/mautic/subscribers","subscription_url":"https://api.github.com/repos/escopecz/mautic/subscription","commits_url":"https://api.github.com/repos/escopecz/mautic/commits{/sha}","git_commits_url":"https://api.github.com/repos/escopecz/mautic/git/commits{/sha}","comments_url":"https://api.github.com/repos/escopecz/mautic/comments{/number}","issue_comment_url":"https://api.github.com/repos/escopecz/mautic/issues/comments{/number}","contents_url":"https://api.github.com/repos/escopecz/mautic/contents/{+path}","compare_url":"https://api.github.com/repos/escopecz/mautic/compare/{base}...{head}","merges_url":"https://api.github.com/repos/escopecz/mautic/merges","archive_url":"https://api.github.com/repos/escopecz/mautic/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/escopecz/mautic/downloads","issues_url":"https://api.github.com/repos/escopecz/mautic/issues{/number}","pulls_url":"https://api.github.com/repos/escopecz/mautic/pulls{/number}","milestones_url":"https://api.github.com/repos/escopecz/mautic/milestones{/number}","notifications_url":"https://api.github.com/repos/escopecz/mautic/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/escopecz/mautic/labels{/name}","releases_url":"https://api.github.com/repos/escopecz/mautic/releases{/id}","deployments_url":"https://api.github.com/repos/escopecz/mautic/deployments","created_at":"2015-02-23T09:52:24Z","updated_at":"2015-03-09T14:56:38Z","pushed_at":"2018-06-06T12:30:56Z","git_url":"git://github.com/escopecz/mautic.git","ssh_url":"git@github.com:escopecz/mautic.git","clone_url":"https://github.com/escopecz/mautic.git","svn_url":"https://github.com/escopecz/mautic","homepage":"http://mautic.org","size":81089,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"mautic:staging","ref":"staging","sha":"3a6010cb7aa1542f36b87cad81a878de89f1db84","user":{"login":"mautic","id":5257677,"node_id":"MDEyOk9yZ2FuaXphdGlvbjUyNTc2Nzc=","avatar_url":"https://avatars0.githubusercontent.com/u/5257677?v=4","gravatar_id":"","url":"https://api.github.com/users/mautic","html_url":"https://github.com/mautic","followers_url":"https://api.github.com/users/mautic/followers","following_url":"https://api.github.com/users/mautic/following{/other_user}","gists_url":"https://api.github.com/users/mautic/gists{/gist_id}","starred_url":"https://api.github.com/users/mautic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mautic/subscriptions","organizations_url":"https://api.github.com/users/mautic/orgs","repos_url":"https://api.github.com/users/mautic/repos","events_url":"https://api.github.com/users/mautic/events{/privacy}","received_events_url":"https://api.github.com/users/mautic/received_events","type":"Organization","site_admin":false},"repo":{"id":12204147,"node_id":"MDEwOlJlcG9zaXRvcnkxMjIwNDE0Nw==","name":"mautic","full_name":"mautic/mautic","owner":{"login":"mautic","id":5257677,"node_id":"MDEyOk9yZ2FuaXphdGlvbjUyNTc2Nzc=","avatar_url":"https://avatars0.githubusercontent.com/u/5257677?v=4","gravatar_id":"","url":"https://api.github.com/users/mautic","html_url":"https://github.com/mautic","followers_url":"https://api.github.com/users/mautic/followers","following_url":"https://api.github.com/users/mautic/following{/other_user}","gists_url":"https://api.github.com/users/mautic/gists{/gist_id}","starred_url":"https://api.github.com/users/mautic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mautic/subscriptions","organizations_url":"https://api.github.com/users/mautic/orgs","repos_url":"https://api.github.com/users/mautic/repos","events_url":"https://api.github.com/users/mautic/events{/privacy}","received_events_url":"https://api.github.com/users/mautic/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/mautic/mautic","description":"Mautic: Open Source Marketing Automation Software.","fork":false,"url":"https://api.github.com/repos/mautic/mautic","forks_url":"https://api.github.com/repos/mautic/mautic/forks","keys_url":"https://api.github.com/repos/mautic/mautic/keys{/key_id}","collaborators_url":"https://api.github.com/repos/mautic/mautic/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/mautic/mautic/teams","hooks_url":"https://api.github.com/repos/mautic/mautic/hooks","issue_events_url":"https://api.github.com/repos/mautic/mautic/issues/events{/number}","events_url":"https://api.github.com/repos/mautic/mautic/events","assignees_url":"https://api.github.com/repos/mautic/mautic/assignees{/user}","branches_url":"https://api.github.com/repos/mautic/mautic/branches{/branch}","tags_url":"https://api.github.com/repos/mautic/mautic/tags","blobs_url":"https://api.github.com/repos/mautic/mautic/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/mautic/mautic/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/mautic/mautic/git/refs{/sha}","trees_url":"https://api.github.com/repos/mautic/mautic/git/trees{/sha}","statuses_url":"https://api.github.com/repos/mautic/mautic/statuses/{sha}","languages_url":"https://api.github.com/repos/mautic/mautic/languages","stargazers_url":"https://api.github.com/repos/mautic/mautic/stargazers","contributors_url":"https://api.github.com/repos/mautic/mautic/contributors","subscribers_url":"https://api.github.com/repos/mautic/mautic/subscribers","subscription_url":"https://api.github.com/repos/mautic/mautic/subscription","commits_url":"https://api.github.com/repos/mautic/mautic/commits{/sha}","git_commits_url":"https://api.github.com/repos/mautic/mautic/git/commits{/sha}","comments_url":"https://api.github.com/repos/mautic/mautic/comments{/number}","issue_comment_url":"https://api.github.com/repos/mautic/mautic/issues/comments{/number}","contents_url":"https://api.github.com/repos/mautic/mautic/contents/{+path}","compare_url":"https://api.github.com/repos/mautic/mautic/compare/{base}...{head}","merges_url":"https://api.github.com/repos/mautic/mautic/merges","archive_url":"https://api.github.com/repos/mautic/mautic/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/mautic/mautic/downloads","issues_url":"https://api.github.com/repos/mautic/mautic/issues{/number}","pulls_url":"https://api.github.com/repos/mautic/mautic/pulls{/number}","milestones_url":"https://api.github.com/repos/mautic/mautic/milestones{/number}","notifications_url":"https://api.github.com/repos/mautic/mautic/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/mautic/mautic/labels{/name}","releases_url":"https://api.github.com/repos/mautic/mautic/releases{/id}","deployments_url":"https://api.github.com/repos/mautic/mautic/deployments","created_at":"2013-08-19T00:36:28Z","updated_at":"2018-06-05T14:49:14Z","pushed_at":"2018-06-06T09:22:22Z","git_url":"git://github.com/mautic/mautic.git","ssh_url":"git@github.com:mautic/mautic.git","clone_url":"https://github.com/mautic/mautic.git","svn_url":"https://github.com/mautic/mautic","homepage":"https://www.mautic.org","size":80916,"stargazers_count":2433,"watchers_count":2433,"language":"PHP","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":915,"mirror_url":null,"archived":false,"open_issues_count":631,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":915,"open_issues":631,"watchers":2433,"default_branch":"staging"}},"_links":{"self":{"href":"https://api.github.com/repos/mautic/mautic/pulls/6173"},"html":{"href":"https://github.com/mautic/mautic/pull/6173"},"issue":{"href":"https://api.github.com/repos/mautic/mautic/issues/6173"},"comments":{"href":"https://api.github.com/repos/mautic/mautic/issues/6173/comments"},"review_comments":{"href":"https://api.github.com/repos/mautic/mautic/pulls/6173/comments"},"review_comment":{"href":"https://api.github.com/repos/mautic/mautic/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/mautic/mautic/pulls/6173/commits"},"statuses":{"href":"https://api.github.com/repos/mautic/mautic/statuses/080a19854e5d10cf7a7ae6c64d399cd591158739"}},"author_association":"CONTRIBUTOR","merged":false,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":null,"comments":0,"review_comments":0,"maintainer_can_modify":true,"commits":1,"additions":20,"deletions":2,"changed_files":2}}
{"actor":{"display_login":"escopecz"}}