Transform a Column

Ignition
,
1

Is there an easy way to transform a single column's value using a script?

I am rather new to this and looking for a way to transform the minutes remaining in an order to hours, so I just want to divide the returned value by 60 but I am not sure how to accomplish this for a column when the data is mapped to a dataset.

2

Can you do it in the query that's feeding the database?

SELECT
    ....,
    MinRemaining,
    FORMAT(MinRemaining / 60, 2) AS Hours
FROM
    ....

You can then display either column or both.

Note that in tables and SQL the phrase "transform a column" usually suggests converting a 1 column × n rows dataset into an n column × 1 row dataset. That's not what you're trying to do.

3

I don't really have access to the DB side of it and was looking for something specific to this component since the value is used and converted in other places like a label on other views.

4

If you have rights to Ignition Designer then you have rights to the SQL queries (unless they're stored procedures in the database - but then you can still create your own queries). Have a look at the binding on the table's PROPS.data.