Listing of updates by certain people and date

Question

I know how to get all tickets which are update in a certain timeframe.

ex (issuekey in updatedBy(“Piet”, " -1w") AND updatedDate < startOfDay() OR issuekey in updatedBy(“Mien”, " -1w") AND updatedDate < startOfDay()

but how can a have an output like

ticket a.    19/12/22.   Piet.    Status a

ticket a.    18/12/22.   Mien.   Status c

Ticket b.   17/12/22.   Piet.     Status b

ticket a.    16/12/22.   Piet.     Status a

…..

Thanks for taking you time

Korsten Bezuidenhout · Answer

Hi @Katrien Reynaert ,

Hope this helps:

SELECT p.pname, p.pkey, i.issuenum, cg.ID, cg.issueid, au.lower_user_name, cg.AUTHOR, cg.CREATED, ci.FIELDTYPE, ci.FIELD, ci.OLDVALUE, ci.OLDSTRING, ci.NEWVALUE, ci.NEWSTRING
FROM changegroup cg 
inner join jiraissue i on cg.issueid = i.id
inner join project p on i.project = p.id
inner join changeitem ci on ci.groupid = cg.id AND ci.FIELDTYPE='jira' AND ci.FIELD='status'
inner join app_user au on cg.author = au.user_key
WHERE cg.issueid=(select id from jiraissue where issuenum = 115 and project in (select id from project where pname = 'Project name')) 
order by 1,3,4;

Yuliia_Borivets__SaaSJet_ · Answer

Hi @Katrien Reynaert

You can try to create such a report with Issue History for Jira app. My team developed it as a journal for all past changes, which you can adjust to your special needs.

You can add/remove any issue field to the table columns.

Try how it works for you and let me know if you have any questions.

Mikael Sandberg · Answer

Hi @Katrien Reynaert,

Welcome to Atlassian Community!

JQL doesn't allow you get get a list like the one you are looking for. You would need an app that allows you to view/search the history in order to do it. If you search for history in the Marketplace you will see apps that can do this.