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

Escape string values in Document.FetchByProperty operation

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.4
    • Fix Version/s: 5.6.0-HF08, 5.7.1
    • Component/s: Automation

      Description

      It's not possible to use Document.FetchByProperty to query for a property that has quotes in it.

      -> use SQLQueryParser.prepareStringLiteral to escape.

      Also, for optimization, the query should use IN operator instead of multiple clauses chained by ANDs.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: