Page 1 of 1
Which table to query for the testcase id
Posted: Fri Apr 16, 2010 9:52 am
by 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
Posted: Fri Apr 16, 2010 3:17 pm
by 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
Posted: Mon Apr 19, 2010 5:40 am
by overflow
Thank a heap ... austvik.