Reporting - Tag History Query Data - how to convert feet to inches

Ignition
,
1

Just trying to export from scada data daily for another platform.
(coding up another static table Report)

Just need to convert a few tank level from
feet
to
inches
(the perspective view does this by design for the web user, but I don't see a reporting option - other that python code - and a history query w python code takes a while over a basic tag history data source)

Checked the Docs
Checked the forum

Any and all options are appreciated.........

2

Modify the query.

SELECT
    Timestamp,
    Level * 12 AS LevelInches
FROM ...
3

Where in the normal report builder - tag history data source - can I modify the SQL?

Don't see that.

I assume you mean for a report - data source - sql query (which means parsing the history sql tables)

4

image
image1366×768 123 KB

5

There it is
Reporting
Tag historian query
after the data source alias is defined
in the Design Tab
inside the @_@
@tag_history.bulldog compressor station tank 1 oil * 12@

1 Like
6

No, you can't modify the SQL for a historian query. You will need to reprocess that result with a script datasource.

Or, if reporting in tabular form, just use a formula in the cell that normally would report the feet.

{ You will probably want to omit the tag_history. prefix from the column reference in the cell. }

7

There's a demonstration about 35 s in on the IU video.

8

Yep (you found it)

That is what I was looking for.

(wish there was a quick mention in the Docs - yes you can do data source key calc - go look here.......)