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

Update JcrQueryBuilder to support filter by range, startwith

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Neutral
    • None
    • None
    • None

    Description

      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
      
      

      Checklists

        Acceptance criteria

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                  Created:
                  Updated:
                  Work Started:

                  Checklists

                    Task DoD