Jira SQL for finding which tickets an engineer worked on, and when

[Samuel Justus]

I'm trying to write SQL to tell me which tickets a colleague worked on during a specific date range. I can't seem to get the DURING operator to work. I only have "assignee in" so far

[Bill Sheboy]

Hi @Samuel Justus 

Here is the documentation for the advanced JQL functions, with examples like what you are trying to do:

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/

assignee WAS anEngineer DURING ("2020/01/15", "2020/01/31")

Due to the change for user security, start typing in the name and let the lookup find them.

Best regards,

Bill

[Liam Green]

Hi @Samuel Justus 

Does the query return a lot more results than expected?

I've just used the following to narrow it down:

assignee was XXX AND updatedDate >= startOfWeek() AND updatedDate <= endOfWeek()

Without the updatedDate it shows every ticket that is assigned to someone as even old tickets are technically still assigned 'During'.

It is worth noting that it may not show all work done by an agent - for that I think you'd need time logging.

Hope that helps,

Regards, Liam

[John Funk]

Hey Samuel,

Can you share what you have so far? And what's not working as you would hope?