how 2 get the count of total no of test cases each category?

[vayal]

I have written a query like this to generate a report
*****************************
SELECT co.name as Component,ca.name as Category, p.name as Product FROM mgtcomponent co,mgtcategory ca, mgtproduct p where co.id=ca.compid and co.prodid=p.id;
******************************
In this report i have to show the number of test cases under each category(in the test link tree menu if we add testcases under category, count is displayed). Can anyone please tell me how to write a MySql query for that? or how in that testlink tree they are getting the count?

Thanks and Regards
Vayal

[vayal]

I have written a query like this to generate a report
*****************************
SELECT co.name as Component,ca.name as Category, p.name as Product FROM mgtcomponent co,mgtcategory ca, mgtproduct p where co.id=ca.compid and co.prodid=p.id;
******************************
In this report i have to show the number of test cases under each category(in the test link tree menu if we add testcases under category, count is displayed). Can anyone please tell me how to write a MySql query for that? or how in that testlink tree they are getting the count?

Thanks and Regards
Vayal

[havlatm]

I guess something like:

select count(mgttestcase.id) from mgttestcases, mgtcategory where mgtcategory.id=mgttestcases.catid and mgtcategory=<your name>

I wrote it without look to db, so modify tables and fields names for correct ones.