PerspectiveTable Columns Sort with Dataset

Ignition
,
1

I have a Perspective Table bound to a Named Query feeding a Dataset to it and I don't seem able to make columns sortable\editable in any way.

Does binding a Table to a dataset prevent column sorting and other editing of the table? Even resizing the columns seems impossible despite the options being selected.

2

Two things:

  1. Use an ORDER BY clause in your named query SQL to get the default / initial sort order.
  2. Set columns.n.sortable : true for each column n.
    For this (and many of the column properties) to work you need to define the columns.n.field property. Set each one to the exact name of the SQL data column. (Case matters.)
3 Likes
3

Thanks, number 1 was already in place but number 2 was the issue, the column names were placeholders and didn't match the SQL table's