Hi Lucas, Thank you for the reply.
Yes I have got this column in 'bugs' table. But when I see 'archived_bugs' table and in that table 'affects_stable', 'affects_unstable', 'affects_testing', all these columns contains the value false(f). So how can I get the archived bugs for stable release only? Regards Hassaan Afridi On Mon, Jul 17, 2017 at 12:31 PM, Lucas Nussbaum <lu...@debian.org> wrote: > Hi, > > On 15/07/17 at 19:32 +0200, hassaan afridi wrote: > > Dear Debian Team, > > > > Hi I am working with UDD to get data for my master's thesis. I am just > > wondering is there any way I could get bugs for the packages of stable > > release only. > > > > I could not find any column where I can filtered out the data for stable > > release. Is there any way to do it? > > There's no real notion of "bugs for the packages of stable release only" > in Debian. bugs affect ranges of versions of packages, and the version > of a given package in our current stable release can be among those > affected versions or not. > > To see if a given bug affects our stable release, you can look at the > 'affects_stable' column. > > Lucas >