[
https://issues.apache.org/jira/browse/OFBIZ-1514?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sharan Foga updated OFBIZ-1514:
-------------------------------
Sprint: Bug Crush Event - 21/2/2015
> Duplicates in Search Results
> ----------------------------
>
> Key: OFBIZ-1514
> URL:
https://issues.apache.org/jira/browse/OFBIZ-1514> Project: OFBiz
> Issue Type: Bug
> Components: product
> Affects Versions: Trunk
> Reporter: Joe Eckard
> Priority: Minor
> Attachments: keywords.xml, patch.txt
>
>
> If a product has multiple keywords with identical roots and different relevancy weights and the product is within a set of search results that span multiple pages, then it will be duplicated in the results display. This is because ProductSearch is doing a "distinct" on productId, relevancyWeight(s) instead of grouping by the productId. (And the attempt at duplicate removal only happens on a page-by-page basis.)
> I'm attaching a small proof-of-concept patch to make grouping by productId the default - it appears to work well with various combinations of search criteria (multiple keywords, features, feature cats, categories, etc.) but I haven't done a tremendous amount of testing. (Only using PostgreSQL and Derby)
> From the comments in the ProductSearch code it looks like it was done this way once, but it may have caused problems with Oracle. Does anyone know what that problem was, or can anyone check this patch against oracle?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
Locked
