JQL filter for open issues in all projects a user has worked on

[Thomas Gericke]

Hi there, I need help from a real expert in regards to Jira JQL filtering and/or ScriptRunner Extended Search.

What I am looking for is basically a filter that shows results based on:

1. currently logged in user

2. the projects he/she usually works on

3. issues in "To Do" status category

I know how to find the projects like e.g. assignee = currentUser() OR worklogAuthor = currentUser() OR commentedBy = currentUser().

I, of course, also know how to use statusCategory IN ("To Do") or similar.

Now, I am looking for a way to do something with a sub query like:

statusCategory IN ("To Do") AND project IN MyDesiredSubQuery(assignee = currentUser() OR worklogAuthor = currentUser() OR commentedBy = currentUser())

So far I've tried several ways to do it in native JQL and also with ScriptRunner Extended Search using projectMatch() but nothing works.

I am aware that JQL is not intended to deliver results for projects but for issues. Still I want to limit the number of results to just the projects the user usually works on.

In the end, I want to have ONE filter for ONE dashboard that works for all users in the organization and shows open and unhandled issues just for the projects they usually contribute to - not other projects.

How could that be done?

[Duc Thang TRAN]

Hello @Thomas Gericke 

After reading your description,
I think of a JQL like this:
statusCategory IN ("To Do") AND assignee = currentUser() AND (worklogAuthor = currentUser() OR commentedBy = currentUser())

That way, it will retrieve all issues with this value.
Then, create a two-dimension gadget, with the X-axis as Assignee (or Issue Type if you want one more level of breakdown) and the Y-axis as Project.
That way, you will have each line by project, showing the number of tickets or  where time was logged or comments were added  

Hope this can help 

[Staffan Redelius]

Hi @Thomas Gericke  and welcome to the community!

I don't have scriptrunner installed in my environment so I can't search for comments made by a specific user but if you can make your individual jql searches to work you could create a combined filter.

Create a JQL and save it as a filter named [MyFilter] for 
assignee = currentUser() OR worklogAuthor = currentUser() OR commentedBy = currentUser()

Create a new JQL and save it as your filter 
statusCategory = "To Do" and filter = "MyFilter"

Be aware that this might be a quite "heavy question" since it will search for the user in all projects and all work items. 

Let me know if this is of any help!

Best regards,
/Staffan

[Marc - Devoteam]

Hi @Thomas Gericke 

Welcome to the community.

There is no option to find usually worked on projects, any query related to projects is based on the project key provided.

Another option is to try to use date options in a JQL, to find worked on issues within a time frame.

This would limit the amount of results.

[Thomas Gericke]

Limiting with createdDated is an option to limit the results, yes. But that's also not the smartest method because it... well... it limits the number of results but not based on the work area 😉

Anyway, thanks. at least it reduces the results from like 50 projects to 10 when I filter for tickets created in the last 10 days.

[Marc - Devoteam]

Hi @Thomas Gericke 

Create filters with dynamic date periods, like endOfWeek, startOfWeek, etc...

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/ 

There are no work area option in JQL not even in apps that can extend JQL, projects are fixed options unfortunate.