Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-15596

Wiki index shows double entries or performs erratic when descriptors use aliases

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 9.7, 10.4
    • Fix Version/s: None
    • Component/s: Query
    • Labels:
      None
    • Difficulty:
      Unknown
    • Similar issues:

      Description

      Because of XWIKI-15595, the wiki index can show duplicated and incomplete entries when at least one descriptor has set up an alias.

      Until XWIKI-15595, a possible solution (tried with good results) is to update the Wiki index query to use an explicit "SELECT DISTINCT" clause instead of relying on the currently problematic "unique" query filter.

      This implies updating WikiManager/WikisLiveTableResultsMacros from:

      #set($sql = "$countSql $!{orderSql}")
      

      to

      #set($sql = "select distinct doc.fullName from XWikiDocument doc $countSql $!{orderSql}")
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                tmortagne Thomas Mortagne
                Reporter:
                enygma Eduard Moraru
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: