# Named queries for module developers **URL:** \ **Category:** Module Development\ **Tags:** namedqueries, ignition79, database\ **Created:** [June 15, 2017, 1:21pm UTC](https://forum.inductiveautomation.com/t/named-queries-for-module-developers/14524 "2017-06-15T13:21:31Z")\ **Posts on this page:** 9\ **Page:** 2
**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Post date:** [October 3, 2017, 6:59pm UTC](https://forum.inductiveautomation.com/t/named-queries-for-module-developers/14524/22 "2017-10-03T18:59:34Z")
@KathyApplebaum, have you an ETA for the 7.9.5 first beta ? ---
**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\ **Post date:** [October 3, 2017, 7:26pm UTC](https://forum.inductiveautomation.com/t/named-queries-for-module-developers/14524/23 "2017-10-03T19:26:05Z")
That’s a popular question today. 🙂 Hopefully within a week, if all goes well. ---
**Author:** ![cbabb](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cbabb/32/49029_2.png) [@cbabb](https://forum.inductiveautomation.com/u/cbabb)\ **Post date:** [October 18, 2017, 6:32pm UTC](https://forum.inductiveautomation.com/t/named-queries-for-module-developers/14524/24 "2017-10-18T18:32:00Z")
Named Queries are a real time saver and a great addition to the product. Any thoughts of adding the ability to use a named query in a SQL Query tag type in UDTs? ---
**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\ **Post date:** [October 18, 2017, 6:46pm UTC](https://forum.inductiveautomation.com/t/named-queries-for-module-developers/14524/25 "2017-10-18T18:46:26Z")
We’ve added named query client tags in 7.9.6. We’ll finish up the tag work (regular SQL named query tags and global named query resources which can be used across projects) in Ignition 8.0. In the mean time, you have to do a bit of a work around – an expression tag which uses a runScript to get the results of the named query. :\ ---
**Author:** ![cbabb](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cbabb/32/49029_2.png) [@cbabb](https://forum.inductiveautomation.com/u/cbabb)\ **Post date:** [October 18, 2017, 7:43pm UTC](https://forum.inductiveautomation.com/t/named-queries-for-module-developers/14524/26 "2017-10-18T19:43:58Z")
Thanks Kathy… I thought about that for a work around too but I can wait for 8… ---
**Author:** ![martinel37461](https://avatars.discourse-cdn.com/v4/letter/m/4da419/32.png) [@martinel37461](https://forum.inductiveautomation.com/u/martinel37461)\ **Post date:** [May 1, 2018, 2:52pm UTC](https://forum.inductiveautomation.com/t/named-queries-for-module-developers/14524/27 "2018-05-01T14:52:41Z")
Did a clear cache command get added? I’m running 7.9.5 but am not finding any commands to clear the cache and request fresh results. ---
**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:** [May 1, 2018, 3:12pm UTC](https://forum.inductiveautomation.com/t/named-queries-for-module-developers/14524/28 "2018-05-01T15:12:26Z")
Clearing the named query cache was added in two scripting functions in 7.9.6: [https://docs.inductiveautomation.com/display/DOC79/New+in+this+Version](https://docs.inductiveautomation.com/display/DOC79/New+in+this+Version) ---
**Author:** ![pdibenedetto](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pdibenedetto/32/6364_2.png) [@pdibenedetto](https://forum.inductiveautomation.com/u/pdibenedetto)\ **Post date:** [July 14, 2018, 5:04pm UTC](https://forum.inductiveautomation.com/t/named-queries-for-module-developers/14524/29 "2018-07-14T17:04:57Z")
What about adding database transaction support (tx optional argument, using the result of system.db.beginTransaction) to system.db.runNamedQuery, as same as other system.db.run\*\*\*\* functions? ---
**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\ **Post date:** [July 16, 2018, 1:52pm UTC](https://forum.inductiveautomation.com/t/named-queries-for-module-developers/14524/30 "2018-07-16T13:52:31Z")
It’s high on our list, but most of our devs are working on 8.0 right now, so we haven’t gotten to that one yet. [Previous page](https://forum.inductiveautomation.com/t/named-queries-for-module-developers/14524.md?page=1)