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.