Search found 10 matches
- Thu Nov 29, 2012 12:29 pm
- Forum: TestLink 1.9
- Topic: Help to get SQL Statement
- Replies: 14
- Views: 17556
Re: Help to get SQL Statement
Hi fman, Probably we have made lot of mistakes, when we did our initial db modelling, but IMHO you can not complain about the missing column ( a column that do you need NOW, but may be tomorrow you are going to complain for another column for your needs) I dont want to say you've made a lot of mista...
- Wed Nov 28, 2012 1:13 pm
- Forum: TestLink 1.9
- Topic: Help to get SQL Statement
- Replies: 14
- Views: 17556
Re: Help to get SQL Statement
Hello and thanks for answer. in testplans table i can see what testplans are in a project. (but only the description) In the tcversions i can see the description of the testcases and in executions table i can see if a test case failed, passed and so on. (this two tables i can connect) In the node_hi...
- Wed Nov 28, 2012 8:43 am
- Forum: TestLink 1.9
- Topic: Help to get SQL Statement
- Replies: 14
- Views: 17556
Re: Help to get SQL Statement
Hello,
I'm crashing my head about three weeks now with this problem and cannot find an solution for it.
Can please anybody help me how to create this sql query?
Thank you very much.
I'm crashing my head about three weeks now with this problem and cannot find an solution for it.
Can please anybody help me how to create this sql query?
Thank you very much.
- Mon Nov 26, 2012 1:04 pm
- Forum: TestLink 1.9
- Topic: Help to get SQL Statement
- Replies: 14
- Views: 17556
Re: Help to get SQL Statement
Hello last time 
I only need help now, to build a query where are could see which tastcases are in which testsuites.
thanks a lot for help

I only need help now, to build a query where are could see which tastcases are in which testsuites.
thanks a lot for help
- Fri Nov 23, 2012 2:47 pm
- Forum: TestLink 1.9
- Topic: Help to get SQL Statement
- Replies: 14
- Views: 17556
Re: Help to get SQL Statement
Hello, i have got this Query now: $sqlNew2 = "SELECT tl_testprojects.id, tl_nodes_hierarchy.name, tl_testplans.notes FROM tl_nodes_hierarchy, tl_testprojects, tl_testplans WHERE tl_nodes_hierarchy.node_type_id=1 AND tl_nodes_hierarchy.id=tl_testprojects.id AND tl_testplans.testproject_id=tl_tes...
- Fri Nov 23, 2012 8:30 am
- Forum: TestLink 1.9
- Topic: Help to get SQL Statement
- Replies: 14
- Views: 17556
Re: Help to get SQL Statement
Hello,
will try it this afternoon and give a response or ask for next help.
Thanks a lot meanwhile.
will try it this afternoon and give a response or ask for next help.
Thanks a lot meanwhile.
- Thu Nov 22, 2012 12:17 pm
- Forum: TestLink 1.9
- Topic: Help to get SQL Statement
- Replies: 14
- Views: 17556
Re: Help to get SQL Statement
Hi,
really nobody here who can help me? I'm really desperate.
Leave this topic 3 days open than it can be closed.
Thanks a lot.
really nobody here who can help me? I'm really desperate.
Leave this topic 3 days open than it can be closed.
Thanks a lot.
- Fri Nov 16, 2012 2:30 pm
- Forum: TestLink 1.9
- Topic: Help to get SQL Statement
- Replies: 14
- Views: 17556
Re: Help to get SQL Statement
Anybody an idea?
Thanks a lot.
Thanks a lot.
- Tue Nov 13, 2012 8:30 am
- Forum: TestLink 1.9
- Topic: Help to get SQL Statement
- Replies: 14
- Views: 17556
Help to get SQL Statement
Hallo, I need to build this SQL statement: I want to read out the Test Project's name than the Test suites which are in this test project and the test cases which are in the test suites. A structure like this: TestProject TestSuite1 TestCase1 TestCase2 TestCase3 TestSuite 2 TestCase1 TestCase2 Is th...
- Mon Nov 12, 2012 10:56 am
- Forum: TestLink 1.9
- Topic: Modify MS Word template
- Replies: 1
- Views: 3412
Modify MS Word template
Hallo, i studied the code of TL 1.9.4 and cannot find the template for the MS Word document. I studied the code of "printDocument.php" where is defined what should be printed into a Word document but i cannot find the peace of code or the file where is defined where it should be in the doc...