Vtype in Pre-processing historical data

Ignition
1

I can’t find information about Vtype column in my database table after I enabled Pre-processed Partitions in tag history.

Does anyone know about it? Please let me know more details.

Vtype
0
1
2
4
5
6
34
38
64
97
98
101
102

Thanks

2

I found this from an old thread from Colby:

The vtype is used to indicate the role of the value, as well as the order for pre-processed windows. It is a bit flag value, so values can have multiple roles.

First off, 0 means that the value is the only value for the window. 1=min, 2=max, 4=last value in window, 32=“first” value (to order min and max), and 64=first value of window.

3

Thank you for your information jonathan.taylor.

I investigated my database and I found many values of vtype (0,1,2,4,5,6,34,38,64,97,98,101,102). Could you please give us more details about other numbers that aren’t mentioned in the Colby forum?

Thanks,

4

There are only those six values. The integer column represents a binary AND of the different values; for example, 102 means that the bits in position 64, 32, 4, and 2 are “on” - meaning that the flag for max, exit, first value, and entry are all set.

1 Like
5

That’s clear, thank you PGriffith and Jonathan.taylor