Need to know the queries running behind inbuilt functions(calculative pen) in Ignition for cyclic , min and max calculations

Ignition
, ,
1

Need to know the logic behind the calculative pen functions with aggregate modes like
1)closest value
2)Minimum and maximum
3)Interpolation
4)Time weighted average
5)Simple average
6)sum
7)Range
8)standard deviation

Need to know the SQL query running behind this aggregation modes based on sampling size

2

Ignition’s tag historian does those calculations in java, not SQL. The SQL is complicated to support Ignition’s partitioning system and is considered an implementation detail. You really should not be trying to do this. If you must, good luck.

3

Tip: the syntax for numbered lists is 1. <list item>. The dot and space are important. You can reveal this and other markdown syntax by using the buttons on the editor toolbar. Especially important is the </> button for code formatting.

Welcome to the forum.

4

Thank you for your reply Pturmel. I know it is difficult to implement this but I need to do for sure for one of our main development works. If I get any help on this part it would be great. Irrespective of the language logic is written, to fetch data from database retrieval query is much needed. If I get to know that I can do my integration in database.