Filtering a board on openSprint()

[Stuart Williams]

Hi there 

I am experimenting with moving my team to kanban,  from Scrum (or ScrumBan).  To help them switch I am trying to filter my new Kanban board to allow me to include only issues applying to the current Sprint.

I have tried the following in the quick filters 

Sprint = openSprints()

Error message: Operator '=' does not support the list value 'openSprints()' for field 'Sprint'.

Sprint in openSprints()

The operator 'in' is not supported by the 'Sprint' field.

Working with 

Jira Server v8.5.2

Can anyone explain what I am doing wrong?

[Nic Brough -Adaptavist- · Accepted solution]

sprint in opensprints() works fine for me, so I suspect there's something else wrong here.

Could you check how many fields called (anything like) "sprint" you have?

[Stuart Williams]

I have two, and both work in the same way.

That is neither would work with the openSprints() function.  One cf[10404] the other is cf{10648].  Neither like the in function.

[Deleted user]

Since you have two fields for sprint, are those fields unique to certain projects?

You might try to change your filter to only look at the project that your kanban board is looking at as well (unless your board consists of multiple projects).

That way if the project has an issue with the other sprint field, it shouldn't throw any more errors.

[Nic Brough -Adaptavist-]

Ah, ok, you say "I have two [sprint fields], and both work in the same way."

That is probably the root of the problem.  This implies that your sprint fields are not sprints, but something else (a string or select list) called sprint.

The openSprints() function only works with fields of type "jira sprint field", which you can not add more of, nor reconfigure.

Could you look at your fields in the list of custom fields and see what type they are?

For example, I've got:

[Stuart Williams]

Hi thanks for the suggestion Nick,  but I believe it is referencing the 'Jira Software Sprint field' as best I can tell.  I am not sure where you saw this view above , but when I edit the field there is a Sprint field that comes up with the Jira reference below. 

There is no other sprint field referenced.   When I search for issues two sprint fields come up in the list, and selection of one of them means that the items from that sprint are captured.

[Nic Brough -Adaptavist-]

My screenshot was of part of the list of custom fields on the Jira I had to hand.  As an admin, go to Admin ->  Issues ->  Custom fields - it would be interesting to see all of your sprint fields and their types.

[Pratik Mitra]

I am wondering if because you are using a Kanban board (instead of a previous Scrum Board) there shouldn't be any Sprints so this is potentially correct behaviour?

[Stuart Williams]

Good Point,  but tried this on the old scrum board and get the same response when adding this as a filter.  

I would understand if this was the reason though

[Joshua Sneed Contegix]

Hi Stuart,

Try using IN instead of =. The equal symbol is not supported for openSprints() per Advanced Searching (fucntions) and is supported by the Sprint field per Advanced Searching (Fields).

It may be worthwhile to name the sprint in the query since you are transitioning. You may even consider setting up your board filter as it will be in the long run and then use a Quick Filter for the current sprint. Cheers!

[Stuart Williams]

Did try the IN function as shown above. 

I was trying not to have to hard code the Sprint name in there, but if I must I will.

Thanks