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

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

      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%'

        Acceptance criteria

          1.
          		 Implementation Sub-task Completed Sang Ngo Huu

          100%
          Original Estimate - Not Specified Original Estimate - Not Specified
          Time Spent - 1.5d
          2.
          		 Review Sub-task Completed Roman Kovařík  
          3.
          		 Pre-int QA + PM Sub-task Completed Quach Hao Thien  
          4.
          		 QA Sub-task Closed Antonín Juran  
          5.
          		 Documentation Sub-task Completed Roman Kovařík  

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

                Created:
                Updated:
                Resolved:
                Work Started:

                  Task DoD

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