I’m trying to create a query that will filter by part of an IP Address. I want to use postgres’s split_part method but I’m having trouble getting my query to work. For my variable query:
SELECT split_part(ip_address, '.', 3) FROM db
I’m new to Grafana so why am I getting a bad request for this? Doesn’t Grafana recognize postgres functions?