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"
  }
}