# Table information

**URL:** <https://forum.inductiveautomation.com/t/table-information/28152>\
**Category:** Ignition\
**Created:** [September 10, 2019, 7:44pm UTC](https://forum.inductiveautomation.com/t/table-information/28152 "2019-09-10T19:44:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![DD\_Chelsea](https://avatars.discourse-cdn.com/v4/letter/d/b9e5f3/32.png) [@DD\_Chelsea](https://forum.inductiveautomation.com/u/DD_Chelsea)\
**Post date:** [September 10, 2019, 7:44pm UTC](https://forum.inductiveautomation.com/t/table-information/28152/1 "2019-09-10T19:44:18Z")

</div>

Hello guys, good morning.

I have a table where im registering the last 30 consoles sold, that table is not from a database. I’m using the cell update binding to register the data.

Now i want to display that data on a numeric text field for a certain console model sold.

I’m looking for a way to run a SQL Query on the table but i don’t see how without the table being in a database.

Is there a way to retrieve that information? For example how many consoles sold within those last 30 records?

Best regards.

---

<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:** [September 10, 2019, 8:33pm UTC](https://forum.inductiveautomation.com/t/table-information/28152/2 "2019-09-10T20:33:48Z")

</div>

You’ve just described my [view()](https://www.automation-pros.com/simaids/doc/expression.view.html) expression function, from the (free) [Simulation Aids](https://inductiveautomation.com/moduleshowcase/module/automation-professionals-llc-simulation-aids) module. It lets you use Pseudo-SQL to “query” an existing dataset.

(Broken in Ignition v8 at the moment, though…)

---

<div class="post-metadata">

**Author:** ![DD\_Chelsea](https://avatars.discourse-cdn.com/v4/letter/d/b9e5f3/32.png) [@DD\_Chelsea](https://forum.inductiveautomation.com/u/DD_Chelsea)\
**Post date:** [September 11, 2019, 2:38pm UTC](https://forum.inductiveautomation.com/t/table-information/28152/3 "2019-09-11T14:38:40Z")

</div>

Thanks for the help!

---

<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:** [September 12, 2019, 4:53pm UTC](https://forum.inductiveautomation.com/t/table-information/28152/4 "2019-09-12T16:53:59Z")

</div>

Updated Simulation Aids module for v8 is here:

[https://www.automation-pros.com/ignition/Simulation%20Aids-1.7.8.1909121622-v8.modl](https://www.automation-pros.com/ignition/Simulation%20Aids-1.7.8.1909121622-v8.modl)

It fixes some argument-checking bugs in the recorder() function.