Expose Dismissal Reason on the VulnerabilityType

Show dismissal reason in vulnerability report t... (#408909 - closed) • Lorenz van Herwaarden • 16.3 require's us to be able to expose the dimissal_reason of a vulnerability in the vulnerability report, however this is not currently facilitated by the backend in a straightforward manner.

We can potentially facilitate this using a LATERAL JOIN to attach the latest dismissal_reason from the vulnerabilities_state_transitions table to the vulnerabilities before we apply filtering, though it is suspected that may suffer poor performance and necessitate denormalization of the dismissal_reason to the vulnerability_reads table.

Implementation Plan

• Read dismissal_reason from vulnerabilities_read table