Table Panel trims leading + or 0 characters from SQL string

Grafana MySQL
,
1

Dear Community,

I wrote a simple SQL query that outputs phone-numbers as a string formatted like ‘+4912345678’.
When I create a panel, visualized as a table Grafana trims my leading ‘+’ or ‘00’ characters from the result field. I tried several things but cannot figure out on how to get the full string displayed.

This is the grafana output:

img1
img1693×207 31.9 KB

This is the actual SQL result:
img2

This is my query :slight_smile:
Select TOP(20)
FORMAT(CallReceived,‘HH:mm’) AS Call,
PhoneNumber AS Number,
ContactCompany AS Company,
ContactName AS Contact,
FROM
X
Order BY CallReceived DESC

2

Dear community. I’d be very grateful for any hint on how to resolve this.

3

Add a field override for the field, with “Unit” as “Misc → String”

2 Likes
4

Appreciate the tip but that’s nuts to have to do that. What would posses a sane person to format a string as a number by default?

5

Field override “Unit” as “Misc → String” is not working for me.

6

Is your issue also with Phone Numbers?

7

No. Actually I’ve now figured out that my trailing zeroes are missing from my source data, so Grafana isn’t causing it. :man_facepalming: