{"action":"closed","number":6289,"pull_request":{"url":"https://api.github.com/repos/mautic/mautic/pulls/6289","id":199301582,"node_id":"MDExOlB1bGxSZXF1ZXN0MTk5MzAxNTgy","html_url":"https://github.com/mautic/mautic/pull/6289","diff_url":"https://github.com/mautic/mautic/pull/6289.diff","patch_url":"https://github.com/mautic/mautic/pull/6289.patch","issue_url":"https://api.github.com/repos/mautic/mautic/issues/6289","number":6289,"state":"closed","locked":false,"title":"Added new GROUP_CONCAT function to reports","user":{"login":"kuzmany","id":462477,"node_id":"MDQ6VXNlcjQ2MjQ3Nw==","avatar_url":"https://avatars1.githubusercontent.com/u/462477?v=4","gravatar_id":"","url":"https://api.github.com/users/kuzmany","html_url":"https://github.com/kuzmany","followers_url":"https://api.github.com/users/kuzmany/followers","following_url":"https://api.github.com/users/kuzmany/following{/other_user}","gists_url":"https://api.github.com/users/kuzmany/gists{/gist_id}","starred_url":"https://api.github.com/users/kuzmany/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kuzmany/subscriptions","organizations_url":"https://api.github.com/users/kuzmany/orgs","repos_url":"https://api.github.com/users/kuzmany/repos","events_url":"https://api.github.com/users/kuzmany/events{/privacy}","received_events_url":"https://api.github.com/users/kuzmany/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? | \r\n| New feature? | \r\n| Automated tests included? |\r\n| Related user documentation PR URL | \r\n| Related developer documentation PR URL | \r\n| Issues addressed (#s or URLs) | https://github.com/mautic/mautic/issues/6198\r\n| BC breaks? | \r\n| Deprecations? | \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\nBased on this issue https://github.com/mautic/mautic/issues/6198 \r\nReports with join tables and multiple results give multiple rows for on contact.\r\nThis PR added GROUP_CONCAT function allow add column with coma separated results in one row (for example companies to one line to concat)\r\nMore https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html#function_group-concat\r\n\r\nBefore\r\n\r\n![image](https://user-images.githubusercontent.com/462477/42289638-0a94a9c8-7fc1-11e8-93b8-0ca4a40a85f2.png)\r\n\r\nAfter\r\n![image](https://user-images.githubusercontent.com/462477/42289662-38575b6c-7fc1-11e8-93cc-ece3eef9c149.png)\r\n\r\n#### Steps to test this PR:\r\n1. Create contact with two or more assign companies and submit form with his ID\r\n2.  Create form submisision report\r\n3.  Setup like me on screenshot\r\n\r\n![image](https://user-images.githubusercontent.com/462477/42289685-5695b20e-7fc1-11e8-8dac-6b31308db633.png)\r\n\r\n4. Expect this column (separated values with comma)\r\n![image](https://user-images.githubusercontent.com/462477/42289700-6ac6f6d4-7fc1-11e8-92a7-4120e2a7ab6a.png)\r\n\r\n\r\n","created_at":"2018-07-04T17:33:33Z","updated_at":"2018-09-04T21:59:03Z","closed_at":"2018-09-04T21:59:03Z","merged_at":"2018-09-04T21:59:03Z","merge_commit_sha":"70e5c45b0e132b786040932eb8ea1d2ace842107","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[{"id":810138820,"node_id":"MDU6TGFiZWw4MTAxMzg4MjA=","url":"https://api.github.com/repos/mautic/mautic/labels/Enhancement","name":"Enhancement","color":"2037aa","default":false},{"id":185161473,"node_id":"MDU6TGFiZWwxODUxNjE0NzM=","url":"https://api.github.com/repos/mautic/mautic/labels/Ready%20To%20Commit","name":"Ready To Commit","color":"60b044","default":false}],"milestone":{"url":"https://api.github.com/repos/mautic/mautic/milestones/47","html_url":"https://github.com/mautic/mautic/milestone/47","labels_url":"https://api.github.com/repos/mautic/mautic/milestones/47/labels","id":3468100,"node_id":"MDk6TWlsZXN0b25lMzQ2ODEwMA==","number":47,"title":"2.14.1","description":"","creator":{"login":"dbhurley","id":5251425,"node_id":"MDQ6VXNlcjUyNTE0MjU=","avatar_url":"https://avatars1.githubusercontent.com/u/5251425?v=4","gravatar_id":"","url":"https://api.github.com/users/dbhurley","html_url":"https://github.com/dbhurley","followers_url":"https://api.github.com/users/dbhurley/followers","following_url":"https://api.github.com/users/dbhurley/following{/other_user}","gists_url":"https://api.github.com/users/dbhurley/gists{/gist_id}","starred_url":"https://api.github.com/users/dbhurley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dbhurley/subscriptions","organizations_url":"https://api.github.com/users/dbhurley/orgs","repos_url":"https://api.github.com/users/dbhurley/repos","events_url":"https://api.github.com/users/dbhurley/events{/privacy}","received_events_url":"https://api.github.com/users/dbhurley/received_events","type":"User","site_admin":false},"open_issues":38,"closed_issues":63,"state":"open","created_at":"2018-07-02T18:33:47Z","updated_at":"2018-09-04T21:59:03Z","due_on":"2018-08-17T07:00:00Z","closed_at":null},"commits_url":"https://api.github.com/repos/mautic/mautic/pulls/6289/commits","review_comments_url":"https://api.github.com/repos/mautic/mautic/pulls/6289/comments","review_comment_url":"https://api.github.com/repos/mautic/mautic/pulls/comments{/number}","comments_url":"https://api.github.com/repos/mautic/mautic/issues/6289/comments","statuses_url":"https://api.github.com/repos/mautic/mautic/statuses/b6c2ee811b89b07b5135566ea645bd81b875625d","head":{"label":"kuzmany:fix-reports-duplicate-with-company-submissions","ref":"fix-reports-duplicate-with-company-submissions","sha":"b6c2ee811b89b07b5135566ea645bd81b875625d","user":{"login":"kuzmany","id":462477,"node_id":"MDQ6VXNlcjQ2MjQ3Nw==","avatar_url":"https://avatars1.githubusercontent.com/u/462477?v=4","gravatar_id":"","url":"https://api.github.com/users/kuzmany","html_url":"https://github.com/kuzmany","followers_url":"https://api.github.com/users/kuzmany/followers","following_url":"https://api.github.com/users/kuzmany/following{/other_user}","gists_url":"https://api.github.com/users/kuzmany/gists{/gist_id}","starred_url":"https://api.github.com/users/kuzmany/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kuzmany/subscriptions","organizations_url":"https://api.github.com/users/kuzmany/orgs","repos_url":"https://api.github.com/users/kuzmany/repos","events_url":"https://api.github.com/users/kuzmany/events{/privacy}","received_events_url":"https://api.github.com/users/kuzmany/received_events","type":"User","site_admin":false},"repo":{"id":53777141,"node_id":"MDEwOlJlcG9zaXRvcnk1Mzc3NzE0MQ==","name":"mautic","full_name":"kuzmany/mautic","owner":{"login":"kuzmany","id":462477,"node_id":"MDQ6VXNlcjQ2MjQ3Nw==","avatar_url":"https://avatars1.githubusercontent.com/u/462477?v=4","gravatar_id":"","url":"https://api.github.com/users/kuzmany","html_url":"https://github.com/kuzmany","followers_url":"https://api.github.com/users/kuzmany/followers","following_url":"https://api.github.com/users/kuzmany/following{/other_user}","gists_url":"https://api.github.com/users/kuzmany/gists{/gist_id}","starred_url":"https://api.github.com/users/kuzmany/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kuzmany/subscriptions","organizations_url":"https://api.github.com/users/kuzmany/orgs","repos_url":"https://api.github.com/users/kuzmany/repos","events_url":"https://api.github.com/users/kuzmany/events{/privacy}","received_events_url":"https://api.github.com/users/kuzmany/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/kuzmany/mautic","description":"Mautic: Open Source Marketing Automation Software.","fork":true,"url":"https://api.github.com/repos/kuzmany/mautic","forks_url":"https://api.github.com/repos/kuzmany/mautic/forks","keys_url":"https://api.github.com/repos/kuzmany/mautic/keys{/key_id}","collaborators_url":"https://api.github.com/repos/kuzmany/mautic/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/kuzmany/mautic/teams","hooks_url":"https://api.github.com/repos/kuzmany/mautic/hooks","issue_events_url":"https://api.github.com/repos/kuzmany/mautic/issues/events{/number}","events_url":"https://api.github.com/repos/kuzmany/mautic/events","assignees_url":"https://api.github.com/repos/kuzmany/mautic/assignees{/user}","branches_url":"https://api.github.com/repos/kuzmany/mautic/branches{/branch}","tags_url":"https://api.github.com/repos/kuzmany/mautic/tags","blobs_url":"https://api.github.com/repos/kuzmany/mautic/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/kuzmany/mautic/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/kuzmany/mautic/git/refs{/sha}","trees_url":"https://api.github.com/repos/kuzmany/mautic/git/trees{/sha}","statuses_url":"https://api.github.com/repos/kuzmany/mautic/statuses/{sha}","languages_url":"https://api.github.com/repos/kuzmany/mautic/languages","stargazers_url":"https://api.github.com/repos/kuzmany/mautic/stargazers","contributors_url":"https://api.github.com/repos/kuzmany/mautic/contributors","subscribers_url":"https://api.github.com/repos/kuzmany/mautic/subscribers","subscription_url":"https://api.github.com/repos/kuzmany/mautic/subscription","commits_url":"https://api.github.com/repos/kuzmany/mautic/commits{/sha}","git_commits_url":"https://api.github.com/repos/kuzmany/mautic/git/commits{/sha}","comments_url":"https://api.github.com/repos/kuzmany/mautic/comments{/number}","issue_comment_url":"https://api.github.com/repos/kuzmany/mautic/issues/comments{/number}","contents_url":"https://api.github.com/repos/kuzmany/mautic/contents/{+path}","compare_url":"https://api.github.com/repos/kuzmany/mautic/compare/{base}...{head}","merges_url":"https://api.github.com/repos/kuzmany/mautic/merges","archive_url":"https://api.github.com/repos/kuzmany/mautic/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/kuzmany/mautic/downloads","issues_url":"https://api.github.com/repos/kuzmany/mautic/issues{/number}","pulls_url":"https://api.github.com/repos/kuzmany/mautic/pulls{/number}","milestones_url":"https://api.github.com/repos/kuzmany/mautic/milestones{/number}","notifications_url":"https://api.github.com/repos/kuzmany/mautic/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/kuzmany/mautic/labels{/name}","releases_url":"https://api.github.com/repos/kuzmany/mautic/releases{/id}","deployments_url":"https://api.github.com/repos/kuzmany/mautic/deployments","created_at":"2016-03-13T09:29:51Z","updated_at":"2018-04-10T09:15:20Z","pushed_at":"2018-09-04T21:58:40Z","git_url":"git://github.com/kuzmany/mautic.git","ssh_url":"git@github.com:kuzmany/mautic.git","clone_url":"https://github.com/kuzmany/mautic.git","svn_url":"https://github.com/kuzmany/mautic","homepage":"https://www.mautic.org","size":84145,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":1,"mirror_url":null,"archived":false,"open_issues_count":0,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":1,"open_issues":0,"watchers":0,"default_branch":"staging"}},"base":{"label":"mautic:staging","ref":"staging","sha":"729fa25e276d233c495c6de743279cf9078642e8","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-09-04T21:57:49Z","pushed_at":"2018-09-04T21:59:03Z","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":82121,"stargazers_count":2593,"watchers_count":2593,"language":"PHP","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":963,"mirror_url":null,"archived":false,"open_issues_count":751,"license":{"key":"other","name":"Other","spdx_id":null,"url":null,"node_id":"MDc6TGljZW5zZTA="},"forks":963,"open_issues":751,"watchers":2593,"default_branch":"staging"}},"_links":{"self":{"href":"https://api.github.com/repos/mautic/mautic/pulls/6289"},"html":{"href":"https://github.com/mautic/mautic/pull/6289"},"issue":{"href":"https://api.github.com/repos/mautic/mautic/issues/6289"},"comments":{"href":"https://api.github.com/repos/mautic/mautic/issues/6289/comments"},"review_comments":{"href":"https://api.github.com/repos/mautic/mautic/pulls/6289/comments"},"review_comment":{"href":"https://api.github.com/repos/mautic/mautic/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/mautic/mautic/pulls/6289/commits"},"statuses":{"href":"https://api.github.com/repos/mautic/mautic/statuses/b6c2ee811b89b07b5135566ea645bd81b875625d"}},"author_association":"CONTRIBUTOR","merged":true,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":{"login":"heathdutton","id":302215,"node_id":"MDQ6VXNlcjMwMjIxNQ==","avatar_url":"https://avatars1.githubusercontent.com/u/302215?v=4","gravatar_id":"","url":"https://api.github.com/users/heathdutton","html_url":"https://github.com/heathdutton","followers_url":"https://api.github.com/users/heathdutton/followers","following_url":"https://api.github.com/users/heathdutton/following{/other_user}","gists_url":"https://api.github.com/users/heathdutton/gists{/gist_id}","starred_url":"https://api.github.com/users/heathdutton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/heathdutton/subscriptions","organizations_url":"https://api.github.com/users/heathdutton/orgs","repos_url":"https://api.github.com/users/heathdutton/repos","events_url":"https://api.github.com/users/heathdutton/events{/privacy}","received_events_url":"https://api.github.com/users/heathdutton/received_events","type":"User","site_admin":false},"comments":1,"review_comments":0,"maintainer_can_modify":false,"commits":10,"additions":13,"deletions":5,"changed_files":4}}
{"actor":{"display_login":"heathdutton"}}