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

Make it possible to use the CONTAINS predicate on non-default fulltext indexes

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.4.2
    • Component/s: CMIS

      Description

      Nuxeo offers several configurable fulltext indexes:

      • defaul that aggregates all text data related to a given document (text fields and binary text extractions)
      • title that indexes only the tokens from the dc:title field
      • other administrator defined indexes in default-repository-config.xml

      Nuxeo services might want to use the CMIS query maker to able to perform JOIN queries on the repository while filtering on such custom indexes. The proposed change is to make the CMISQueryMaker microparse the prefix of the text passed as argument to the CONTAINS predicate to select the right index in Nuxeo without having to change the grammar of the CMIS SQL language.

      Hence SELECT dc:title FROM cmis:document WHERE CONTAINS('nx:title:some tokens to search for') will restrict the search to the "title" custom index, while SELECT dc:title FROM cmis:document WHERE CONTAINS('some tokens to search for') will use the "default" fulltext index.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: