How to filter your request? What is the syntax for the filter parameter?
...
Extra | Explanation |
|---|---|
Text type fields (VARCHAR, TEXT) | Alle diacritics are replaced with normal characters (using the zappdiacritics) e.g. Citroën > Citroen |
Field: Licenceplate | All minus characters are removed e.g. KZ-313-X > KZ313X |
like and ilike operators | Values with the expression like and ilke are automatically supplied with % <percent> e.g. field[like]:"dam" > like "%dam%" Date and datetime fields have to be formated like: YYYY-MM-DD HH24:MI |
Samples
| Code Block | ||
|---|---|---|
| ||
# Sample: Search on licence plate license_plate[eq]:"kz-313-x" # Sample: Search on two vehicle ID's with an OR expression (-vehicle_id[eq]:60CEB4E9-9077-440E-9C01-29754A4C2EEE,-vehicle_id[eq]:E506CB2B-5972-4D17-9B06-6004B8978FFF) # Sample: Find all vehicles without a brand, empty "" or null (brand[eq]:"",-brand[eg]:null) /# Sample: Find vehicles with brand Fiat or Volvo (brand[eg]:"fiat",-brand[eg]:"volvo") # Sample: Find vehicle created between januari and februari created_date[ge]:"2019-01-01",created_date[le]:"2019-03-01" # Sample: Find all articles without description description[nq]:null # Sample: search on id's (multiple seperated bij semi-colon ;) in table user_id[in]:'60CEB4E9-9077-440E-9C01-29754A4C2EEE;60CEB4E9-9077-440E-9C01-29754A4C2EEE' |
| Note |
|---|
Error messages
Meaning: The block hooks are not valid Error: Filter not valid Meaning: Multiple filters are not separated correctly |
Related articles
| Filter by label (Content by label) | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
...