# Scripts in SQL query?

**URL:** <https://forum.inductiveautomation.com/t/scripts-in-sql-query/10828>\
**Category:** Ignition\
**Created:** [November 25, 2015, 10:44pm UTC](https://forum.inductiveautomation.com/t/scripts-in-sql-query/10828 "2015-11-25T22:44:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![bryce.troy](https://avatars.discourse-cdn.com/v4/letter/b/ecb155/32.png) [@bryce.troy](https://forum.inductiveautomation.com/u/bryce.troy)\
**Post date:** [November 25, 2015, 10:44pm UTC](https://forum.inductiveautomation.com/t/scripts-in-sql-query/10828/1 "2015-11-25T22:44:47Z")

</div>

I would like to be able to call a gateway script from a SQL SELECT query, in order to convert an error code to readable text. Something like this:

`SELECT code, shared.control.codeMessage(code) AS message FROM error_log
`  
So far, no go. Any suggestions to get something like this to work??

Bryce Troy  
Left Hand Brewing Company

---

<div class="post-metadata">

**Author:** ![sngeru](https://avatars.discourse-cdn.com/v4/letter/s/ac91a4/32.png) [@sngeru](https://forum.inductiveautomation.com/u/sngeru)\
**Post date:** [November 26, 2015, 12:09am UTC](https://forum.inductiveautomation.com/t/scripts-in-sql-query/10828/2 "2015-11-26T00:09:29Z")

</div>

Bryce,

As long as something valid is getting returned from that function you should be able to do something like this to build out your SQL query.

fun = shared.scripts.returnSomething()

sqlQuery = “SELECT “+fun+” from sensors”

print sqlQuery

All my shared script is doing is returning a string value:

```auto
def returnSomething():
     return "something"
```

---

<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 26, 2015, 1:30am UTC](https://forum.inductiveautomation.com/t/scripts-in-sql-query/10828/3 "2015-11-26T01:30:55Z")

</div>

Seems a bit backward – I put a table of codes and messages in the DB, and have scripts look it up. But if that’s what you have to have, you could try the view() function from the [Simulation Aids](https://inductiveautomation.com/forum/viewtopic.php?f=50&t=14532) module. Feed it a dataset with the code numbers, and get a dataset with code vs message.