Forums

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

Is it possible to nest JQL inside a JQL?

Sudarshan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 19, 2020

Hello,

Can we add multiple JQL in a single query..?

Example:

I want to make a regular JQL which gives me the stories added after sprint has started, so I Tried with below JQL and it worked.! 

project = <Project name> AND type != Sub-task and issueFunction in addedAfterSprintStart("board name", Sprint name)

BUT.. Instead of sprint name argument can I add the JQL -- Sprint in openSprints().?

Is there any way to achieve this need ?

1 answer

1 accepted

0 votes
Answer accepted
Muthu Thiruppandy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 20, 2020

@Sudarshan, if you skip the second argument 'Sprint name'  all the active sprints on the board will be considered.  is that solve your requirement?

Sudarshan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 20, 2020

correct, but my intention is to find all the issues added after a sprint has started.!
and I cannot remove the second argument as that is how the function is built.

Muthu Thiruppandy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 20, 2020

You can just use the 'board name' and skip the second argument. Did you try with just the board name?  I use it without the sprint name as we use parallel sprints.   This is a Scriptrunner JQL function, below is the documentation.  

issueFunction in addedAfterSprintStart("Sample Scrum Board", "Sample Sprint 3")

Shows issues that were added to the named sprint (or all active sprints if second argument is not provided), after the sprint started. This is useful for seeing how the scope of a sprint has changed when the sprint is in progress.

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html

Like Sudarshan likes this

Suggest an answer

Log in or Sign up to answer