Can you search in the content of a JSON field

kobeaerts

7 months ago

2

{"category": "birds", "subcategory": "flying birds"}

• 

  denolfe

  Payload Team

  7 months ago

  Yes, you can use dot notation. It would be something like this:

  /api/collection-name?where[specifications.category][equals]=flying birds
  

  
  

  

  
• 

  kobeaerts

  7 months ago

  Aha, @denolfe that does indeed work but only with string values.

  
  

  It does perform queries on

  name="400"

  but not on

  name=400