Search found 10 matches

by bukanski_cn
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...
by bukanski_cn
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...
by bukanski_cn
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.
by bukanski_cn
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
by bukanski_cn
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...
by bukanski_cn
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.
by bukanski_cn
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.
by bukanski_cn
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.
by bukanski_cn
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...
by bukanski_cn
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...