Can I include an emoji to a variable value in Grafana?

Grafana
1

Hi,

I want to include an emoji to the variable value. Is there a way to achieve that.
My data source is SQL server.

Query:
select case when '$Ineffective' = 'Ineffective' then 'Ineffective ❌' else 'Error' end

I get the output as Ineffective ? but I want it to be Ineffective ❌

Can someone help me with it?

2

try one of the html codes:

3

@sowdenraymond I tried as below:
select case when '$Ineffective' = 'Ineffective' 'Ineffective ❌' else 'Error' end

But I got output as Ineffective ❌

4

Hello,

You can try with escaping:

select case when '$Ineffective' = 'Ineffective' 'Ineffective \❌' else 'Error' end

Regards

5

what is your datasource? See the N notation in the query before the ‘Ineffective :x:’

select 
     case when '$Ineffective' = 'Ineffective' 
          then N'Ineffective ❌' else 'Error' end

image
image801×597 33.3 KB

2 Likes
6

Hi @codi639

Thanks a lot for the input. I tried, it didn’t work.

7

Hi @yosiasz

Thank you!

It worked. :clap:

1 Like