MantisBT - TestLink
View Issue Details
0008932TestLinkDatabase Generalpublic2020-06-06 00:562020-06-13 09:13
arunacha 
fman 
highmajoralways
resolvedfixed 
1.9.20 
1.9.20_fixed 
mysql
browser
7.3.16
TBD
0008932: Search Requirement is listing all the available requirement - Not honoring the input given to the search
the 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
Create some requirement and use the search Requirement option
No tags attached.
png Requirements.png (65,441) 2020-06-06 14:52
http://mantis.testlink.org/file_download.php?file_id=5353&type=bug
png

png searchfailure.png (110,454) 2020-06-06 14:54
http://mantis.testlink.org/file_download.php?file_id=5354&type=bug
png
Issue History
2020-06-06 00:56arunachaNew Issue
2020-06-06 10:04fmanNote Added: 0029734
2020-06-06 10:04fmanAssigned To => fman
2020-06-06 10:04fmanStatusnew => feedback
2020-06-06 14:52arunachaFile Added: Requirements.png
2020-06-06 14:54arunachaFile Added: searchfailure.png
2020-06-06 14:55arunachaNote Added: 0029736
2020-06-06 14:55arunachaStatusfeedback => assigned
2020-06-07 17:04fmanNote Added: 0029742
2020-06-08 04:13arunachaNote Added: 0029745
2020-06-08 04:13arunachaNote Edited: 0029745bug_revision_view_page.php?bugnote_id=29745#r6074
2020-06-08 06:51fmanNote Added: 0029748
2020-06-08 19:28fmanQA Team - Task Workflow Status => TBD
2020-06-08 19:28fmanFixed in Version => 1.9.20_fixed
2020-06-08 19:28fmanNote Added: 0029751
2020-06-08 19:29fmanStatusassigned => feedback
2020-06-10 02:36arunachaNote Added: 0029753
2020-06-10 02:36arunachaStatusfeedback => assigned
2020-06-13 09:13fmanStatusassigned => resolved
2020-06-13 09:13fmanResolutionopen => fixed

Notes
(0029734)
fman   
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   
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   
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   
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   
2020-06-08 06:51   
Thanks a lot
(0029751)
fman   
2020-06-08 19:28   
https://github.com/TestLinkOpenSourceTRMS/testlink-code/commit/7503515a322f9dc98e76edade9fe5e48689711a1 [^]
(0029753)
arunacha   
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.