How can i find a user story is in multiple sprint in JIRA structure

[Parveen Taj]

I want to list the user stories which are in multiple sprints 

[David Niro · Accepted solution]

Hello @Parveen Taj ,

David from ALM Works here.

Are you trying to create a structure that includes only stories that are included in multiple sprints?

Or, are you trying to mark/identify stories that already exist in a structure and are assigned to multiple sprints?

Best,
David

[Parveen Taj]

I already have a structure with user stories , now I want to view only those which are in multiple sprints

[David Niro]

Hello @Parveen Taj ,

Thank you for the clarification!

You can use a formula like the one below to identify the issues that are part of more than one sprint:

IF sprint.SIZE() > 1:
  1

If you are using an on-prem version of Structure, which it appears you are, you can also Filter by this formula.

You can add a Generator or Transformation and choose Filter by Attribute.  Use the formula above as your attribute and set the Operator to "is true".

Please let me know if this helps!

Best,
David

[Parveen Taj]

yes it works :-)  thank you so much ... how do I highlight this in Red  colour for more visibility

[David Niro]

Hello @Parveen Taj ,

So glad to hear it!  You are very welcome!

You can use this formula:

with sp_size =
  sprint.SIZE()
:

IF sp_size >1:
  CONCAT(
    "{color:red}",sp_size,"{color}"
  )

Make sure to change the format from General to Wiki Markup for it to work.  I also made an adjustment that shows the number of sprints rather than just a 1.

Best,
David

[Parveen Taj]

Excellent Thanks you..