Issue with creating links to test cases in Testlink

unixadmin007 · Post by **unixadmin007** » Tue Apr 28, 2009 12:33 am

Hello All
we upgraded from 1.7.4 version to Testlink 1.8 version 2 months back. that time test link number display was changed so i ran this command to fix the problem
UPDATE tcversions a SET a.tc_external_id = (SELECT b.parent_id from nodes_hierarchy b where a.id = b.id);

I was trying to create some test cases with links to other test cases but somehow with any test case that have tags in the front, e.g. “EMo-5838”, using the following link syntax does not link to the correct test case:

http://testlink-1.com/testlink/lib/test ... low_edit=0

However, for the older test cases ( which were in 1.7 version ), the same syntax used for link works:

http://testlink1.com/testlink/lib/testc ... low_edit=0

please let me know if there's any solution exists for this.

amkhullar · Post by **amkhullar** » Tue May 05, 2009 8:37 am

id is just a number e.g. 5838 and not EMO , we prefix it before displaying it.

unixadmin007 · Post by **unixadmin007** » Tue May 05, 2009 5:01 pm

but it is not working either way

amkhullar · Post by **amkhullar** » Wed May 06, 2009 5:58 am

then itmeans the id you are using is incorect you need to have the correct internal id

amit

unixadmin007 · Post by **unixadmin007** » Wed May 06, 2009 6:16 am

but how can i find the correct id's

amkhullar · Post by **amkhullar** » Wed May 06, 2009 8:27 am

Just a pointer in your case if the TCase id shown on screen is EMO-5838
then 5838 here is your tc_external_id field in tcversions table.

Also if you need the link to edit the tc it should have the parent id from the nodes hierarchy table and not the id from the tcversions table.

so for your case say if the tcversions.id for this test cases is say 1001
then if you match it with the id field in nodes_hierarchy table and get the parent_id field (say 1000) then 1000 should be present in the link
http://testlink1.com/testlink/lib/testc ... low_edit=0

Hope this clears your doubt.

I have a question why do you need to do all this. (that time test link number display was changed so i ran this command to fix the problem - what was the problem). If you would have just upgraded the system as perthe scripts everything should work fine.

Amit