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

Enable to use ILIKE and other case sensitive operations on the same field, with Elasticsearch

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.8.0-HF25, 6.0
    • Fix Version/s: 5.8.0-HF26, 6.0-HF01
    • Component/s: Elasticsearch
    • Tags:
    • Upgrade notes:
      Hide

      There is a new mapping for field that are queried with the ILIKE operator.

      You need to create a multi field like this:

          "my:field" : {
         "type" : "multi_field",
         "fields" : {
           "my:field" : {
             "index" : "no",
             "include_in_all" : "true",
             "type" : "string"
           },
           "lowercase" : {
             "type": "string",
             "analyzer" : "lowercase_analyzer"
          }
        }
      Show
      There is a new mapping for field that are queried with the ILIKE operator. You need to create a multi field like this: "my:field" : { "type" : "multi_field" , "fields" : { "my:field" : { "index" : "no" , "include_in_all" : " true " , "type" : "string" }, "lowercase" : { "type" : "string" , "analyzer" : "lowercase_analyzer" } }

      Description

      Since NXP-15842 we can use the ILIKE operation with a proper mapping,
      but this force the field to be analyzed in lowercase.
      This makes all the operator case insensitive and require to submit input in lower case.

      We should have a dedicated index field for the ILIKE operator, like we did for FULLTEXT or STARTSWITH.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: