[jira] [Commented] (OFBIZ-9428) getResultsSizeAfterPartialList() return wrong count with distinct() for View Entity

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-9428?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16119814#comment-16119814 ]

Renuka Srishti commented on OFBIZ-9428:
---------------------------------------

Thanks Jacques :)



On Mon, Aug 7, 2017 at 6:00 PM, Jacques Le Roux (JIRA) <[hidden email]>




--
Renuka Srishti

> getResultsSizeAfterPartialList() return wrong count with distinct() for View Entity
> -----------------------------------------------------------------------------------
>
>                 Key: OFBIZ-9428
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-9428
>             Project: OFBiz
>          Issue Type: Bug
>    Affects Versions: Trunk
>            Reporter: Renuka Srishti
>            Assignee: Jacques Le Roux
>             Fix For: Release Branch 13.07, Release Branch 14.12, Release Branch 15.12, 16.11.04
>
>
> Here is the code sample to test the issue
> {code}
> EntityListIterator productAssocListItr = null;
> productAssocListItr = from("ProductAndAssoc").distinct().queryIterator();
> productAssocListSize = productAssocListItr.getResultsSizeAfterPartialList();
> {code}
> productAssocListSize will differ from the actual distinct records in the ProductAndAssoc View Entity.
> This issue exists because it gives distinct records on the basis of the first column in the table.

--
This message was sent by Atlassian JIRA
(v6.4.14#64029)