PocketQuery - SQL Query Parameter to Template

[eminkevich_scg]

Hi,

Is there a way to reference a PocketQuery macro parameter in a template?

I have "hostname" param that is being passed to the SQL query:

select * from load_average where hostname=:hostname

can I reference the parameter in the template as well? Something like:

<script>

var options = { 
title: $hostname,
height: 300,
width: 600,
vAxis: { minValue: 0, maxValue: 1, format:'#%' },
hAxis: {slantedTextAngle:45},
legend: {position:'none'}
};

PocketQuery.chart('LineChart', options);

</script>

Thank you.

[Felix Grund (Scandio) · Accepted solution]

Hi Evgeny,

Yes you can! Try $queryParameters.hostname and it should work! Let me know if you need further help!

Regards, Felix

[eminkevich_scg]

Thank you! Works!