Bug 848114

Summary: Test case query results contain duplicates
Product: [Other] TCMS Reporter: Corey Welton <cwelton>
Component: Web UIAssignee: Zheng Liu <zheliu>
Status: CLOSED NOTABUG QA Contact: tools-bugs <tools-bugs>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 3.8.0CC: aigao, dli, fhuang, jcai, jianchen, junzhang, nli, ryang, vchen, xkuang, yuwang, zheliu
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-07-15 05:33:48 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
screenshot showing duplicate results none

Description Corey Welton 2012-08-14 16:22:32 UTC 
Description of problem:

Not sure exactly what causes this -- I haven't seen it before -- but apparently testcase search queries are (sometimes?) returning duplicate results

Version-Release number of selected component (if applicable):


How reproducible:


Steps to Reproduce:
1. Testing | Search Cases
2. enter a case summary of "activation keys" and choose product of "katello"; submit.  Alternately, use the following URL:
https://tcms.engineering.redhat.com/cases/?summary=activation+key&author=&product=313&plan=&is_automated=&category=&case_status=1&case_status=2&case_status=3&case_status=4&component=&bug_id=&tag__name__in=&a=search
3.  view results
  
Actual results:
Some duplicates appear in the search results

Expected results:
No duplicates appear in search results.


Additional info:
See forthcoming screenshot.
Comment 1 Corey Welton 2012-08-14 16:25:08 UTC 
Created attachment 604352 [details]
screenshot showing duplicate results
Comment 2 Zheng Liu 2012-08-23 05:32:10 UTC 
(In reply to comment #1)
> Created attachment 604352 [details]
> screenshot showing duplicate results

I tried but can not reproduce this bug.
Using above link will search 11 results sorted by created date/ID by default.

According to the attachment, I'm wondering if there are some other operations which cause this problem.(such as sort by summary or other field.)
If you can still reproduce it, could you please provide some detaild steps ?
Comment 3 yawei Li 2012-11-13 08:13:29 UTC 
Corey, would you please provide the detailed steps on how to reproduce it? If it is not reproduced, this bug will be closed.
Comment 4 fhuang 2014-07-15 05:33:48 UTC 
Can't reproduct with "activation keys" in product "katello" on product server with 3.8.8, close it.