# Way to copy named query parameters?

**URL:** <https://forum.inductiveautomation.com/t/way-to-copy-named-query-parameters/57330>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [March 17, 2022, 7:40pm UTC](https://forum.inductiveautomation.com/t/way-to-copy-named-query-parameters/57330 "2022-03-17T19:40:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [March 17, 2022, 7:40pm UTC](https://forum.inductiveautomation.com/t/way-to-copy-named-query-parameters/57330/1 "2022-03-17T19:40:47Z")

</div>

Been converting a bunch of queries to named queries recently. I will make my INSERT statement, add my 20 or 40 or however many parameters required for the columns. Then I will make a UPDATE statement, all the same parameters/parameter names, but I have to type them all in again.

I don’t know if there’s some clever way to copy/paste parameters from one named query to another, but given I still have many more tables and insert/update statements to go, a way to mitigate some of the repetitiveness would be nice. Not to mention, it would help avoid typos.

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [March 17, 2022, 7:49pm UTC](https://forum.inductiveautomation.com/t/way-to-copy-named-query-parameters/57330/2 "2022-03-17T19:49:17Z")

</div>

Dunno about clever, but once I have a Named Query created that has several common parameters, I just copy and paste the entire Named Query over and over. Then I just rename the query and change the query itself in each one.

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [March 17, 2022, 7:50pm UTC](https://forum.inductiveautomation.com/t/way-to-copy-named-query-parameters/57330/3 "2022-03-17T19:50:43Z")

</div>

Hah. Duh doy. Why didn’t I think of that? Been a long day…

---

<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:** [March 17, 2022, 8:43pm UTC](https://forum.inductiveautomation.com/t/way-to-copy-named-query-parameters/57330/4 "2022-03-17T20:43:27Z")

</div>

If you’re on a new enough version, named query parameters are just attributes of the `resource.json` file on disk.