Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0004744TestLinkContribution Maintained BY USERpublic2011-09-12 13:252012-08-27 20:51
Reportertechieguy 
Assigned To 
PriorityhighSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOSOS Version
Product Version1.9.3 (2011 Q3 - bug fixing) 
Fixed in Version 
Summary0004744: CONTRIBUTION - contrib-multiplans-reports
Description(ORIGINAL SUMMARY:
Requirement based Report should have Test Plan as a parameter)

E.g. I create 2 Separate Test Plans and the test cases in them are mapped to all the Requirements but in 2 Different Req. Specs.

1 Test Plan(test cases in this plan) for Functional Test Cases --> Req. Spec for Functional Requirements
2 Test Plan(test cases in this plan) for Performance Test Cases --> Req. Spec for Performance Requirement

Now when I execute these 2 test plans and run the Requirements based Report it shows the test cases which are mapped to the Functional Test Cases as per there actual results but the other test cases mapped to the Performance Requirements show as NOT RUN. Which gives an incorrect picture.

Basically there should be a way where I should be able to see the overall requirements status for all the test cases across multiple test plans also.

Currently the behaviour doesnt give the bigger picture overall status, its per test plan only with status shown as NOT RUN for those test cases which are not part of this test plan , they may or may not be present in another test plan and executed.
TagsNo tags attached.
Database (MySQL,Postgres,etc)1.9.3
Browser
PHP Version
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Fileszip file icon contrib-multiplans-reports.zip [^] (116,619 bytes) 2012-02-05 16:40
patch file icon common_query.php.patch [^] (498 bytes) 2012-07-16 16:26 [Show Content]

- Relationships

-  Notes
(0016198)
oscar (reporter)
2012-01-06 14:15

+1 to get this issue fixed :)
(0016199)
fman (administrator)
2012-01-06 14:24

contributions are welcomed
(0016200)
oscar (reporter)
2012-01-06 15:41

Hi Francisco,

I'm trying to contribute on this issue thru the Python wrapper
(https://github.com/orenault/TestLink-API-Python-client [^]).
If someone is interested here, I will provide details.

Regards,
Oscar
(0016201)
fman (administrator)
2012-01-06 16:46

When I talk about contribution I'm talking about THIS issue.
For other kind of contributions best practice is open an issue and attache details.
(0016330)
frl (reporter)
2012-02-05 16:39

Hi all,

The package, joined in the file contrib-multiplans-reports.zip, proposes a set of reports whose purpose is to give a global status for a project's release with data consolidated from several test plans and several builds. It is not limited to req based reports only but also provides some tests based reports.

The ODT document included in the package give more explanations (as simple as possible, but data consolidation raises sometimes quite complex issues !!)
Installation/configuration instructions are also included in the document (even if installation is very easy as it is packaged as an add-on to TL 1.9.3 distribution, without any change to standard TL code)

NOTE :
Some reports of this package could benefit from 0004763 (req spec overview, req traceability matrix for example) - You may now understand why I posted it ;-)

Validated on my platforms : Debian 6 (php 5.3.3, mysql 5.1) and Win XP (EasyPHP 5.3.6) on test projects with few hundreds of reqs and few thousands of tests.

Regards
(0016331)
fman (administrator)
2012-02-05 16:56

thanks for contribution
till we have no time to review code, it will be not added to stable code.
(0016332)
oscar (reporter)
2012-02-06 09:54

Marvellous, thanks!

I'm running postgresql and I just had to modify the file common_query.php at line 93 as follow to make this "add-on" work:

diff common_query.original.php common_query.php
93c93
< $sql .= " AND type <> 1"; // 1 = section
---
> $sql .= " AND type <> '1'"; // 1 = section

Apart from that, it works good.

Regards,
Oscar.
(0016333)
oscar (reporter)
2012-02-06 10:54

Hi frl,

I'm facing some issues with this package (e.g. in the "Requirement Traceability Matrix", I don't see all the requirements specification documents).

Could you contact me in private to discuss?
Then we'll report in this issue when applicable.

Thanks
Regards,
Oscar
(0016978)
oscar (reporter)
2012-07-16 16:25

The patch common_query.php.patch contains the following fixes:
- one fix for the "Requirement Specification Overview" report.
  A quote was added around the type 1 as described below:
      $sql .= " AND type <> '1'"; // 1 = section
  Otherwise the report doesn't work with TestLink 1.9.3 (the contrib-multiplans-reports.zip was maybe working fine with a TestLink version older than 1.9.3 which may explain why it is not working out of the box on 1.9.3)

- one fix for the report "Requirement Specification Overview" to sort the requirements with the same order as in the tree displayed in TestLink interface.
(0017170)
frl (reporter)
2012-08-27 20:51

I plan to port this package on Testlink 1.9.4 including fixes proposed by oscar (Thanks) and few others.
 N.B. type criteria fix seems related to DB server - mysql convert impliticly 1 to '1' not to testlink version)

If you are interested to integrate some parts of this package in next distributions, I could follow guidelines which could help for this integration. (just give me instructions for this)

Thanks
Frl

- Issue History
Date Modified Username Field Change
2011-09-12 13:25 techieguy New Issue
2011-09-15 17:06 techieguy Note Added: 0015828
2011-09-15 20:22 fman Note Deleted: 0015828
2012-01-06 14:15 oscar Note Added: 0016198
2012-01-06 14:24 fman Note Added: 0016199
2012-01-06 15:41 oscar Note Added: 0016200
2012-01-06 16:46 fman Note Added: 0016201
2012-02-05 16:39 frl Note Added: 0016330
2012-02-05 16:40 frl File Added: contrib-multiplans-reports.zip
2012-02-05 16:53 fman Category Requirement Management => Contribution Maintained BY USER
2012-02-05 16:56 fman Note Added: 0016331
2012-02-06 09:54 oscar Note Added: 0016332
2012-02-06 10:54 oscar Note Added: 0016333
2012-07-16 16:25 oscar Note Added: 0016978
2012-07-16 16:26 oscar File Added: common_query.php.patch
2012-08-17 18:41 fman Issue cloned: 0005149
2012-08-17 18:42 fman Task Workflow Status => TBD
2012-08-17 18:42 fman Summary Requirement based Report should have Test Plan as a parameter => CONTRIBUTION - contrib-multiplans-reports
2012-08-17 18:42 fman Description Updated View Revisions
2012-08-27 20:51 frl Note Added: 0017170



Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker