Redmine

I can query/filter issues by created, updated, and due dates. However, I cannot query by when the issue was actually closed. I know this information appears to be stored in journals and journal_details rather than issues table, which may make this a tad more complex. I have tried to write custom SQL for this myself, but I am not getting results that match the information on the History section of an issue.