Get metrics by BD - TL 1.9.3

[PMat]

Hello members,

I'm doing a proof of concept TestLink 1.9.3.

Given that I cannot deal well with xml export of the TL, the easiest option is to take the values directly from the database.

Accordingly it intends to display from the bd is the existing hierarchy in the filter, of menu executing tests but with the result of pass or fail.

Some like with the following structure (menu executing tests)

1st folder – Project X ***
1.1nd folder – screen Login ****
1.1.1st Testcase – Input incorrect values on fiel of password - ok
1.1.1rd folder – Messages expected
1.1.1.1st Testcase - Message “please try again” – nok
1.1.1.2nd Testcase - Message “the password is incorrect” - ok

Result i pretend of query at database, to export to excel easily

Name project | Name folder | Name folder or tc | Name folder or tc | Result test
Project X | screen Login | TC - Input incorrect values on fiel of password | | passed
Project X | screen Login | Folder - Messages expected | Tc Message “please try again | failed
Project X | screen Login | Folder - Messages expected | Tc Message “the password is incorrect” | passed

*** [on db TL 1.9.3: node_types= testproject | id 1]
**** [on db TL 1.9.3: node_types= testsuite | id 2]

Someone can help

BR
Paulo Matos
Portugal

[fman]

>> Given that I cannot deal well with xml export of the TL, the easiest option is to take the values directly from the database.
are you kidding ?
You will need to understand the db schema and develop lot of queries, instead to try to understand why you are not able to do XML working.
good luck

[PMat]

>> Given that I cannot deal well with xml export of the TL, the easiest option is to take the values directly from the database.
are you kidding ?
You will need to understand the db schema and develop lot of queries, instead to try to understand why you are not able to do XML working.
good luck

Hi all,

Sorry, to share only today the resolution but is here:
(note in the part " where id =14212 " you put your project target)

Code: Select all

SELECT  

	concat (ifnull(A7.name,''),' ', ifnull(A6.name,''),' ', ifnull(A5.name,''),' ', ifnull(A4.name,''),' ', ifnull(A3.name,''), ' ', ifnull(A2.name,'')) as nodes_hierarchy_address,
	A.BD_Name,
	ifnull(A1.name,'') as TC_or_Folder,
	A.Test_Case_Description, 
	A.preconditions, 
	A.version,
	A.name,
	A.status

	from 

		(
			select  D.tcversion_id, concat(A.prefix,'-',D.tc_external_id) as BD_Name, D.summary as Test_Case_Description, D.preconditions, D.version, F.name, 
				case when E.status = 'b' then 'Blocked' when E.status = 'f' then 'Fail' when E.status = 'p' then 'Passed' end as status 
	 
			from 
				(SELECT id as testproject_id, prefix FROM testprojects 
				
				where id =14212 						
				
				) A
			inner join		(SELECT id as testplan_id, testproject_id FROM testplans					) B	on A.testproject_id	= B.testproject_id
			inner join		(SELECT testplan_id, tcversion_id  FROM testplan_tcversions					) C	on B.testplan_id	= C.testplan_id
			inner join 		(SELECT id as tcversion_id, tc_external_id, version, summary, preconditions FROM tcversions	) D	on C.tcversion_id	= D.tcversion_id
			inner join 		(SELECT build_id, status, testplan_id, 	tcversion_id, 	tcversion_number FROM executions	) E 	on E.tcversion_id 	= D.tcversion_id and 	E.testplan_id =B.testplan_id
			inner join		(SELECT id as build_id, testplan_id, name from builds						) F 	on F.Build_id 		= E.build_id

		)A

	inner join 		(SELECT id, parent_id FROM nodes_hierarchy) B on A.tcversion_id= B.id
	inner join 		(SELECT id, name, parent_id FROM nodes_hierarchy) A1 on B.parent_id= A1.id
	left join 		(SELECT id, name, parent_id FROM nodes_hierarchy) A2 on A1.parent_id= A2.id
	left join		(SELECT id, name, parent_id FROM nodes_hierarchy) A3 on A2.parent_id= A3.id
	left join		(SELECT id, name, parent_id FROM nodes_hierarchy) A4 on A3.parent_id= A4.id
	left join		(SELECT id, name, parent_id FROM nodes_hierarchy) A5 on A4.parent_id= A5.id
	left join		(SELECT id, name, parent_id FROM nodes_hierarchy) A6 on A5.parent_id= A6.id
	left join		(SELECT id, name, parent_id FROM nodes_hierarchy) A7 on A6.parent_id= A7.id

	order by nodes_hierarchy_address asc

	LIMIT 0 , 15

BR from Portugal, to all