Bug Resolved report alert not sent if report assigned and unassigned

[mattrogowski]

When determining users to send a report update alert to in XF\Service\Report\ClosureNotifierService it runs this query:

SQL:

$lastOpenDate = $db->fetchOne("
    SELECT comment_date
    FROM xf_report_comment
    WHERE report_id = ?
        AND state_change = 'open'
    ORDER BY comment_date DESC
    LIMIT 1
", $reportId);

It then finds any comments where comment_date is greater than or equal to the date queried here, and is_report is 1. This should send the alert...

Read more

Continue reading...