Using split_part in variable query (and regular query)

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?

Hi @sameerrao

Are you seeing any errors in the UI, in the developer tools (under network, for instance), or in the grafana logs when you run this? Let us know, and perhaps add a screenshot so we can help you resolve this :+1: