# INFO: Handling users external SQL database

**URL:** <https://forum.inductiveautomation.com/t/info-handling-users-external-sql-database/18237>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [May 31, 2018, 8:41am UTC](https://forum.inductiveautomation.com/t/info-handling-users-external-sql-database/18237 "2018-05-31T08:41:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![n.meluccio](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/n.meluccio/32/4858_2.png) [@n.meluccio](https://forum.inductiveautomation.com/u/n.meluccio)\
**Post date:** [May 31, 2018, 8:41am UTC](https://forum.inductiveautomation.com/t/info-handling-users-external-sql-database/18237/1 "2018-05-31T08:41:34Z")

</div>

Hello sirs,  
i would like to ask some detailed information about External User Database.

I’m using a custom sql table containing additional columns such as nation, gender, usercode, image and i would like to know how i can retrieve those infos with ignition functions.

Code:

```
Info_Utente = system.user.getUser("", Username)
print Info_Utente.getContactInfo() # Returns only User[username=XXX, firstname=null, lastname=null, roles=[Superuser]]

print Info_Utente.get(Info_Utente.FirstName) # Returns null
print Info_Utente.get(Info_Utente.LastName) # Returns null

```

Is there a way to retrieve all those custom user information that i have in the database ( language, nation, gender, usercode, image) with an internal function or should i query the Db with runPrepQuery?

Thank you,  
N.

---

<div class="post-metadata">

**Author:** ![bfuson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfuson/32/4597_2.png) [@bfuson](https://forum.inductiveautomation.com/u/bfuson)\
**Post date:** [May 31, 2018, 1:57pm UTC](https://forum.inductiveautomation.com/t/info-handling-users-external-sql-database/18237/2 "2018-05-31T13:57:03Z")

</div>

I don’t think it’s possible to extend the existing internal functions. I think you’ll need to run your own queries for those added fields.