filtered=[{
"id": "fullname", // for column name
"value": "test" // for value
},{
"id": "Author.fullname",
"value": "test"
},{
"id": "Categories.id",
"value": "ca6bc5d8-e843-4411-b52d-44d0c6b53263"
}]
- string
- sql =>
like "%value%"
orsubstring
[{"id": "nama", "value": "test"}]
- sql =>
- boolean
- sql =>
=
oreq
(equal)
or[{"id": "isRevision", "value": false}] // true or false
[{"id": "isRevision", "value": 0}] // 1 or 0
- sql =>
- number
- sql =>
=
oreq
(equal)[{"id": "stock", "value": 10}]
- sql =>
- date
- sql =>
between startOfDay(value) and endOfDay(value)
[{"id": "createdAt", "value": "2022-01-20"}]
- sql =>
-
Basic
- eq =>
= value
[{"id": "eq$code", "value": "AAB"}]
- ne =>
!= value
[{"id": "ne$code", "value": "AAB"}]
- is =>
IS NULL
[{"id": "is$PisauId", "value": null}]
- not =>
IS NOT TRUE
[{"id": "not$isRevision", "value": true}]
- eq =>
-
Comparison
- gt =>
> value
- date =>
> endOfDay(value)
- date =>
[{"id": "gt$stock", "value": 6},{"id": "gt$createdAt", "value": "2022-01-20"}]
- gte =>
>= value
- date =>
>= startDay(value)
- date =>
[{"id": "gte$stock", "value": 6},{"id": "gte$createdAt", "value": "2022-01-20"}]
- lt =>
< value
- date =>
< startDay(value)
- date =>
[{"id": "lt$createdAt", "value": 6},{"id": "lt$createdAt", "value": "2022-01-20"}]
- lte =>
<= value
- date =>
<= endOfDay(value)
- date =>
[{"id": "lte$createdAt", "value": 6},{"id": "lte$createdAt", "value": "2022-01-20"}]
- between =>
BETWEEN value[0] AND value[1]
- date =>
BETWEEN startOfDay(value[0]) and endOfDay(value[1])
- date =>
[{"id": "between$createdAt", "value": ["2022-01-20","2022-01-25"]}]
- notBetween =>
NOT BETWEEN value[0] AND value[1]
- date =>
NOT BETWEEN startOfDay(value[0]) and endOfDay(value[1])
- date =>
[{"id": "notBetween$createdAt", "value": ["2022-01-20","2022-01-25"]}]
- gt =>
-
Other
- in =>
> IN [value,value,...]
[{"id": "in$status", "value": ["staus1","status2"]}]
- notIn =>
NOT IN [value,value,...]
[{"id": "notIn$status", "value": ["staus1","status2"]}]
- like =>
LIKE 'value%'
orLIKE '%value%'
orLIKE '%value'
[{"id": "like$status", "value": "%disetujui"}]
- notLike =>
NOT LIKE 'value%'
orLIKE '%value%'
orLIKE '%value'
[{"id": "notLike$status", "value": "%disetujui"}]
- startsWith =>
LIKE 'value%'
[{"id": "startsWith$code", "value": "SPART"}]
- endsWith =>
LIKE '%value'
[{"id": "endsWith$code", "value": "002"}]
- substring =>
LIKE '%value%'
[{"id": "substring$name", "value": "Plate"}]
- in =>