Vision Power Table columns

Ignition
1

Hi,

Could anybody please help with the easiest way to re-order the columns in a power table in the desired order, from left to right?
And I mean at startup and not by re-ordering them manually.

Thanks!

2

In designer, you should be able to hit preview and then drag the columns in the order you want.
When you are done stop the preview and uncheck the Columns Re-Orderable option. Note though... any changes and I think that the order resets.

Another option is to use the columnRearrange expression: columnRearrange - Ignition User Manual 8.1 - Ignition Documentation to programmatically set the columns in order from the originating dataset.

3

The easiest way, hands down, is to make your query return them in the desired order.

1 Like
4

Would you mind giving me an example of the query?
Tx!

5 
SELECT columnA, columnB, columnC
FROM someTable
WHERE someCondition
ORDER BY anotherColumn

The order in the SELECT section is the order you get in the dataset. Which becomes the default order in a Vision table.

If you have an asterisk wildcard in your query, get rid of it. Use explicit column names, or you are at the mercy of your database administrators.

6

much appreciated
worked

7

I have a SQL query that returns in the desired order and the data prop shows this correct order on the power table, but if I use table customer to hide columns the order changes, shown incorrectly on viewDataset prop. Any idea what I'm overlooking?

8

Hmm. Never seen that. Version? Sample dataset?

9

I don't have a sample, but sounds like this is abnormal so I'll create a ticket and have IA take a look tomorrow. Thanks for the reply Phil.

Edit, v8.1.44

1 Like
10

I'll admit to rarely using the view dataset, so who knows how long its been like this. (I tend to filter outside the table with my toolkit functions.)

11

IA couldn't find anything wrong and I decided to delete the power table and start over, it works, so I guess a gremlin found its way inside my project.

1 Like