Is IssueHistory() based on a table - and which one?

[Henrik Mikkelsen]

I would like to have sql access to "recent issues". 

Anyone knows which table I should look in? If any?

[Henrik Mikkelsen · Accepted solution]

Answering this myself. The table is "userhistoryitem".

Problem being I don't know the algorithm for purging records. 

[Nic Brough -Adaptavist-]

Yes, but you should not use them.  The Jira database is just a data store and is very very not designed for reporting.  It is the worst possible way to do reporting for Jira.

If you must do this the wrong way, look at changeitem and changegroup, joined to at lease jiraissue, then you'll need to join it to options to read some custom field changes, and customfield, and jiraaction, and, and, and, and

[Henrik Mikkelsen]

I know, I know ...

I'm still looking for a way to make my "read-log" and I noticed Recent Issues includes issues that you have looked at.