Unable to use context feature of Logs panel when used with grafana-clickhouse-datasource plugin

[sukhada369]

What happened:
This is for "Logs Panel" and Explorer window. I am able to see logs getting populated when grafana-clickhouse datasource is added. On the right side end of every logline there is a button to look at the context of the log. Over there I always see "Error loading more logs.". I have verified the configuration of the datasource and ensured to add correct info in "Context columns" section. I have tried adding other fields as well.

What you expected to happen:
I should be able to see surrounding logs or should be able to see some errors in Grafana logs on why it is not working

How to reproduce it (as minimally and precisely as possible):

• Create a table in clickhouse with minimal fields as time, message, logLevel, applicationName
• Connect this as a datasource on Grafana
• Ensure to configure "Context Column" section
• Go to explorer tab and execute a query which will get all these fields from the table
• Once logs are visible, click on the "context" button on the rightmost end of the logline

Anything else we need to know?:

• This is for an air gapped environment

Environment:

• Grafana version: 12.1.1
• Plugin version: 4.10.2
• OS Grafana is installed on: OEL8
• User OS & Browser: MAC, Google Chrome
• Others:

[SpencerTorres]

can you share a screenshot of what you're running on the explore tab? Log context doesn't work for raw SQL queries, only for the query builder log queries. I believe it also requires you to have a timestamp column set. You can also check the network log to see if any log context queries are running

[sukhada369]

@SpencerTorres , thanks. It does work with query builder. We heavily work with raw SQL queries and thereby could never see context feature working.
Could you please take this up as a feature request? It will be really helpful if the scope of this feature is mentioned in some document as well.

[sukhada369]

I tried to convert one SQL query to query builder. There are some problems that I am facing. Example: I cannot use any Grafana based variables here, cannot add any settings which I want to use on query level etc.

[vstariradev]

I'd also like to see this feature implemented. It'd help us with moving away from kibana.