SQL query using excel add-in

[Jason Hammond]

we basically need to retrieve all active items from our Jira instance ( not closed) for a specific group of employees and export to excel.  can anyone assist with or recommend how I could start this.

[Trudy Claspill]

Hello @Jason Hammond 

Are all the users defined in a user group or multiple user groups?

statusCategory!=Done and Assignee in membersOf(GroupName)

If you have multiple user groups then you would use ORs 

statusCategory!=Done and (Assignee in membersOf(GroupName) OR Assignee in membersOf(GroupName))

If you need to specify individual users then...

statusCategory!=Done and Assignee in (user1, user2, user3)

There is a limit of 10k items that can be exported through the UI for work item searches. If you need to export more than that you would do multiple searches with different criteria to get smaller results sets. Or, refer to this article:

https://confluence.atlassian.com/jirakb/export-over-1000-results-in-jira-cloud-779160833.html