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

Update JcrQueryBuilder to support filter by range, startwith

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Done
    • Icon: Neutral Neutral
    • 6.3.0
    • None
    • None

      JcrQueryBuilder currently support like and equal only, then we need support range of value.

      The with column filter, the property filter only support one value at a time, now, the filter has multiple values, then we have to add more code to tackle it.

      For example:

      datafilter.filter("propertyName", "START_WITH", ["a", "b","c"])
      
      SQL2 -> propertyName like "a%" or propertyName like "b%" or propertyName like "c%"
      
      datafilter.filter("propertyName", "EQUAL", ["a", "b","c"])
      
      SQL2 -> propertyName = "a" or propertyName = "b" or propertyName = "c"
      
      datafilter.filter("fileSize", BETWEEN, [1, 2])
      
      SQL2 -> fileSize >= 1 and fileSize <= 2
      
      

        Acceptance criteria

              plequoc Phong Le Quoc
              sang.ngo Sang Ngo Huu
              AuthorX
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved:
                Work Started:

                  Task DoD

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0d
                    0d
                    Logged:
                    Time Spent - 9.25d
                    9.25d