# Report Query- Table name as parameter (7.9)

**URL:** <https://forum.inductiveautomation.com/t/report-query-table-name-as-parameter-7-9/43569>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [February 18, 2021, 3:23pm UTC](https://forum.inductiveautomation.com/t/report-query-table-name-as-parameter-7-9/43569 "2021-02-18T15:23:57Z")\
**Posts on this page:** 1\
**Showing post:** 5

<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:** [February 18, 2021, 4:07pm UTC](https://forum.inductiveautomation.com/t/report-query-table-name-as-parameter-7-9/43569/5 "2021-02-18T16:07:34Z")

</div>

> [@pturmel](#):
>
> You have to use string substitution. In a named query, this would be a parameter of type “QueryString” instead of type “Value”.
> 
> [Named Query Parameters - Ignition User Manual 8.1 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC81/Named+Query+Parameters)

Since you flagged this as 7.9, you may or may not have access to named queries.

You can also accomplish this within a script data source.

Here is a decent thread that covers a similar issue:

> [@Passing different datatypes tp a named query](http://forum.inductiveautomation.com/t/passing-different-datatypes-tp-a-named-query/40067/22):
>
> And if you want to do both the table name and the column name then you could do something like this: tableName ="binder\_names" columnName = "binder\_name" query = "UPDATE {0} SET {1}=? WHERE id=?".format(tableName,columnName) system.db.runPrepUpdate(query=query, args=args)

---

_[View the full topic](https://forum.inductiveautomation.com/t/report-query-table-name-as-parameter-7-9/43569)._