# Named Query - Parametrized column names in select

**URL:** <https://forum.inductiveautomation.com/t/named-query-parametrized-column-names-in-select/76962>\
**Category:** Ignition\
**Created:** [July 26, 2023, 6:58pm UTC](https://forum.inductiveautomation.com/t/named-query-parametrized-column-names-in-select/76962 "2023-07-26T18:58:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Babla\_Bogam](https://avatars.discourse-cdn.com/v4/letter/b/ecb155/32.png) [@Babla\_Bogam](https://forum.inductiveautomation.com/u/Babla_Bogam)\
**Post date:** [July 26, 2023, 6:58pm UTC](https://forum.inductiveautomation.com/t/named-query-parametrized-column-names-in-select/76962/1 "2023-07-26T18:58:20Z")

</div>

I am creating a named query to only get certain columns from a table (mssql) based on the requirement. I can parametrized the where conditions but was not sure if there was a way to parametrized the column names. For example - in some cases I want column1 but in other cases I want column1, column2 and in some cases only column3. Or my option is to use system.db.runPrepQuery and create dynamic select statement.

Thank you

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [July 26, 2023, 7:11pm UTC](https://forum.inductiveautomation.com/t/named-query-parametrized-column-names-in-select/76962/2 "2023-07-26T19:11:49Z")

</div>

You can accomplish this with a QueryString parameter type, but you are re-opening the SQL injection hole closed by named queries in the first place, so don't accept user input blindly.  
[https://docs.inductiveautomation.com/display/DOC81/Named+Query+Parameters#NamedQueryParameters-QueryString](https://docs.inductiveautomation.com/display/DOC81/Named+Query+Parameters#NamedQueryParameters-QueryString)

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [July 26, 2023, 7:23pm UTC](https://forum.inductiveautomation.com/t/named-query-parametrized-column-names-in-select/76962/3 "2023-07-26T19:23:08Z")

</div>

> [@Babla\_Bogam](#):
>
> Or my option is to use system.db.runPrepQuery and create dynamic select statement.

Or...you can create multiple Named Queries and call the query that you need when you need it.

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [July 26, 2023, 7:23pm UTC](https://forum.inductiveautomation.com/t/named-query-parametrized-column-names-in-select/76962/4 "2023-07-26T19:23:10Z")

</div>

It sounds like you are scripting this, so your named query could return all of the columns, and then the resultant dataset could be subsequently filtered in the script using [system.dataset.filterColumns](https://docs.inductiveautomation.com/display/DOC81/system.dataset.filterColumns)