How to filter your request, syntax for the filter parameter
...
Extra | Explanation |
---|---|
Text type fields (VARCHAR, TEXT) | Alle diacritics are replaced with normal characters (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 suplied with % <percent> e.g. field[like]:"dam" > like "%dam%" |
...
Code Block | ||||
---|---|---|---|---|
| ||||
// Search on licence plate license_plate[eq]:"kz-313-x" // 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) // Find all vehicles without a brand, empty "" or null (brand[eq]:"",-brand[eg]:null) // Find vehicles with brand Fiat or Volvo (brand[eg]=:"fiat",-brand[eg]=:"volvo") // Find vehicle created between januari and februari created_date[ge]:"2019-01-01",created_date[le]:"2019-03-01" // Find all articles without description description[nq]:null |
Note | ||
---|---|---|
| ||
Meaning: The block hooks are not valid Error: Filter not valid Meaning: Multiple filters are not separated correctly |
Gerelateerde artikelen
Filter by label (Content by label) | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...