WHERE clause is returning no data even if the database contain data that should match with the WHERE clause

Problem

As soon as I add a “where” condition on my query, no data is returned.

Working, incomplete query (without WHERE clause)

Complete query (with WHERE clause. Not working)

Expected behaviour

The complete query should return data (percent_packet_loss field) where the host field is matching “001-Manifestation” (at least, in my screenshots).

Answer needed

  • Am I missing something in my query or something in my config?
    • If so, what?
  • If not, do you have any clue about how I could fix this?

Details

  • InfluxDB v1.7.8
  • Grafana CLI version 7.4.3
  • Grafana Server version 7.4.3