Adhoc Charting using Query Tag

Ignition
1

Hi all!

We configured all our tags to have their historical data from SQL bridge transaction groups.
We are then hoping to trend these tags using Ad hoc charting. However, I don’t know how we will be able to do this.
I tried creating a query tag then drag this tag from tag browse tree to the easy chart but there are no data. Seems like by doing this, it can’t identify which is the value and the timestamp columns. I tried using the adhoc trend template in the Cloud Template Browser but it seems like it only shows tags which have tag historian enabled. Does anyone have suggestions on how we can do this?

Thanks a lot in advance!

2

Use DB pens. Don’t create query tags. You’ll need a custom tag drop routine to construct a DB tag with the appropriate table and column. You’ll have to store the meta-data for that somewhere. I’ve created custom description contents that encoded the necessary information.