# Ignition datatable

**URL:** <https://forum.inductiveautomation.com/t/ignition-datatable/75441>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [June 23, 2023, 7:43am UTC](https://forum.inductiveautomation.com/t/ignition-datatable/75441 "2023-06-23T07:43:27Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vitaliy\_Galiy](https://avatars.discourse-cdn.com/v4/letter/v/3da27b/32.png) [@Vitaliy\_Galiy](https://forum.inductiveautomation.com/u/Vitaliy_Galiy)\
**Post date:** [June 23, 2023, 7:43am UTC](https://forum.inductiveautomation.com/t/ignition-datatable/75441/1 "2023-06-23T07:43:27Z")

</div>

Good afternoon, I have a problem. I have data that is written to the database every evening. I need to create a table and a window where you can select a date and from there extract the data into the table and show it to the user, it should also be possible to change the data at any time, thank you

---

<div class="post-metadata">

**Author:** ![Arnaud\_Declerck](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/arnaud_declerck/32/44872_2.png) [@Arnaud\_Declerck](https://forum.inductiveautomation.com/u/Arnaud_Declerck)\
**Post date:** [June 23, 2023, 8:44am UTC](https://forum.inductiveautomation.com/t/ignition-datatable/75441/2 "2023-06-23T08:44:35Z")

</div>

Database Type ? Mysql,MSsql,Postgres  
Table Structure ?  
Vision or Perspective?

Those info are needed before we can help you.  
You will need at least two queries. One select and one to update data.  
Regards

---

<div class="post-metadata">

**Author:** ![Vitaliy\_Galiy](https://avatars.discourse-cdn.com/v4/letter/v/3da27b/32.png) [@Vitaliy\_Galiy](https://forum.inductiveautomation.com/u/Vitaliy_Galiy)\
**Post date:** [June 23, 2023, 8:48am UTC](https://forum.inductiveautomation.com/t/ignition-datatable/75441/3 "2023-06-23T08:48:38Z")

</div>

Database MySQL,  
Vision  
Can u show some example

---

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [June 23, 2023, 9:10am UTC](https://forum.inductiveautomation.com/t/ignition-datatable/75441/4 "2023-06-23T09:10:12Z")

</div>

[https://docs.inductiveautomation.com/display/DOC81/Named+Query+Bindings](https://docs.inductiveautomation.com/display/DOC81/Named+Query+Bindings)

[https://docs.inductiveautomation.com/display/DOC81/Vision+-+Date+Range](https://docs.inductiveautomation.com/display/DOC81/Vision+-+Date+Range)

[https://docs.inductiveautomation.com/display/DOC81/Component+Events#ComponentEvents-CellEventHandlers](https://docs.inductiveautomation.com/display/DOC81/Component+Events#ComponentEvents-CellEventHandlers)

---

<div class="post-metadata">

**Author:** ![Arnaud\_Declerck](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/arnaud_declerck/32/44872_2.png) [@Arnaud\_Declerck](https://forum.inductiveautomation.com/u/Arnaud_Declerck)\
**Post date:** [June 23, 2023, 9:41am UTC](https://forum.inductiveautomation.com/t/ignition-datatable/75441/5 "2023-06-23T09:41:52Z")

</div>

I would suggest to use a select to get the data into a power table and then execute and update row query on a cell edited event

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [June 23, 2023, 12:03pm UTC](https://forum.inductiveautomation.com/t/ignition-datatable/75441/6 "2023-06-23T12:03:24Z")

</div>

The users on the forum are very helpful, but not many of them have the time or are willing to do all of the work for you.

What have you tried and what didn't work?

This should be a very simple window to create, and it's been a while, but I'm fairly certain that all the examples you need are available at Inductive University.

> **[DB Browse Binding - Dynamic Filters Video at Inductive University](https://inductiveuniversity.com/videos/db-browse-binding-dynamic-filters/8.1)**
>
> Learn how to use the DB Browse binding to filter results from values on the screen.

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [June 24, 2023, 12:27am UTC](https://forum.inductiveautomation.com/t/ignition-datatable/75441/7 "2023-06-24T00:27:33Z")

</div>

> [@lrose](#):
>
> but not many of them have the time or are willing to do all of the work for you.

If only there were companies that offered this service!! 🤣