Showing SQL queries and where is 'Test Suites' stored?

[Zone99]

Hi,

I'm trying to use a third party tool to get data from a Testlink instance (1.9.9 or 1.9.12) and I've been trying to do two things:

1. Set testlink debug so that I can see the SQL queries being sent to the system - I can use the queries to verify I'm setting the other tool up properly.
2. Set a report/query on test suites, similar to what's seen in General Test Plan metrics on reports. This would be the 'Results by Top Level Suites' report on that page.

For #2 I cannot find the test suite name anywhere. So if I have:

Testsuite1
-- testsuite.001
-- testsuite.002

I can see testsuite.001 in the tables but for the life or me, I cannot find Testsuite1 anywhere in any table? It's got to be stored somewhere....

any help?

Thanks,
-Rick

[Zone99]

Ok. Trying again and sticking with just #1.

I can't seem to get a debug mode to show me what SQL queries are being sent to the database for some operations. I'm using 1.9.9 and 1.9.12.

Any help? Anyone?