How can I count issue transitions with scripted JQL?

[philippos]

I have JIRA issues in transition between several users. 

I see that scipted JQL (as described here) are very powerful.

Can I count the days an issue has been assigned to my user account?

Would this be possible via any other means?

[philippos]

Thanks. Could I maybe extract these data and calculate the values with a VB script eg in Excel?

[JamieA]

Your best bet here is to write a script field that calculates this value, then you can use it in a query.

[philippos]

I want to build a list like this: JIRA issue ID:5 ---> total time in this issue by me: 15 hours JIRA issue ID:6 ---> total time in this issue by me: 23 hours JIRA issue ID:7 ---> total time in this issue by me: 19 hours This list will count the actual time this issue was assigned to me. So I need to count all the transitions to my account until the next transition out of my account. I need this to be counted for all issues retroactively.

[SanaS]

What do you want to do with the information? Do you want to filter on it, or do something to those issues?