Annotation Query, select multiple fields as tags

Grafana Dashboards
,
1

Howdy,

I am new to the annotation queries but understand that the main fields are event, event stop, text, and tags.

I am querying a ms sql database for event data to display as annotations in grafana. My query works as expected but I am only able to select one field as the tags type. When I attempt to select two fields as the tag type the query crashes as a 400 error.

My query below works as expected but I would really appreciate if someone had syntax or a method for selecting more than one column to produce more the than one tag

SELECT
m.event_start as time,
m.event as text,
m.siteid as tags

I have tried (), , {}, AND, &, and nothing has worked so far.

2

Hi @reisenrich1,

Welcome to the :grafana: community support forums !!

We are excited that you joined our OSS community. Please read about some of the FAQs in the community :slight_smile:

Did you already check the documentation regarding it i.e.

It should be possible to select 2 tags. For e.g. I use a test case and I was able to create multiple tags which got saved.

image
image1522×494 61.8 KB

Also found more examples in the Documentation for Annotations (it is for MySQL but should be compatible with MSSQL) where you have to define the Annotation Query via Dashboard => Settings => Annotation => Select the MSSQL Datasource and define the query:

Let us know if this helps.