[ https://issues.apache.org/jira/browse/OFBIZ-5701?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16185406#comment-16185406 ]
Jacques Le Roux commented on OFBIZ-5701: ---------------------------------------- Hi kieuanhvu, At revision: 1810054, I have reverted your patch (all branches) because it's not only a problem with Dynamic View Entities as reported by Pawan but also an issue with MSSQL as reported by Wei Zhang at OFBIZ-9676. Could you please see if you can provide a patch which is not an issue in these both cases? > Bug SQL Count Distinct command in GenericDAO.java > -------------------------------------------------- > > Key: OFBIZ-5701 > URL: https://issues.apache.org/jira/browse/OFBIZ-5701 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: Trunk > Reporter: kieuanhvu > Assignee: Jacques Le Roux > Fix For: Release Branch 13.07, Release Branch 14.12, Release > Branch 15.12, 16.11.04 > > Attachments: GenericDAO.java.patch, GenericDAO.java.patch, > SQLDistinctGenericDAO.diff, SQLDistinctGenericDAO.diff > > > I have encounter the problem is: How can ofbiz framework count distinct for > all selected fields in query function of delegator? Although > EntityFindOptions.setDistinct(true) and the selected fields are all field, > the ofbiz framework always count distinct follow only one field. > I have resolved problem as my attact file -- This message was sent by Atlassian JIRA (v6.4.14#64029)