Uploaded image for project: 'Magnolia UI'
  1. Magnolia UI
  2. MGNLUI-7755

Ability to improve JCR filtering performance by using STARTSWITH instead of CONTAINS operator

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Neutral
    • 6.3, 6.2.29
    • None
    • None
    • None

    Description

      Steps to reproduce

      1. Go to pages app
      2. Type "test" into filter of "Title" column
      3. Inspect query statement in JcrQueryBuilder#build() method (q.getStatement())

      Actual result:

      SELECT * FROM [nt:base] AS t WHERE ISDESCENDANTNODE(t, [/]) AND t.[jcr:primaryType] = 'mgnl:page' AND LOWER(t.title) LIKE '%test%' 

      Expected result:

      SELECT * FROM [nt:base] AS t WHERE ISDESCENDANTNODE(t, [/]) AND t.[jcr:primaryType] = 'mgnl:page' AND LOWER(t.title) LIKE 'test%' 

      Checklists

        Acceptance criteria

        Attachments

          Issue Links

            Activity

              People

                sang.ngo Sang Ngo Huu
                rico.jansen Rico Jansen
                Nucleus
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:
                  Work Started:

                  Checklists

                    Task DoD

                    Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - Not Specified
                      Not Specified
                      Logged:
                      Time Spent - 2d 2.5h
                      2d 2.5h