On 06/12/13 at 08:01 +0100, Lucas Nussbaum wrote:
> Package: how-can-i-help
> Version: 1
> Severity: wishlist
> 
> Hi,
> 
> how-can-i-help could report RFS bugs (Request For Sponsorship). That
> would help increase the visibility of those bugs.
> 
> To implement that:
> - there's a sponsorship_requests table in UDD with the required info;
> - it could be useful to add an option to hide those bugs, as they are of 
> lesser
>   interest for people who don't have upload rights (though additional reviews
>   could still be useful; the title could be 'Packages waiting for
>   sponsorship (reviews/tests are also useful)'). Or, maybe, we should
>   have a general way to enable/disable specific kind of reports in a
>   config file.
> 
> Lucas

Quick UDD query that seems to work:

select distinct ss.id, ss.source, ss.version, ss.title
from sponsorship_requests ss, sources_uniq su
where su.release = 'sid'
and ss.source = su.source
and su.version < ss.version;

Lucas


-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to