# Creating Dynamic listings **URL:** \ **Category:** Ignition\ **Tags:** vision, ignition81\ **Created:** [August 21, 2026, 6:53pm UTC](https://forum.inductiveautomation.com/t/creating-dynamic-listings/116866 "2026-08-21T18:53:53Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![robert.canary](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@robert.canary](https://forum.inductiveautomation.com/u/robert.canary)\ **Post date:** [August 21, 2026, 6:53pm UTC](https://forum.inductiveautomation.com/t/creating-dynamic-listings/116866/1 "2026-08-21T18:53:53Z")
Hello, I read several of the posts about creating tables and lists. However, I need to create a dynamic table that populates only when needed. Example: A parcel sorter has 600 potential destinations (100 to 700) When a box is designated for a chute, I need that information to show up in the table. Once the box has been diverted, I need it to disappear. ---
**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:** [August 21, 2026, 7:04pm UTC](https://forum.inductiveautomation.com/t/creating-dynamic-listings/116866/2 "2026-08-21T19:04:16Z")
What tells the system of those two conditions? Are they events, like changes in tag values? ---
**Author:** ![robert.canary](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@robert.canary](https://forum.inductiveautomation.com/u/robert.canary)\ **Post date:** [August 21, 2026, 7:10pm UTC](https://forum.inductiveautomation.com/t/creating-dynamic-listings/116866/3 "2026-08-21T19:10:06Z")
Yes. When these are inducted, the system assigns them an ID and a destination (chute ID), based on the barcode. When it comes to that chute the system will divert it. ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [August 21, 2026, 7:12pm UTC](https://forum.inductiveautomation.com/t/creating-dynamic-listings/116866/4 "2026-08-21T19:12:58Z")
I would do this in a database table with an id, the destination chute and a status. - insert into the table when one is inducted - change the status when it is diverted, or if it's manually taken out of the queue. ---
**Author:** ![robert.canary](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@robert.canary](https://forum.inductiveautomation.com/u/robert.canary)\ **Post date:** [August 21, 2026, 7:18pm UTC](https://forum.inductiveautomation.com/t/creating-dynamic-listings/116866/5 "2026-08-21T19:18:34Z")
Yes and we do have that database. However, can I make it disappear from the display table when there is nothing in route to that chute. Basically I only want active traffic. ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [August 21, 2026, 7:27pm UTC](https://forum.inductiveautomation.com/t/creating-dynamic-listings/116866/6 "2026-08-21T19:27:03Z")
The query takes care of what to display As an example, when one is inducted, create a new entry in the table with a status of 0. When the package is sorted, set the status to 1 To display active parcels: ```sql SELECT * FROM my_table WHERE status=0 ``` ---
**Author:** ![robert.canary](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@robert.canary](https://forum.inductiveautomation.com/u/robert.canary)\ **Post date:** [August 21, 2026, 7:38pm UTC](https://forum.inductiveautomation.com/t/creating-dynamic-listings/116866/7 "2026-08-21T19:38:41Z")
I see where you're coming from. And I would set this to re-query every 2 seconds. No, here is the tricky part (something I have to be careful with) ... I only want this querying to happen when that screen (tab) is active. `SELECT * FROM my_table WHERE status=LogicallyFull` ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [August 21, 2026, 7:40pm UTC](https://forum.inductiveautomation.com/t/creating-dynamic-listings/116866/8 "2026-08-21T19:40:26Z")
I wouldn't worry about it, personally. I would make a query tag, and point all the clients that need it to that tag. ---
**Author:** ![robert.canary](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@robert.canary](https://forum.inductiveautomation.com/u/robert.canary)\ **Post date:** [August 21, 2026, 7:42pm UTC](https://forum.inductiveautomation.com/t/creating-dynamic-listings/116866/9 "2026-08-21T19:42:03Z")
Okay, this is on Vision at the moment. Next year, they want to convert this toPerspective so they can use HTTPS access. Would this solution work the same in Perspective? ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [August 21, 2026, 7:43pm UTC](https://forum.inductiveautomation.com/t/creating-dynamic-listings/116866/10 "2026-08-21T19:43:04Z")
Yes. I have a mix of clients here, all using that method. ---
**Author:** ![robert.canary](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@robert.canary](https://forum.inductiveautomation.com/u/robert.canary)\ **Post date:** [August 21, 2026, 7:46pm UTC](https://forum.inductiveautomation.com/t/creating-dynamic-listings/116866/11 "2026-08-21T19:46:38Z")
Thanks.