Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-77191

User search can return duplicate results when using custom joins

    Details

      Description

      For User search, when you are doing custom sql joins that can return duplicate results, the search results return the duplicates rather than the distinct set of users. The results returned back should be a distinct set of user objects.

      This only occurs when:

      1. users.search.with.index=false (doing a database search)
      2. you are invoking UserLocalServiceUtil.search(..) where the params references a custom join that returns duplicate results

      This ticket LPS-66811 removed the "DISTINCT" because of a DB2 issue where ORDER BY columns did not match up with the SELECT columns. However, code has changed where ORDER by cols now match SELECT columns, so that is no longer an issue to include DISTINCT back in.

        Attachments

          Activity

            People

            • Assignee:
              brian.chan Brian Chan
              Reporter:
              wesley.gong Wesley Gong
              Participants of an Issue:
              Recent user:
              Csaba Turcsan
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 43 weeks, 2 days ago

                Packages

                Version Package
                7.0.0 DXP FP37
                7.0.0 DXP SP7
                7.0.5 CE GA6
                7.0.X
                7.1.0 M1
                7.1.X
                Master