{"action":"created","issue":{"url":"https://api.github.com/repos/civicrm/civicrm-core/issues/12803","repository_url":"https://api.github.com/repos/civicrm/civicrm-core","labels_url":"https://api.github.com/repos/civicrm/civicrm-core/issues/12803/labels{/name}","comments_url":"https://api.github.com/repos/civicrm/civicrm-core/issues/12803/comments","events_url":"https://api.github.com/repos/civicrm/civicrm-core/issues/12803/events","html_url":"https://github.com/civicrm/civicrm-core/pull/12803","id":359290107,"node_id":"MDExOlB1bGxSZXF1ZXN0MjE0ODE3MDE3","number":12803,"title":"Handle smart groups created in previous Civi's which include relation_permission","user":{"login":"highfalutin","id":385812,"node_id":"MDQ6VXNlcjM4NTgxMg==","avatar_url":"https://avatars2.githubusercontent.com/u/385812?v=4","gravatar_id":"","url":"https://api.github.com/users/highfalutin","html_url":"https://github.com/highfalutin","followers_url":"https://api.github.com/users/highfalutin/followers","following_url":"https://api.github.com/users/highfalutin/following{/other_user}","gists_url":"https://api.github.com/users/highfalutin/gists{/gist_id}","starred_url":"https://api.github.com/users/highfalutin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/highfalutin/subscriptions","organizations_url":"https://api.github.com/users/highfalutin/orgs","repos_url":"https://api.github.com/users/highfalutin/repos","events_url":"https://api.github.com/users/highfalutin/events{/privacy}","received_events_url":"https://api.github.com/users/highfalutin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-09-12T02:19:20Z","updated_at":"2018-09-12T02:35:55Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/civicrm/civicrm-core/pulls/12803","html_url":"https://github.com/civicrm/civicrm-core/pull/12803","diff_url":"https://github.com/civicrm/civicrm-core/pull/12803.diff","patch_url":"https://github.com/civicrm/civicrm-core/pull/12803.patch"},"body":"Overview\r\n----------------------------------------\r\nFixes https://lab.civicrm.org/dev/core/issues/390: Smart groups created before 5.5.0 using \"relation_permission\" break on upgrade to 5.5.0\r\n\r\nBefore\r\n----------------------------------------\r\n* In Civi 5.4, create a smart group based on a relationship search.\r\n* Upgrade to 5.5, clear cache and try to open the group.\r\n* Error: DB Error: syntax error\r\n\r\nAfter\r\n----------------------------------------\r\n* In Civi 5.4, create a smart group based on a relationship search.\r\n* Upgrade to 5.5, clear cache and try to open the group.\r\n* Group opens as expected.\r\n\r\nTechnical Details\r\n----------------------------------------\r\nWhen you create a Smart Group for a relationship search, the form values which are saved include `relation_permission`. Prior to 5.5.0, the operator was \"=\" and the value was scalar. As of 5.5.0, the operator is \"IN\" and the value is an array."},"comment":{"url":"https://api.github.com/repos/civicrm/civicrm-core/issues/comments/420492098","html_url":"https://github.com/civicrm/civicrm-core/pull/12803#issuecomment-420492098","issue_url":"https://api.github.com/repos/civicrm/civicrm-core/issues/12803","id":420492098,"node_id":"MDEyOklzc3VlQ29tbWVudDQyMDQ5MjA5OA==","user":{"login":"highfalutin","id":385812,"node_id":"MDQ6VXNlcjM4NTgxMg==","avatar_url":"https://avatars2.githubusercontent.com/u/385812?v=4","gravatar_id":"","url":"https://api.github.com/users/highfalutin","html_url":"https://github.com/highfalutin","followers_url":"https://api.github.com/users/highfalutin/followers","following_url":"https://api.github.com/users/highfalutin/following{/other_user}","gists_url":"https://api.github.com/users/highfalutin/gists{/gist_id}","starred_url":"https://api.github.com/users/highfalutin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/highfalutin/subscriptions","organizations_url":"https://api.github.com/users/highfalutin/orgs","repos_url":"https://api.github.com/users/highfalutin/repos","events_url":"https://api.github.com/users/highfalutin/events{/privacy}","received_events_url":"https://api.github.com/users/highfalutin/received_events","type":"User","site_admin":false},"created_at":"2018-09-12T02:35:55Z","updated_at":"2018-09-12T02:35:55Z","author_association":"CONTRIBUTOR","body":"5.6 PR: https://github.com/civicrm/civicrm-core/pull/12804."}}
{"actor":{"display_login":"highfalutin"}}