I need generate psql report contain the following information:
Project Name
User Name
Project Category
Project Lead
Project Permission Scheme
The report needs to ensure that it also identifies any additional users who have been added to a project, but not part of the permission group set up for that project.
Kindly help me with a PGSQL query to generate the same report.
I believe this has some of what you are looking for. https://confluence.atlassian.com/jirakb/retrieve-a-list-of-users-assigned-to-project-roles-in-jira-server-705954232.html
you could add p.lead to get project lead out of the project table.
You can combine that with this query to get category. https://confluence.atlassian.com/jirakb/how-to-list-all-projects-in-a-specific-project-category-781194603.html
I am not sure what table has the permission scheme.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.