# executeQuery vs Query Tag

**URL:** <https://forum.inductiveautomation.com/t/executequery-vs-query-tag/108731>\
**Category:** Ignition\
**Tags:** perspective, ignition81\
**Created:** [July 21, 2025, 3:23pm UTC](https://forum.inductiveautomation.com/t/executequery-vs-query-tag/108731 "2025-07-21T15:23:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pat\_Cunningham](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pat_cunningham/32/57710_2.png) [@Pat\_Cunningham](https://forum.inductiveautomation.com/u/Pat_Cunningham)\
**Post date:** [July 21, 2025, 3:23pm UTC](https://forum.inductiveautomation.com/t/executequery-vs-query-tag/108731/1 "2025-07-21T15:23:12Z")

</div>

I can create a Query Tag that works fine and gets the results I would expect but if I try to run the exact same query using executeQuery in an expression I get "Invalid object name". I have tried with multiple queries and used different database connections.

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [July 21, 2025, 3:29pm UTC](https://forum.inductiveautomation.com/t/executequery-vs-query-tag/108731/2 "2025-07-21T15:29:50Z")

</div>

By default I don't believe base Ignition has any expression functions that allow you to call a query outside of using `runscript`. Can you show your expression/binding configuration?

> **[Expression Functions | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/appendix/expression-functions)**
>
> The expression language is used to define dynamic values for component properties and expression tags. Expressions often involve one or more other values that are used to calculate a final value. Expressions don't do anything, other than return a...

---

<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:** [July 21, 2025, 3:34pm UTC](https://forum.inductiveautomation.com/t/executequery-vs-query-tag/108731/3 "2025-07-21T15:34:54Z")

</div>

I couldn't find any docs on `executeQuery` but it does get syntax highlighting in the expression edit area. Maybe a deprecated expression function?

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [July 21, 2025, 3:37pm UTC](https://forum.inductiveautomation.com/t/executequery-vs-query-tag/108731/4 "2025-07-21T15:37:34Z")

</div>

Found it, it was removed in v8.0.0. All the more reason to not use it on 8.1.x

> **[executeQuery | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/deprecated/database-expression-functions/executeQuery)**
>
> Executes a select query using the given ConnectionName (or the default connection it omitted) and stores the result into a global ResultSetName.

---

<div class="post-metadata">

**Author:** ![Pat\_Cunningham](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pat_cunningham/32/57710_2.png) [@Pat\_Cunningham](https://forum.inductiveautomation.com/u/Pat_Cunningham)\
**Post date:** [July 21, 2025, 6:55pm UTC](https://forum.inductiveautomation.com/t/executequery-vs-query-tag/108731/5 "2025-07-21T18:55:59Z")

</div>

Thanks for the help.