How can I parameterize Queries inside folders in struture

Daniil Pronin

Hello!
I am interested if there is any opportunity to parameterize queries inside folders in Jira Structure.

E.G I want to make folders of my team members (one folder per team member), in which there will be different subfolders, contatining different queries:

- Ann

-- Bugs, which Ann has created

--- Insert Query (issuetype = Bug and reporter= Ann)

-- Stories, assigned on Ann

--- Insert Query (issuetype = Story and assignee = Ann)

 

- Bob

-- Bugs, which Bob has created

--- Insert Query (issuetype = Bug and reporter= Bob)

-- Stories, assigned on Bob

--- Insert Query (issuetype = Story and assignee = Bob)

 

And I want to refer folder name in query so that I don't need to make individual query for every team member.

E.G.

- [Team Member]

-- Bugs, which [Team Member] has created

--- Insert Query (issuetype = Bug and reporter= [Team Member])

-- Stories, assigned on [Team Member]

--- Insert Query (issuetype = Story and assignee = [Team Member])

 

I've tried GroupBy, but it doesn't work as i want when it comes to different fields (assignee or reporter). 

 

Nicholas Ellis _ALM Works_

Hi Daniil,

I have included instructions below.  Please let me know if you have any questions or run into any issues.

1. Include all relevant issues in the board.  My insert JQL was "type in (story, bug)", yours might be more complex.

2. Create a formula like this:

if(type = "Story"; assignee;
   type = "Bug"; reporter)

3. group by this formula, you will have to use "Text Attribute..." and then find the formula column

4. then group by issue type and you should get something like this:

Also be aware this will result in a grouping of "No Value" for stories without an assignee, or bugs without a reporter if any exist in the board.

Cheers,

Nick

[ALM Works]