Bug#825695: udd todo: List unsolved security issues in the TODO list?

[Petter Reinholdtsen <pere@hungry.com>]

Package: qa.debian.org
Severity: wishlist
User: qa.debian.org@packages.debian.org
Usertags: udd
X-Debbugs-CC: security-tracker@packages.debian.org

As bug #660170 is solved and the information from the security tracker
was made available in UDD, would it be an idea to list the unfixed
security issues in the TODO list, similar to RC bugs?

I'm not quite sure how to implement it, but suspect something like this
SQL search can give an idea about the information I would like to have
shown:
  
  select * from security_issues_releases where source in (select source from sources where maintainer_email = 'pere@debian.org' or uploaders like '%pere@debian.org%') and status != 'resolved';

The idea is to get something similar to
<URL: https://security-tracker.debian.org/tracker/source-package/vorbis-tools >
only per developer instead of per package, to show up in the TODO list,
so I would be more aware of the unsolved issues.

-- 
Happy hacking
Petter Reinholdtsen