CODEWITHSUNDEEP
jql
IT hero
IT hero

Reputation: 77

How to get all stories and sub tasks from a specific user along with how much time spent on each item in JIRA

I am trying to get all stories and sub-tasks for a specific user along with how much time spent on each item from starting of this year.

I am using JIRA version v8.5.9, where I have tried running the following query but it is not giving me the expected result, any help is appreciated.

(issuetype = "Sub task") AND time spent > 0 and assignee = test123

Upvotes: 1

Views: 1409

Answers (1)

RavinderSingh13
RavinderSingh13

Reputation: 133538

With your shown samples, attempts please try following JQL query.

(issuetype = "Sub task" OR issuetype = Story )AND timespent > 0 AND assignee = test123 AND createdDate >= startOfYear()

Explanation:

  • Look for Sub task OR story first.
  • Then make sure its timespent(looks like OP has a typo in OP's efforts) is more than 0 here.
  • Then checking assignee should be test123 user.
  • Then putting AND condition to make sure all items are coming from starting of this current year.

Upvotes: 1

Related Questions