Query to extract the active users who have worked on (one or more) issues in a given period

[FrancescoKa]

Is this query ok for you or I am missing something? (the system is a jira 6.4 server)

(in this case the period starts from '2017-09-01'  )

select cu.first_name,cu.last_name, cu.email_address from cwd_user cu,
( select distinct(assignee) as username from jiraissue ju where ju.updated > '2017-09-01' ) as du
where cu.lower_user_name = username and cu.active=1

Thanks to all!

[Marko Filipan · Accepted solution]

Hi,

Your query seems to be okay, it returns the results as you specified in the thread title.

Cheers,
Marko