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

Can't search for document with underscore in title

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Not A Bug
    • Affects Version/s: 9.10-SNAPSHOT
    • Fix Version/s: 9.10
    • Component/s: Rest API

      Description

      Given a Note document with title some_thing, the following cURL requests and NXQL searches return zero results:

      curl -X GET '<NUXEO_SERVER>/nuxeo/api/v1/search/lang/NXQL/execute?query=SELECT+%2A+FROM+Document+WHERE+ecm%3Afulltext+%3D+%22some%5C_thing%22' -H 'Nuxeo-Transaction-Timeout: 3' -H 'X-NXproperties: *' -H 'X-NXRepository: default' -H 'content-type: application/json'
      
      curl -X GET '<NUXEO_SERVER>/nuxeo/api/v1/search/lang/NXQL/execute?query=SELECT+%2A+FROM+Document+WHERE+ecm%3Afulltext+%3D+%22some_thing%22' -H 'Nuxeo-Transaction-Timeout: 3' -H 'X-NXproperties: *' -H 'X-NXRepository: default' -H 'content-type: application/json'
      
      curl -X GET '<NUXEO_SERVER>/nuxeo/api/v1/search/lang/NXQL/execute?query=SELECT+%2A+FROM+Document+WHERE+ecm%3Afulltext+%3D+%22some\_thing%22' -H 'Nuxeo-Transaction-Timeout: 3' -H 'X-NXproperties: *' -H 'X-NXRepository: default' -H 'content-type: application/json'
      
      SELECT * FROM Document WHERE ecm:fulltext = "some_thing"
      
      SELECT * FROM Document WHERE ecm:fulltext = "some\_thing"
      
      SELECT * FROM Document WHERE ecm:fulltext = "some%5Fthing"
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: