When I use this query I get no results: (NOTE - I don't want to see stories in the active sprint)
project = "Operations 1" AND "Story Points[Number]" is EMPTY AND status != canceled AND summary !~ "Support for Phosphates IT" and type = story and sprint not in opensprints()
When I remove the active sprint statement then I get results:
project = "Operations 1" AND "Story Points[Number]" is EMPTY AND status != canceled AND summary !~ "Support for Phosphates IT" and type = story
Hi Kurt and welcome,
JQL queries can be tricky at first, can you try the following?
project = "Operations 1" AND "Story Points[Number]" is EMPTY AND status != canceled AND summary !~ "Support for Phosphates IT" and type = story and (sprint not in opensprints() OR sprint is EMPTY)
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You are welcome! Did my answer solved your question?
If so, consider to set my previous comment as accepted using the [Accept Answer] button to tell other members of this community that no further help is needed in this topic.
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I just wanted to say thank you for this (sprint not in opensprints() OR sprint is EMPTY). I had tried everything to get this to work. I would have never guest to do it this way.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.