# Help finding a runUpdateQuery

**URL:** <https://forum.inductiveautomation.com/t/help-finding-a-runupdatequery/30004>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [November 15, 2019, 4:31pm UTC](https://forum.inductiveautomation.com/t/help-finding-a-runupdatequery/30004 "2019-11-15T16:31:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ybfautom](https://avatars.discourse-cdn.com/v4/letter/y/eada6e/32.png) [@ybfautom](https://forum.inductiveautomation.com/u/ybfautom)\
**Post date:** [November 15, 2019, 4:31pm UTC](https://forum.inductiveautomation.com/t/help-finding-a-runupdatequery/30004/1 "2019-11-15T16:31:07Z")

</div>

Hello there,

I’m trying to find a runUpdateQuery tag script writing into my sql table in order to modify it.  
Typing “insert” and “update” keywords in the logger without results.  
Any help please?

Enrique

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/15fa0f25513ff23368492b7dc82293671706561b.png)

---

<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:** [November 15, 2019, 4:52pm UTC](https://forum.inductiveautomation.com/t/help-finding-a-runupdatequery/30004/2 "2019-11-15T16:52:19Z")

</div>

The logger would be `Gateway.Database.Updates` on TRACE - it won’t have the actual parameters, but will have the syntax of the statement.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [November 15, 2019, 5:04pm UTC](https://forum.inductiveautomation.com/t/help-finding-a-runupdatequery/30004/3 "2019-11-15T17:04:41Z")

</div>

I’d export your entire tag collection to XML then search that in your favorite code editor for ‘runUpdateQuery’. Look around at that point in the XML to identify the tag.

---

<div class="post-metadata">

**Author:** ![ybfautom](https://avatars.discourse-cdn.com/v4/letter/y/eada6e/32.png) [@ybfautom](https://forum.inductiveautomation.com/u/ybfautom)\
**Post date:** [November 15, 2019, 5:35pm UTC](https://forum.inductiveautomation.com/t/help-finding-a-runupdatequery/30004/4 "2019-11-15T17:35:39Z")

</div>

Thank you Paul, Phil nice tools for debugging,  
XML tags export solved my problem.  
It was a script into an UDT I forgot to look at.

Cheers