Execute Dynamic JIra query from confluence cloud

Hi ,

We have JIRA and Confluence Cloud versions.

Im using JIRA issue macros to display all the tickets in sprint.

From Confleunce Cloud , how can I execute a dynamic JIRA query with parameters that i can set outside of the query ?

i.e instead of hardcoding the sprint id in a query like  "Sprint=521 and issuetype=story" can i first set the value for a parameter in confluence as ActiveSprint=521  and then run the query to dynamically pick the value for sprint at the time of execution like 'Sprint=$ActiveSprint$ and issuetype=Story' ?

Today I have almost 40 queries in a dashboard that i need to update everyu 2 weeks with new sprint id.

 

Im open to using 3rd party add ons as well.

I googled abt this and all i could find was answers for Confluence server and not Confluence cloud.

 

-Sanju

 

 

 

1 answer

This widget could not be displayed.

Hi Sanji - You could try using the openSprints() search function in the JQL queries in your issue macros:

issuetype = story AND sprint in openSprints()

This should return a list of stories in your current active sprint(s), so you don't need to change the sprint ID every time. 

This will only display issues in an active sprint, so issues allocated to a sprint which has not yet started won't be displayed.

Another option would be to save a filter in JIRA which returns all issues in a particular sprint:

Sprint = 521

Note the filter id when you save it, then you can refer to this saved filter in your 40 queries.

For example, if the filter ID of the search above is 10200, you can do the following to display all stories in sprint 521:

filter = 10200 AND issuetype = story

And the following to display all bugs:

filter = 10200 AND issuetype = bug

Doing this means you only have to update the sprint ID in one place to change the results of all 40 queries that refer to it.

Thanks a lot for the quick response Sam !!

The example I gave was to explain the usage of a variable in the query.

Let me explain my real issue:

- Need to show the scope of whole year in current sprint(S), next sprint(S), next month(M), month after(M), Quarter(Q)  Half (H) 

i.e SSMMQH

Our sprints are 2 weeks each

The way im doing it now is by 1 jira query for each.

i.e 1 query for current sprint

1query for next sprint

1 query for next month (actually the 2 sprints for that month)

etc for rest of the MQH

All the above ive create a table in confluence page with 6 columns and each results are shown in seperate columns using jiraissues macro.

Now this is for just 1 product with its own board and sprints (Sprint ids)

I have to create 12 wiki pages for each products (meaning i have to replicate the queries with product and sprintid's deifferent)

Our cross functional teams and management were pretty happy with this dashboard (since they werent getting any visibility to Engineering plans), but now comes the problem of scaling it maintaining it.

If I had the option to run the query based on runtime parameters, then I could have setup the data in a seperate location where i just have to change the values.

Im open to any other option to report the same content even 3rd party tools either in confluence cloud or jira cloud.

-Sanju

 

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted 5 hours ago in Statuspage

What are your best incident management tips and stories? #HugOps

 👋Community members! Downtime happens. And great incident response takes a village. Teams like Support, Dev, SRE, Ops, IT, and Marketing have to come together to resolve the problem while keep...

23 views 0 2
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you