Log filtering with chained operators

Last updated: February 6, 2026

This issue is applicable to customers matching these conditions

Plans: Any

Deployments: Any

Use case: Logs filtering with chained operators

Issue

While attempting to filter for specific logs with chained operators like:

metadata.user_id MATCH "xxxx-yyyy-zzzz-0000" OR metadata.user_id MATCH "xxxx-yyyy-zzzz-0000" OR metadata.user_id MATCH "xxxx-yyyy-zzzz-0000"

you notice the below error in the SQL editor modal:

Brainstore btql/query request failed 400 (Bad Request) after 7 ms: Json deserialize error: recursion limit exceeded at line 1 column

Cause

Chained OR queries are nested in JSON on the backend and hit the 128 query recursion limit.

Resolution

Use square brackets and the IN operator syntax for filtering metadata fields.

metadata.user_id in ['50157c3d-edd9-4287-85ee-48c119967099', 'a3fe059a-e4f4-4e9f-b3e3-0da04']