Found this query to retrieve history of status, the article is dated 2017:
SELECT p.pname, p.pkey, i.issuenum, cg.ID, cg.issueid, u.first_name, u.last_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 cwd_user u on cg.author = u.lower_user_name
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;
But in my database the fields are missing in the changeitem table, where is the history of value ?
