Filter for my work

[Mesrop Yaghubian]

Hi @AlL

I am wondering if it is possible (SQL Search Extension or another addon) to create a filter that shows me the following:

Stories assigned to me AND

Sub-Tasks assigned to me that ar part of Stories assigned to one of my colleagues

Thanks for your help as I am struggeling with all my ideas.

Michael

[Walter Buggenhout · Accepted solution]

Hi @Mesrop Yaghubian,

The following should return all the issues that you need:

Issuetype in (Story, Sub-Task) AND Assignee = currentUser()
AND Resolution = Unresolved

If your plan is to get a list of issues assigned to you, then I would not over-complicate things by adding additional parameters from stories assigned to your colleagues. Those sub-tasks are still assigned to you, right?

I would even consider omitting the issuetype part. But I added the Resolution bit to only return issues that still need to be worked on.

Hope this helps!

[Walter Buggenhout]

Alright, @Mesrop Yaghubian - understood 🤗

That is how I am working right now.

My wish was to bring down the number of results to keep a better overview by "hiding" sub-tasks of my stories.

But if this is not possible I have to work with my whole bunch of work items in one view :-)

Here's a list of marketplace apps that may allow you to extend your search capabilities. If you need to dynamically extend with the option to filter with sub-queries, then the marketplace is the source you'll need.

There's plenty of options available there, so it is best to balance out the value you expect to get from those versus the cost, obviously. 

[Mesrop Yaghubian]

Thank you @Walter Buggenhout 

That is how I am working right now.

My wish was to bring down the number of results to keep a better overview by "hiding" sub-tasks of my stories.

But if this is not possible I have to work with my whole bunch of work items in one view :-)