# Best way to display results of a SQL query?

**URL:** <https://forum.inductiveautomation.com/t/best-way-to-display-results-of-a-sql-query/116725>\
**Category:** Ignition\
**Tags:** scripting, perspective\
**Created:** [August 10, 2026, 7:36am UTC](https://forum.inductiveautomation.com/t/best-way-to-display-results-of-a-sql-query/116725 "2026-08-10T07:36:11Z")\
**Posts on this page:** 1\
**Showing post:** 2

<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:** [August 10, 2026, 10:12am UTC](https://forum.inductiveautomation.com/t/best-way-to-display-results-of-a-sql-query/116725/2 "2026-08-10T10:12:15Z")

</div>

I would recommend, creating a property (or multiple) which holds the raw data. Only filterd by parameters which are the same for all data (e.g. a date range). Then I would use expression bindings with a lookup expression to filter and retrieve the appropriate cell data from that property.

Also, If you haven't yet and you have the ability to add a 3rd Party module, I would strongly recommend that you look into [Automation Professionals' Integration Toolkit Module](https://forum.inductiveautomation.com/t/automation-professionals-integration-toolkit-module/74934). It has a whole array of extreamly useful expression functions which are geared towards exactly this type of use case.

---

_[View the full topic](https://forum.inductiveautomation.com/t/best-way-to-display-results-of-a-sql-query/116725)._