Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

How to filter your request, syntax for the filter parameter

...

ExtraExplanation
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
languagejs
titleSamples
// 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
titleError messages


Error: 
QueryOperator not valid

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)
showLabelsfalse
max5
spacescom.atlassian.confluence.content.render.xhtml.model.resource.identifiers.SpaceResourceIdentifier@82a
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ( "autoflex10" , "developer" ) and type = "page" and space = "ISN"
labelsRapporten Rapport rapportage autoflex10 Verkoop auto inkoop facturen

...