JIRA: How to Select the user and groups mapping 获得用户与用户组关联列表

Categories: Development Notes; Tagged with: JIRA • SQL; @ May 28th, 2013 10:09

Requirement:

Export the users and group mapping list.

Solution:

Seems there’s no feature / plugins for this requirement. If you can access the database, then everything is easy:

SELECT member.[ID] ,[membership_type] ,[group_type] ,[parent_name] ,[lower_parent_name] ,[child_name] ,[lower_child_name] ,member.[directory_id], jira_user.display_name FROM [jiradb].[jiraschema].[cwd_membership] member left join [jiradb].[jiraschema].[cwd_user] jira_user ON member.child_name = jira_user.user_name order by parent_name

JIRA: Select Estimate and Actually Spent (Logged) Hours <-> The New Google Maps 新版Google地图