Mantis Bugtracker          
testlink.org

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008932TestLinkDatabase Generalpublic2020-06-06 00:562020-06-13 09:13
Reporterarunacha 
Assigned Tofman 
PriorityhighSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version1.9.20 
Fixed in Version1.9.20_fixed 
Summary0008932: Search Requirement is listing all the available requirement - Not honoring the input given to the search
Descriptionthe lib/requirements/regSearch.php constructs this query

 SELECT NH_REQ.name, REQ.id, REQ.req_doc_id, REQV.id as version_id, REQV.version, REQV.revision, -1 AS revision_id FROM requirements REQ JOIN nodes_hierarchy NH_REQ ON NH_REQ.id=REQ.id JOIN nodes_hierarchy NH_REQV ON NH_REQV.parent_id = NH_REQ.id JOIN req_versions REQV ON REQV.id=NH_REQV.id UNION ( SELECT NH_REQ.name, REQ.id, REQ.req_doc_id, REQR.parent_id AS version_id, REQV.version, REQR.revision, REQR.id AS revision_id FROM requirements REQ JOIN nodes_hierarchy NH_REQ ON NH_REQ.id=REQ.id JOIN nodes_hierarchy NH_REQV ON NH_REQV.parent_id = NH_REQ.id JOIN req_versions REQV ON REQV.id=NH_REQV.id JOIN req_revisions REQR ON REQR.parent_id=REQV.id ) ORDER BY id ASC, version DESC, revision DESC;

Which results all the available requirements for the selected project.
Not Listing as per the input REQ doc Id or testcase or create date
Steps To ReproduceCreate some requirement and use the search Requirement option
TagsNo tags attached.
Database (MySQL,Postgres,etc)mysql
Browserbrowser
PHP Version7.3.16
TestCaseID
QA Team - Task Workflow StatusTBD
Attached Filespng file icon Requirements.png [^] (65,441 bytes) 2020-06-06 14:52


png file icon searchfailure.png [^] (110,454 bytes) 2020-06-06 14:54

- Relationships

-  Notes
(0029734)
fman (administrator)
2020-06-06 10:04

>> Create some requirement and use the search Requirement option
Please refine it creating a good test case.

i.e.
Create REQ xxx with bla bla ...
Create REQ yyy with bla bla ...
Access search feature
set filter 1=xx , filter 2 = vvv

without this information unfortunately no action can be done on development side
(0029736)
arunacha (reporter)
2020-06-06 14:55

I had uploaded two screenshots one explains the Requirements and the Testcases associated with it.

From the search Requirements i tried to search with the Draft status and its not returning anything..
(0029742)
fman (administrator)
2020-06-07 17:04

Ok, I'm going to try to use the images but ..., If I'm kindly requested some written details, it's critic that you provide the information requests in the form requested and with the level of details requested
(0029745)
arunacha (reporter)
2020-06-08 04:13
edited on: 2020-06-08 04:13

I had created a new Requirement Specification as "Mantis Test Requirement Spec" with scope as System Requirement Specification.

In the Requirement Spec, i had created two Requirement as follows.
1. Doc ID as "Mantis1", title as "Test Requirement 1", status as "Draft" and NUmber of Testcases as "10".

2. Doc ID as "Mantis2", title as "Test Requirement 2", status as "Finish" and NUmber of Testcases as "5".


After this changed the Title message in the Requirment 1 and add a log message as "Title Changed".

After this i went to the search Requirement and searched with DocId as "Mantis1" and it dispayed "Your Search Delivered no results"'

I searched with status as "Draft" and it displayed "Your Search Delivered no reults"

I searched with Log Message "Title changed" and it displayed "Your Search Delivered no results"


Also i tried with Create Date From "6/7/2020" and it displayed "Your Search Delievered no results".

(0029748)
fman (administrator)
2020-06-08 06:51

Thanks a lot
(0029751)
fman (administrator)
2020-06-08 19:28

https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/7503515a322f9dc98e76edade9fe5e48689711a1 [^]
(0029753)
arunacha (reporter)
2020-06-10 02:36

Thanks for the support and quick fix.

The Search Requirement Functionality works perfectly for the cases listed by me in the earlier notes.

- Issue History
Date Modified Username Field Change
2020-06-06 00:56 arunacha New Issue
2020-06-06 10:04 fman Note Added: 0029734
2020-06-06 10:04 fman Assigned To => fman
2020-06-06 10:04 fman Status new => feedback
2020-06-06 14:52 arunacha File Added: Requirements.png
2020-06-06 14:54 arunacha File Added: searchfailure.png
2020-06-06 14:55 arunacha Note Added: 0029736
2020-06-06 14:55 arunacha Status feedback => assigned
2020-06-07 17:04 fman Note Added: 0029742
2020-06-08 04:13 arunacha Note Added: 0029745
2020-06-08 04:13 arunacha Note Edited: 0029745 View Revisions
2020-06-08 06:51 fman Note Added: 0029748
2020-06-08 19:28 fman QA Team - Task Workflow Status => TBD
2020-06-08 19:28 fman Fixed in Version => 1.9.20_fixed
2020-06-08 19:28 fman Note Added: 0029751
2020-06-08 19:29 fman Status assigned => feedback
2020-06-10 02:36 arunacha Note Added: 0029753
2020-06-10 02:36 arunacha Status feedback => assigned
2020-06-13 09:13 fman Status assigned => resolved
2020-06-13 09:13 fman Resolution open => fixed



Copyright © 2000 - 2020 MantisBT Team
Powered by Mantis Bugtracker