how can I locate tasks related to stories that are not in the same sprint?

[Lilach Givaty]

we have stories that are managed by the product team and tasks linked to each story that are managed by R&D.

We want a query that will show us when a story was moved to a different sprint and the related tasks were not moved with it.

ideally it will be a list like this:

|story id|story sprint | linked task id|task sprint|

[Sebastian Kleinholz]

There are the limitations of JQL. A compare of two fields would be nice in this case.

If I would face this problem, I would query over the API with following pseudo algorithm:

$result = search for all stories that are assigned to one $sprint
for all in $result do {
  $children = get all children of $result
  for all in $children do {
    if ($children->$sprint != $sprint)
      echo "found one"
  }
}

[Sebastian Kleinholz]

@Lilach Givatywas this helpful?