Grafana Logs Panel + MSSQL

What kind of data Grafana Log Panel expects from data source? Documentation does not say a word about it. /docs/grafana/next/visualizations/logs-panel/

Gauge / Graph query stucture does not work, other fields does not work for me too

SELECT
  le.Date as time,
  123 as value,
  'xxx' as metric
FROM [LogEntry] le
WHERE
  $__timeFilter(le.Date)
ORDER BY
  le.Date ASC

I expect it to work with something like query below, at least displaying date and text should be trivial.

SELECT
      le.Date as time,
      'anything' as text
    FROM [LogEntry] le
    WHERE
      $__timeFilter(le.Date)
    ORDER BY
      le.Date ASC

Hi there!

I had the same problem and I did the following:

SELECT
	j.created_on as time,
	j.notes
FROM issues i
inner join journals j on j.journalized_id=i.id
WHERE (LENGTH(j.notes) >= 3) and i.id = 133673
order by j.id desc
limit 1

Used “Format as Table”.

Hope you be succeded!

also if you have level column in db, it would be also useful, if it will be included as 3rd column in result, like:
select time, message, level from log_records