Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JIRA function in google sheets fetching multiple values for sprint field

Srirama Ravikanth Divakarla
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 22, 2022

I am trying to fetch issues in a particular sprint using SPRINT NAME or SPRINT ID in Google sheets and below is the query along with sample output.

I get records with matching sprint ID/name but also issues with additional sprint names (1st record)

Question: How do I avoid getting multiple sprint names in the output? (Yes, the issues have multiple sprints tagged and its not a good practice...)

I just want the output where in, only sprint is 234 or issues with multiple sprints tagged but sprint 234 top most sprint. 

 

=JIRA(CONCATENATE("Sprint =234 AND project=PRJ" ), "issueKey,Sprint, summary, ", 0, 30)

XXX-XXXX      PRJ-S5;PRJ-S4           Test1
XXX-XXXX      PRJ-S4                         Test2

0 answers

Suggest an answer

Log in or Sign up to answer