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

When searching for WebContent with orderByCol title, modified-date or display-date the same WebContent shows up multiple times in the results

    Details

      Description

      In the Control Panel I open the tab WebContent for a certain organisation. Dependending on the selected Order By Column sometimes the same result shows up multiple times in the result list. The total number of results is always correct.

      This happenes due to a problem in the construction of the GROUP BY clause for the SQL in the JournalArticleFinderImpl when the selected OrderByComparator does NOT have the "version" as a part of the ORDER_BY_FIELDS.

      http://svn.liferay.com/repos/public/portal/trunk/portal-service/src/com/liferay/portlet/journal/util/comparator/ArticleTitleComparator.java
      http://svn.liferay.com/repos/public/portal/trunk/portal-service/src/com/liferay/portlet/journal/util/comparator/ArticleModifiedDateComparator.java
      http://svn.liferay.com/repos/public/portal/trunk/portal-service/src/com/liferay/portlet/journal/util/comparator/ArticleCreateDateComparator.java

        Attachments

          Activity

            People

            • Assignee:
              tammy.fong Tammy Fong (Inactive)
              Reporter:
              mcbeelen Marco Beelen (Inactive)
              Participants of an Issue:
              Recent user:
              Esther Sanz
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                8 years, 4 weeks, 1 day ago

                Packages

                Version Package
                6.0.12 EE