# Named Query parameters not working as expected

**URL:** <https://forum.inductiveautomation.com/t/named-query-parameters-not-working-as-expected/60169>\
**Category:** Ignition\
**Tags:** ignition80, perspective\
**Created:** [May 30, 2022, 9:09am UTC](https://forum.inductiveautomation.com/t/named-query-parameters-not-working-as-expected/60169 "2022-05-30T09:09:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dean\_Walsh](https://avatars.discourse-cdn.com/v4/letter/d/8797f3/32.png) [@Dean\_Walsh](https://forum.inductiveautomation.com/u/Dean_Walsh)\
**Post date:** [May 30, 2022, 9:09am UTC](https://forum.inductiveautomation.com/t/named-query-parameters-not-working-as-expected/60169/1 "2022-05-30T09:09:09Z")

</div>

Im trying to use named queries to populate my graph and a parameter to select which column to select but it is using the parameter as a value rather than the name of the column to get its value from. I think these screenshots will describe it better.  
This is one of the queries i am using and i would like :vsdflow to correlate to one of the several Pump\_Flow’s, i have this bound to a custom property which makes the correct transformation.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/4/648ad6bfe367e7976ef6dc2faaca595dd4ea188b.png)  
The problem is this does not just replace the :vsdflow with Pump1\_Flow which is what i want to look up that column in my table, it instead uses the parameter as the actual value of the column instead of using it as a column to look up. as you can se in the series it just says Flow Rate: Pump1\_Flow  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/7/e7bdf68461f5430c354f84a1f36e1ad65871017f.png)  
Is this behavior expected or is it a bug? is there something im missing?

---

<div class="post-metadata">

**Author:** ![deon.korb](https://avatars.discourse-cdn.com/v4/letter/d/8c91f0/32.png) [@deon.korb](https://forum.inductiveautomation.com/u/deon.korb)\
**Post date:** [May 30, 2022, 9:31am UTC](https://forum.inductiveautomation.com/t/named-query-parameters-not-working-as-expected/60169/2 "2022-05-30T09:31:02Z")

</div>

You have it as a value parameter. It would need to be a query string parameter. That will come with all the associated drawbacks, e.g. SQL injection etc.

[Named Query Parameters - Ignition User Manual 8.1 - Ignition Documentation (inductiveautomation.com)](https://docs.inductiveautomation.com/display/DOC81/Named+Query+Parameters#NamedQueryParameters-QueryString)