Querying multi-tag fields with spaces in NocoDB: anyof filter not matching tags containing spaces

APIs
1

I’m using NocoDB to store records with multi-tag fields (e.g. “Scene,” “Mood”, etc.). Tags without spaces work fine when filtering via the REST API, but tags that include spaces (e.g. “Combat – Light”) fail to match. I’d like to filter my records by these multi-word tags but can’t figure out how to encode or quote them correctly in the where clause.

Request Example:

/tables/.../records?sort=Title&offset=0&limit=3&fields=Title%2CGenre%2CType%2CScene%2CMood%2CLoop%2CTempo%2CMusic+Genre%2CInstruments%2CLocation%2CYoutube+Link&where=%28Title%2Cisnot%2Cnull%29%7Eand%28Scene%2Canyof%2C%22Combat+-+Light%22%29

Records tagged with exactly Combat - Light are not returned. However, querying a single-word tag works as expected.

How can I correctly format the where clause (or otherwise configure NocoDB) to filter multi-tag fields when the individual tags contain spaces or special characters?

2

Hi @maxodors

Please try without wrapping your option with quotes.

So instead of this (Title,isnot,null)~and(Scene,anyof,"Combat+-+Light")
try following (Title,isnot,null)~and(Scene,anyof,Combat+-+Light)

1 Like