Table Binding Issue – Query Returns Data but Nothing Displays in Perspective Table

Ignition
1

image
image1134×742 49.3 KB

Hi everyone,

I'm working in Ignition Perspective and trying to bind a table to a query result, but the data doesn’t show up in the table component.
so what I did is created a direct SQL query binding on props.data of the Perspective table.
SELECT * FROM inventory

  • The query runs fine in the Database Query Browser, and returns rows.
  • The database connection is valid.
  • The Binding Preview in the property editor shows ... (no rows).

What am I missing? Is there a better way to display SQL query results in a Perspective table?

3

Moved duplicate into this post. Please do not double-post, per the rules.