Create table from SQL data

Maker
1

Hi there,

Whats the easiest way to create a table in ignition from SQL data?

2
  1. Write a named query.
  2. Drop a table component on the view.
  3. Create an SQL binding to your named query on props.data.

That gets you going.

  1. Then go to columns and hit the + icon several times until all your columns show again.
  2. Set each column's field property to the column name returned by the SQL query.
  3. Now select the rendering and format you want for each column using column.0.render, etc., and the numberFormat / dateFormat / boolean, etc. to suit the data being displayed.

I'm not familiar with Maker so there may be some limitations.