Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Sprint Management, filter with function

Hi, 

 

I have problems with filter with JQL function and Sprint Management

We have Script runner 

The result of filter is ok, all issues are ok

The settings of project are ok to manage Sprint

When i add my filter impossible to manage Sprint, if i modify the filter with simple JQL all is ok.

Can you help me on this problem please ?

The filter  is : 

project = "SW - DSI" AND issuetype = Épopée AND "Domaine métier" = "Moyens de Paiement (SW-17493)" OR issueFunction in issuesInEpics("project = 'SW - DSI' and issuetype = Épopée AND 'Domaine métier' = 'Moyens de Paiement (SW-17493)'") OR issueFunction in subtasksOf("project = 'SW - DSI' and issuetype = Épopée AND 'Domaine métier' = 'Moyens de Paiement (SW-17493)'") ORDER BY Classement ASC.

 

Thanks by advance for your help

 

Best regards

 

Jérôme

3 answers

0 votes
Alexis Robert Community Leader Mar 09, 2021

Hi @Jérôme Arpin , 

 

what do you mean "after I add my filter impossible to manage sprint" ? Do you mean that you can't start/close a sprint when using this JQL on your Scrum board ? 

It would help if you could describe with more details the error that you have.

By the way, if you'd like to ask your question in French, we have a new group on Community dedicated to French users : https://community.atlassian.com/t5/Atlassian-en-fran%C3%A7ais/gh-p/Francais

 

Thanks !

 

--Alexis

Hi, 

thanks for your answer

When i use this filter , the different button for Sprint aren't activate (in Grey)

Impossible to create, and to start/close

If i write a simple JQL, I have all rights, as soon as I use issuefunction I don't have the buttons active

 

For a other example, i created this filter :

issue = DSI-182 OR issueFunction in issuesInEpics("issue = DSI-182 ") OR issueFunction in subtasksOf("issueFunction in issuesInEpics(\"issue = DSI-182 \")") ORDER BY issuetype DESC, Classement ASC

I had he same problem.

I found a solution with two filter :

  1. project = "SW - DSI" AND "Lien d'épopée" = DSI-182
  2. project = "SW - DSI" AND ("Lien d'épopée" = DSI-182 OR issueFunction in subtasksOf("filter = SW-DSI-DSI-182")) ORDER BY Classement ASC

For my new filter, I have really a problem to find a good solution, i tried  a combination of several filters

0 votes

You can't manage a sprint with that filter because you are drawing in things that are not items you include in sprints, and you might not be using the right fields to manage them.

Also, your braces may not be doing what you expect, but I am not sure of that, so I'd just suggest you review them and check (you don't need to in queries that only use Or or And to join clauses, but a lot of us trip over when mixing the two. 

Try:

project = "SW - DSI" AND issuetype = Épopée AND "Domaine métier" = "Moyens de Paiement (SW-17493)" OR issueFunction in issuesInEpics("project = 'SW - DSI' and issuetype = Épopée AND 'Domaine métier' = 'Moyens de Paiement (SW-17493)'") OR  ORDER BY RANK ASC.

Note I've said "rank" in the order by clause - I do not know if you maybe have translated Rank to Classement?  If so, then you don't need my replacement.  The order by for a sprint filter just needs to be based on whatever rank type field you have.

Thansk for your answer

I unsderstand your solution but we want to see Subtask in the Sprint Board. We will reflect with this solution.

With this filter impossible to manage Sprint.

If i write only , project = "SW - DSI" AND issuetype = Épopée AND "Domaine métier" = "Moyens de Paiement (SW-17493)" OR  ORDER BY RANK ASC , I can manage sprint but we need all children, that is our problem

In Board Settings, i have this message
Projets dans le tableau
La liste des projets de ce tableau ne peut pas être affichée en raison de la complexité du filtre du tableau.

 

How to simplify my JQL, ?

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

ThinkTilt is joining the Atlassian Family!

This morning, Atlassian announced the acquisition of ThinkTilt , the maker of ProForma, a no-code/low code form builder with 700+ customers worldwide. ThinkTilt helps IT empower any team in their or...

151 views 8 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you