Which table to query for the testcase id

[overflow]

Hi
I am having problems with the reportTCResult() method where i have to pass appropriate testcase id. I have been trying to get the right testcase-id by querying the tables but no luck,

Any help will be much appreciated.

~Overflow

[austvik]

They have a hierarchy where e.g. testcases are stored.

Try this query:

Code: Select all

SELECT * FROM nodes_hierarchy nh 
JOIN node_types nt ON (nh.node_type_id = nt.id) 
WHERE nt.description LIKE 'testcase';

It gives me information like this:

Code: Select all

mysql> select * from nodes_hierarchy nh JOIN node_types nt ON (nh.node_type_id = nt.id) WHERE nt.description LIKE 'testcase';
+----+------------------------------+-----------+--------------+------------+----+-------------+
| id | name                         | parent_id | node_type_id | node_order | id | description |
+----+------------------------------+-----------+--------------+------------+----+-------------+
| 15 | Start JETBatch from Testlink |         7 |            3 |        100 |  3 | testcase    |
| 17 | Start JET from Testlink      |         7 |            3 |        101 |  3 | testcase    |
| 26 | Simple stress test case      |        13 |            3 |        100 |  3 | testcase    |

-J

[overflow]

Thank a heap ... austvik.