Which table to query for the testcase id

Discussion and information for XML-RPC interface.

Moderators: Amaradana, TurboPT, TL Developers

Which table to query for the testcase id

Postby overflow » Fri Apr 16, 2010 9:52 am

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
overflow
TestLink user
 
Posts: 4
Joined: Thu Apr 15, 2010 5:25 am

Postby austvik » Fri Apr 16, 2010 3:17 pm

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
austvik
Advanced user
 
Posts: 24
Joined: Thu Mar 25, 2010 7:25 am

Postby overflow » Mon Apr 19, 2010 5:40 am

Thank a heap ... austvik.
overflow
TestLink user
 
Posts: 4
Joined: Thu Apr 15, 2010 5:25 am


Return to XML-RPC API



Who is online

Users browsing this forum: No registered users and 1 guest