Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-5701

Bug SQL Count Distinct command in GenericDAO.java

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Reopened
    • Major
    • Resolution: Unresolved
    • Trunk, Upcoming Branch
    • None
    • framework
    • None
    • Bug Crush Event - 21/2/2015

    Description

      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

      Attachments

        1. GenericDAO.java.patch
          4 kB
          Jacques Le Roux
        2. GenericDAO.java.patch
          3 kB
          Jacques Le Roux
        3. SQLDistinctGenericDAO.diff
          3 kB
          kieuanhvu
        4. SQLDistinctGenericDAO.diff
          3 kB
          kieuanhvu

        Issue Links

          breaks

          Bug - A problem which impairs or prevents the functions of the product. OFBIZ-9676 Error of GROUP BY in MSSQL

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. OFBIZ-9428 getResultsSizeAfterPartialList() return wrong count with distinct() for View Entity

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              kieuanhvu kieuanhvu
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated: