Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-8221

Documents created in old versions of Nuxeo DM cannot be found when doing a fulltext search on the title field only

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5
    • Fix Version/s: 5.6-RC1, 5.6
    • Component/s: Core VCS
    • Impact type:
      Content model Change
    • Upgrade notes:
      Hide

      On PostgreSQL the following SQL query updates the "fulltext_title" from the current value of the "dublincore:title" field and fixes the issue.

      UPDATE fulltext SET simpletext_title = NX_TO_TSVECTOR("dublincore"."title") FROM dublincore WHERE "fulltext"."id" = "dublincore"."id";

      Show
      On PostgreSQL the following SQL query updates the "fulltext_title" from the current value of the "dublincore:title" field and fixes the issue. UPDATE fulltext SET simpletext_title = NX_TO_TSVECTOR("dublincore"."title") FROM dublincore WHERE "fulltext"."id" = "dublincore"."id";

      Description

      Documents created before the configuration of the ecm:fulltext_title index in the postgresql repository configuration file are not completely indexed hence not suggested by the new searchbox0 suggestion feature introduced in 5.5 nor through the advanced search form (when using the "Title" search field).

      We could probably write a SQL migration script for such simple cases involving only simple text fields.

      However such migration script would not work for other more complex indices involving binaries or complex properties. For such hypothetical cases a batch re-indexing operation would probably be required at the core repository level.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: