Try using this SQL
select userassociation.CREATED , userassociation.SOURCE_NAME , jiraissue.issuenum from userassociation join jiraissue join project on jiraissue.PROJECT = project.ID on userassociation.SINK_NODE_ID = jiraissue.ID and userassociation.SINK_NODE_ENTITY = 'Issue' where project.pkey = '' --type projct key here and jiraissue.issuenum = 1 -- type issue number here
I'm John Allspaw, co-founder of Adaptive Capacity Labs, where we help teams use their incidents to learn and improve. We bring research-driven methods and approaches to drive effective inciden...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG