{"action":"created","comment":{"url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/pulls/comments/24488324","id":24488324,"diff_hunk":"@@ -2605,17 +2599,14 @@ def getGroupsMemberOf(self):\n         :rtype:         :class:`ExperimenterGroupWrapper` generator\n         \"\"\"\n \n-        q = self.getQueryService()\n-        p = omero.sys.Parameters()\n-        p.map = {}\n-        p.map[\"ids\"] = rlist([rlong(a)\n-                              for a in self.getEventContext().memberOfGroups])\n-        sql = \"select e from ExperimenterGroup as e where e.id in (:ids)\"\n-        for e in q.findAllByQuery(sql, p, self.SERVICE_OPTS):\n-            if e.name.val == \"user\":","path":"components/tools/OmeroPy/src/omero/gateway/__init__.py","position":28,"original_position":28,"commit_id":"96f6580312b7c9661ea94b6a1334358a5e0b6142","original_commit_id":"96f6580312b7c9661ea94b6a1334358a5e0b6142","user":{"login":"will-moore","id":900055,"avatar_url":"https://avatars.githubusercontent.com/u/900055?v=3","gravatar_id":"","url":"https://api.github.com/users/will-moore","html_url":"https://github.com/will-moore","followers_url":"https://api.github.com/users/will-moore/followers","following_url":"https://api.github.com/users/will-moore/following{/other_user}","gists_url":"https://api.github.com/users/will-moore/gists{/gist_id}","starred_url":"https://api.github.com/users/will-moore/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/will-moore/subscriptions","organizations_url":"https://api.github.com/users/will-moore/orgs","repos_url":"https://api.github.com/users/will-moore/repos","events_url":"https://api.github.com/users/will-moore/events{/privacy}","received_events_url":"https://api.github.com/users/will-moore/received_events","type":"User","site_admin":false},"body":"@aleksandra-tarkowska Probably it's simply that users are not leaders of the ```user``` group, so we never had the problem of ```user``` group showing up in that query. I think it makes sense to unify it.","created_at":"2015-02-11T11:26:35Z","updated_at":"2015-02-11T11:26:35Z","html_url":"https://github.com/openmicroscopy/openmicroscopy/pull/3478#discussion_r24488324","pull_request_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/pulls/3478","_links":{"self":{"href":"https://api.github.com/repos/openmicroscopy/openmicroscopy/pulls/comments/24488324"},"html":{"href":"https://github.com/openmicroscopy/openmicroscopy/pull/3478#discussion_r24488324"},"pull_request":{"href":"https://api.github.com/repos/openmicroscopy/openmicroscopy/pulls/3478"}}},"pull_request":{"url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/pulls/3478","id":29083224,"html_url":"https://github.com/openmicroscopy/openmicroscopy/pull/3478","diff_url":"https://github.com/openmicroscopy/openmicroscopy/pull/3478.diff","patch_url":"https://github.com/openmicroscopy/openmicroscopy/pull/3478.patch","issue_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/issues/3478","number":3478,"state":"open","locked":false,"title":"Group user menu speed up","user":{"login":"aleksandra-tarkowska","id":1065155,"avatar_url":"https://avatars.githubusercontent.com/u/1065155?v=3","gravatar_id":"","url":"https://api.github.com/users/aleksandra-tarkowska","html_url":"https://github.com/aleksandra-tarkowska","followers_url":"https://api.github.com/users/aleksandra-tarkowska/followers","following_url":"https://api.github.com/users/aleksandra-tarkowska/following{/other_user}","gists_url":"https://api.github.com/users/aleksandra-tarkowska/gists{/gist_id}","starred_url":"https://api.github.com/users/aleksandra-tarkowska/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aleksandra-tarkowska/subscriptions","organizations_url":"https://api.github.com/users/aleksandra-tarkowska/orgs","repos_url":"https://api.github.com/users/aleksandra-tarkowska/repos","events_url":"https://api.github.com/users/aleksandra-tarkowska/events{/privacy}","received_events_url":"https://api.github.com/users/aleksandra-tarkowska/received_events","type":"User","site_admin":false},"body":"This PR speeds up loading of group user menu in Web. Previously on each group there were additional calls loading user map. Now it is improved and entire list is loaded at once.\r\n\r\nTo test:\r\n - click on group user many and see in Firebug how fast it loads\r\n\r\ncc: @pwalczysko \r\n\r\nPetr On trout now 2:30 min should be reduced to 2.40 sec. I hope that will help","created_at":"2015-02-11T11:18:49Z","updated_at":"2015-02-11T11:26:35Z","closed_at":null,"merged_at":null,"merge_commit_sha":"b01e17f57683657071926100dfa626e66d4abff4","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/pulls/3478/commits","review_comments_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/pulls/3478/comments","review_comment_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/pulls/comments/{number}","comments_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/issues/3478/comments","statuses_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/statuses/96f6580312b7c9661ea94b6a1334358a5e0b6142","head":{"label":"aleksandra-tarkowska:group_user_list","ref":"group_user_list","sha":"96f6580312b7c9661ea94b6a1334358a5e0b6142","user":{"login":"aleksandra-tarkowska","id":1065155,"avatar_url":"https://avatars.githubusercontent.com/u/1065155?v=3","gravatar_id":"","url":"https://api.github.com/users/aleksandra-tarkowska","html_url":"https://github.com/aleksandra-tarkowska","followers_url":"https://api.github.com/users/aleksandra-tarkowska/followers","following_url":"https://api.github.com/users/aleksandra-tarkowska/following{/other_user}","gists_url":"https://api.github.com/users/aleksandra-tarkowska/gists{/gist_id}","starred_url":"https://api.github.com/users/aleksandra-tarkowska/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aleksandra-tarkowska/subscriptions","organizations_url":"https://api.github.com/users/aleksandra-tarkowska/orgs","repos_url":"https://api.github.com/users/aleksandra-tarkowska/repos","events_url":"https://api.github.com/users/aleksandra-tarkowska/events{/privacy}","received_events_url":"https://api.github.com/users/aleksandra-tarkowska/received_events","type":"User","site_admin":false},"repo":{"id":2422748,"name":"openmicroscopy","full_name":"aleksandra-tarkowska/openmicroscopy","owner":{"login":"aleksandra-tarkowska","id":1065155,"avatar_url":"https://avatars.githubusercontent.com/u/1065155?v=3","gravatar_id":"","url":"https://api.github.com/users/aleksandra-tarkowska","html_url":"https://github.com/aleksandra-tarkowska","followers_url":"https://api.github.com/users/aleksandra-tarkowska/followers","following_url":"https://api.github.com/users/aleksandra-tarkowska/following{/other_user}","gists_url":"https://api.github.com/users/aleksandra-tarkowska/gists{/gist_id}","starred_url":"https://api.github.com/users/aleksandra-tarkowska/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/aleksandra-tarkowska/subscriptions","organizations_url":"https://api.github.com/users/aleksandra-tarkowska/orgs","repos_url":"https://api.github.com/users/aleksandra-tarkowska/repos","events_url":"https://api.github.com/users/aleksandra-tarkowska/events{/privacy}","received_events_url":"https://api.github.com/users/aleksandra-tarkowska/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/aleksandra-tarkowska/openmicroscopy","description":"OME (Open Microscopy Environment) develops open-source software and data format standards for the storage and manipulation of biological light microscopy data. A joint project between universities, research establishments and industry in Europe and the USA, OME has over 20 active researchers with strong links to the microscopy community. Funded by private and public research grants, OME has been a major force on the international microscopy stage since 2000.","fork":true,"url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy","forks_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/forks","keys_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/keys{/key_id}","collaborators_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/teams","hooks_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/hooks","issue_events_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/issues/events{/number}","events_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/events","assignees_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/assignees{/user}","branches_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/branches{/branch}","tags_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/tags","blobs_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/git/refs{/sha}","trees_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/git/trees{/sha}","statuses_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/statuses/{sha}","languages_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/languages","stargazers_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/stargazers","contributors_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/contributors","subscribers_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/subscribers","subscription_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/subscription","commits_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/commits{/sha}","git_commits_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/git/commits{/sha}","comments_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/comments{/number}","issue_comment_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/issues/comments/{number}","contents_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/contents/{+path}","compare_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/compare/{base}...{head}","merges_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/merges","archive_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/downloads","issues_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/issues{/number}","pulls_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/pulls{/number}","milestones_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/milestones{/number}","notifications_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/labels{/name}","releases_url":"https://api.github.com/repos/aleksandra-tarkowska/openmicroscopy/releases{/id}","created_at":"2011-09-20T14:10:30Z","updated_at":"2014-06-25T10:10:35Z","pushed_at":"2015-02-11T11:16:56Z","git_url":"git://github.com/aleksandra-tarkowska/openmicroscopy.git","ssh_url":"git@github.com:aleksandra-tarkowska/openmicroscopy.git","clone_url":"https://github.com/aleksandra-tarkowska/openmicroscopy.git","svn_url":"https://github.com/aleksandra-tarkowska/openmicroscopy","homepage":"http://www.openmicroscopy.org","size":2084306,"stargazers_count":1,"watchers_count":1,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":1,"default_branch":"develop"}},"base":{"label":"openmicroscopy:develop","ref":"develop","sha":"05665f47ebff840627e79c7ae5ce3a840df2f8d7","user":{"login":"openmicroscopy","id":975861,"avatar_url":"https://avatars.githubusercontent.com/u/975861?v=3","gravatar_id":"","url":"https://api.github.com/users/openmicroscopy","html_url":"https://github.com/openmicroscopy","followers_url":"https://api.github.com/users/openmicroscopy/followers","following_url":"https://api.github.com/users/openmicroscopy/following{/other_user}","gists_url":"https://api.github.com/users/openmicroscopy/gists{/gist_id}","starred_url":"https://api.github.com/users/openmicroscopy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/openmicroscopy/subscriptions","organizations_url":"https://api.github.com/users/openmicroscopy/orgs","repos_url":"https://api.github.com/users/openmicroscopy/repos","events_url":"https://api.github.com/users/openmicroscopy/events{/privacy}","received_events_url":"https://api.github.com/users/openmicroscopy/received_events","type":"Organization","site_admin":false},"repo":{"id":2228226,"name":"openmicroscopy","full_name":"openmicroscopy/openmicroscopy","owner":{"login":"openmicroscopy","id":975861,"avatar_url":"https://avatars.githubusercontent.com/u/975861?v=3","gravatar_id":"","url":"https://api.github.com/users/openmicroscopy","html_url":"https://github.com/openmicroscopy","followers_url":"https://api.github.com/users/openmicroscopy/followers","following_url":"https://api.github.com/users/openmicroscopy/following{/other_user}","gists_url":"https://api.github.com/users/openmicroscopy/gists{/gist_id}","starred_url":"https://api.github.com/users/openmicroscopy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/openmicroscopy/subscriptions","organizations_url":"https://api.github.com/users/openmicroscopy/orgs","repos_url":"https://api.github.com/users/openmicroscopy/repos","events_url":"https://api.github.com/users/openmicroscopy/events{/privacy}","received_events_url":"https://api.github.com/users/openmicroscopy/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/openmicroscopy/openmicroscopy","description":"OME (Open Microscopy Environment) develops open-source software and data format standards for the storage and manipulation of biological light microscopy data. A joint project between universities, research establishments and industry in Europe and the USA, OME has over 20 active researchers with strong links to the microscopy community. Funded by private and public research grants, OME has been a major force on the international microscopy stage since 2000.","fork":false,"url":"https://api.github.com/repos/openmicroscopy/openmicroscopy","forks_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/forks","keys_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/keys{/key_id}","collaborators_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/teams","hooks_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/hooks","issue_events_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/issues/events{/number}","events_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/events","assignees_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/assignees{/user}","branches_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/branches{/branch}","tags_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/tags","blobs_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/git/refs{/sha}","trees_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/git/trees{/sha}","statuses_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/statuses/{sha}","languages_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/languages","stargazers_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/stargazers","contributors_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/contributors","subscribers_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/subscribers","subscription_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/subscription","commits_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/commits{/sha}","git_commits_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/git/commits{/sha}","comments_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/comments{/number}","issue_comment_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/issues/comments/{number}","contents_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/contents/{+path}","compare_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/compare/{base}...{head}","merges_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/merges","archive_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/downloads","issues_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/issues{/number}","pulls_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/pulls{/number}","milestones_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/milestones{/number}","notifications_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/labels{/name}","releases_url":"https://api.github.com/repos/openmicroscopy/openmicroscopy/releases{/id}","created_at":"2011-08-18T14:26:02Z","updated_at":"2015-02-11T07:47:02Z","pushed_at":"2015-02-11T07:47:02Z","git_url":"git://github.com/openmicroscopy/openmicroscopy.git","ssh_url":"git@github.com:openmicroscopy/openmicroscopy.git","clone_url":"https://github.com/openmicroscopy/openmicroscopy.git","svn_url":"https://github.com/openmicroscopy/openmicroscopy","homepage":"http://www.openmicroscopy.org","size":2145989,"stargazers_count":63,"watchers_count":63,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":61,"mirror_url":null,"open_issues_count":41,"forks":61,"open_issues":41,"watchers":63,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/openmicroscopy/openmicroscopy/pulls/3478"},"html":{"href":"https://github.com/openmicroscopy/openmicroscopy/pull/3478"},"issue":{"href":"https://api.github.com/repos/openmicroscopy/openmicroscopy/issues/3478"},"comments":{"href":"https://api.github.com/repos/openmicroscopy/openmicroscopy/issues/3478/comments"},"review_comments":{"href":"https://api.github.com/repos/openmicroscopy/openmicroscopy/pulls/3478/comments"},"review_comment":{"href":"https://api.github.com/repos/openmicroscopy/openmicroscopy/pulls/comments/{number}"},"commits":{"href":"https://api.github.com/repos/openmicroscopy/openmicroscopy/pulls/3478/commits"},"statuses":{"href":"https://api.github.com/repos/openmicroscopy/openmicroscopy/statuses/96f6580312b7c9661ea94b6a1334358a5e0b6142"}}}}