Missing in log change of sprint name

[Trần Hương]

The answer is very useful for me, so I can get the fields I need. Thank you so much.

However, I had one issue when conducting this case. There are some issues that change the Sprint name that show the information in Jira Database, and some issues don't.
Please help me find out the problem in this case!
I hope to hear from you soon!

Note: The query i used:

"SELECT p.pname, p.pkey, i.issuenum, cg.ID, cg.issueid,

cg.AUTHOR, cg.CREATED, ci.FIELDTYPE, ci.FIELD, ci.OLDVALUE, ci.OLDSTRING, ci.NEWVALUE, ci.NEWSTRING

FROM changegroup cg

left join jiraissue i on cg.issueid = i.id

left join project p on i.project = p.id

left join changeitem ci on ci.groupid = cg.id AND ci.FIELDTYPE='custom' AND ci.FIELD='Sprint'

WHERE cg.issueid=176462"

Reference: https://confluence.atlassian.com/jirakb/how-to-retrieve-sprint-history-of-an-issue-project-from-jira-database-938641078.html