-
Improvement
-
Resolution: Done
-
Neutral
-
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
- is depended upon by
-
MGNLDAM-1276 Implement Asset size filter
- Closed
- to be documented by
-
MGNLUI-8795 DOC: Document the new filterOperators
- Open