Getting a list of bugs

[vladd]

Hi.

If you want just the IDs instead of having the whole list, it's enough to edit 
/template/en/default/list/table.html.tmpl and to eliminate from it the 
undesired values. If you want a list instead of a table you need to eliminate 
also the <tr> tags etc.

> I thought i could get some code base from the above file but i cant work
> out where it actually does the selecting.

Search for the comment:

# Generate the basic SQL query that will be used to generate the bug list.

in the buglist.cgi file.

Thanks,
Vlad - vladd.

> Basically all i want todo is run this query:
> SELECT bug_id, short_desc, product_id FROM bugs WHERE bug_status='RESOLVED'
> AND bug_resolution='FIXED' ORDER BY delta_ts DESC
>
> Then using a template i will display the bug ids in a list.
>
> Can anyone point me in the right direction or give me a helpful tip on
> howto get a couple of details out of the DB?
>
>
> Best Regards,
>
> Mark Ingram
> Software Engineer
> Nexsan Technologies
> 33 - 35 Parker Centre
> Mansfield Road
> Derby
> DE21 4SZ
>
> -
> To view or change your list settings, click here:
> <http://bugzilla.org/cgi-bin/mj_wwwusr?user=jocuri@softhome.net>