Uploaded image for project: 'Nuxeo Studio'
  1. Nuxeo Studio
  2. NXS-5544

Optimize NXQL for querying field of type list

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: 3.18.4
    • Fix Version/s: 3.24.0
    • Component/s: Technical / Transverse

      Description

      When querying field of type list, we should use syntax "/*"

      Replace the following kind of queries:

      SELECT * FROM Document WHERE dc:subjects = 'foo'

      by:

      SELECT * FROM Document WHERE dc:subjects/* = 'foo'

        Attachments

          Issue Links

          depends on

          Improvement - An improvement or enhancement to an existing feature or task. NXS-5611 Refactor NXQL queries

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          links to

          Web Link NXQL | Nuxeo Documentation

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours, 30 minutes
                  2h 30m