Query Builder: Can't select nested items in Log-, Resource-, and ScopeAttributes

[JLedel]

What happened:
When using the Grafana query builder, you can't filter on values inside any of the attribute JSON fields.

What you expected to happen:
Using ClickHouse for instance, you get a dropdown to enter (or select) the nested field and can query on it.

How to reproduce it (as minimally and precisely as possible):
In the query builder, select log_attributes. It is expected to get a second field to enter the key.

Screenshots
ClickHouse data source:

Anything else we need to know?:

Environment:

• Grafana version: v12.3.2
• Plugin version: 2.0.7
• OS Grafana is installed on: Kubernetes
• User OS & Browser: -
• Others: -

[sunchanglong]

Currently, the Query Builder does not support filtering on JSON data types natively. As a workaround, you can use the SQL Editor to write custom queries using JSON extraction functions.

For example, you can use the following SQL structure to filter by a JSON property:

SELECT 
    ts, 
    user_id, 
    json_get_string(metadata, '$.button_id') AS btn_id
FROM "activity_logs_json"
WHERE json_get_string(metadata, '$.button_id') = 'login_btn';

We have noted this as a feature gap for the Query Builder. Thanks for the feedback!"