I have few agile development teams that work on tasks for many biz projects (Many to Many). So every dev team have it own JIRA Project for the backlog.
It is possible to generate and agile report (like release burndown for example) that span across few JIRA Projects.
So for a particular biz effort we used a label (tag) for all the JIRA Stories/task , we would want to pull the burndown chart from JIRA projects A, B and C.
I get that, but I cannot get the report blueprint to accept a single JQL statement to include all projects. Thus, project = 'IIA' works fine. But I was only able to add additional projects to the report blueprint by using the JIRA/Issue filter from the Insert drop-down. And try as I might I cannot find the JQL syntax for All Projects.
I'm sorry, but that makes little sense. What do you mean by "report blueprint"? JIRA doesn't have those. It sounds like you are actually working in Confluence, and this question has nothing to do with Confluence, so you're asking in the wrong place. As for the JQL syntax for "all projects", I'll say it's not obvious, but it is simple. It's "". Or nothing. The point is to select "everything", so if you enter a query with no clauses to limit it, you get the lot.
Thanks for that. Tried it but I still cannot get a report to solve a very simple problem; give me a report that shows all projects. And yes, I'm in Confluence trying to get a JIRA issues report for all my projects using what I believe is called a blueprint. I'll keep thrashing away at it. The answer has to be in there somewhere.
JIRA doesn't have, or expose "all projects", it works with *issues*. So start there - does a filter for <nothing> return all the issues in JIRA? Can you use it in a "filter statistics" dashboard gadget to summarise the number of issues by project? Once you have that working, move into Confluence. Blueprints in Confluence are page/space creation wizards, not reporting functions, so I'm not sure why you're looking at those, but we can come back to that. Fire up a plain page and try the JIRA macros to see your filter - does that work?
project -> backlog -> board
Therefore, those kind of reports can easily made with SQL for JIRA (2.0+) as it supports the JIRA Software (Agile) REST API and it is possible to get the all the issues for any Agile board, backlog or even individual sprints and join the rest of the JIRA data like Story points, worklogs etc.
Furthermore, with the power of the SQL language you are able to filter and aggregate data in a really flexible and powerful way.
Hope this helps.
Atlassian ranks project attributes as the third most important factor impacting performance in the category of data. It’s not surprising, since project attributes are precisely the rules used to ma...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs