Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Version published after converting to the new editor

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

...