How it works
Given this log entry:Dot notation only applies to JSON-format logs. logfmt and plain text logs have flat field structures — you cannot use dot notation with them.
Powered by Mintlify
Auto-generate your docs
Access nested JSON fields using dot notation in your WHERE expressions.
zeal 'FROM app.json WHERE request.headers.host = "api.example.com"'
{
"timestamp": "2024-01-15T10:30:06Z",
"level": "error",
"request": {
"method": "POST",
"path": "/api/users",
"headers": {
"host": "api.example.com"
}
},
"status": 500
}
# Top-level field
zeal 'FROM app.json WHERE status = 500'
# One level deep
zeal 'FROM app.json WHERE request.method = "POST"'
# Two levels deep
zeal 'FROM app.json WHERE request.headers.host = "api.example.com"'
# Substring search on a nested field
zeal 'FROM app.json WHERE request.path CONTAINS "/api/users"'
# Combine nested and top-level conditions
zeal 'FROM app.json WHERE request.method = "POST" AND status >= 500'
# Group by a nested field
zeal 'FROM app.json WHERE level = "error" GROUP BY request.method'