nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Query 'issueFunction in addedAfterSprintStart' and 'issueFunction in removedAfterSprintStart'

E_r2itys

Hi all,

I want to create a query where I can see all items added and removed from current sprint (scope changes).

When using separate boards with added after sprint and removed after sprint I do get the correct result but when I try to combine these 2 issue functions (added and removed) then I don't get the complete list. This is how I used this in SQL:

(issueFunction in addedAfterSprintStart( "board1", "sprint1")) and (issueFunction in removedAfterSprintStart("board1", "sprint1"))

What am I doing wrong here?

Thank you in advance.

Best regards,

Elke

Accepted answers

Bill Sheboy

Hi @E

You are checking for things added to the sprint AND removed from it. If you change your AND to an OR it should work as you expect.

Best regards,

Bill

All comments

Bill Sheboy

Hi @E

You are checking for things added to the sprint AND removed from it. If you change your AND to an OR it should work as you expect.

Best regards,

Bill

E_r2itys

off course, how simple it can be :-) Thank you for your reply.

Bill Sheboy

I am glad that helped.

Also please consider liberal usage of parentheses when needed for your JQL expressions that include OR clauses. It seems JQL sometimes has a different understanding of Boolean algebra / order of precedence than most learn in school. ;^)

Adan Ruiz

Hi @Bill Sheboy good day! I saw the recommendation you gave for the following function and it works pretty well, thanks a lot,

(issueFunction in addedAfterSprintStart( "board1", "sprint1")) OR (issueFunction in removedAfterSprintStart("board1", "sprint1"))

Quick question, is there any way we can list multiple sprints in the function? so for instance instead of doing this way: calling 2 sprints:

issueFunction in removedAfterSprintStart("Board Name", "Sprint Name") OR issueFunction in removedAfterSprintStart("Board Name", "Sprint Name")

Is there a way to list multi sprints: issueFunction in removedAfterSprintStart("Board Name", Sprint in ("Sprint Name1", "Sprint Name 2", "Sprint Name ...")

Im working with smart filters so when I select one specific sprint, I'd like to call in just that specific sprint.

Thanks for your advise!

Bill Sheboy

Hi @Adan Ruiz -- Welcome to the Atlassian Community!

I do not believe I suggested those functions...I am using Jira Cloud and not using ScriptRunner. You may want to check the documentation or contact for ScriptRunner to learn if that is possible. My reading of the info seems to indicate that is not possible: https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions

Kind regards,
Bill

Adan Ruiz

Thanks for the link, it is a good reading

Robin Surland_qx626i

The evergreen query in Jira Cloud if you have ScriptRunner is issueFunction in addedAfterSprintStart(BoardName) and (sprint in OpenSprints()).

Ahlem MASTOURI

@Robin Surland Are you sure this is working in Jira Cloud ?

EPMO_jsuw0u

Looks like this scrip does not run in JIRA cloud. Is there any workaround for getting this data for Cloud users?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

sql

jira

jira-server

atl-gruland