ENUMNATIVEVALUE

The ENUMNATIVEVALUE modifier retrieves the native, numeric values such as 1 or 2 instead of string values such as on/off for the data that has enumerated states associated with it.

Example

Import this data to demonstrate the use of ENUMNATIVEVALUE:

[Tags]
Tagname,DataType,HiEngineeringUnits,LoEngineeringUnits
STATETAG,SingleInteger,60,0
[Data]
Tagname,TimeStamp,Value,DataQuality
STATETAG,06-Aug-2012 9:08:00.000,4,Good
STATETAG,06-Aug-2012 9:14:00.000,4,Good
STATETAG,06-Aug-2012 9:22:00.000,2,Good

Assume the tag has an enumerated set associated where 2=Stopped and 4=Running. When you do the interpolated query you get the string value:

set starttime='06-Aug-2012 09:10:00',endtime='06-Aug-2012 09:30:00' 
select timestamp,value,quality
from ihrawdata
where tagname = STATETAG and samplingmode=Interpolated and numberofsamples=6

Time Stamp	Value	Quality
8/6/2012 09:13:20	running	100.0000000
8/6/2012 09:16:40	running	100.0000000
8/6/2012 09:20:00	running	100.0000000
8/6/2012 09:23:20	stopped	100.0000000
8/6/2012 09:26:40	stopped	100.0000000
8/6/2012 09:30:00	stopped	100.0000000

Using the ENUMNATIVEVALUE query modifier, you can get the numeric value suitable for plotting

set starttime='06-Aug-2012 09:10:00',endtime='06-Aug-2012 09:30:00' 
select timestamp,value,quality
from ihrawdata
where tagname = STATETAG and samplingmode=Interpolated and numberofsamples=6 and criteriastring='#enumnativevalue'

Time Stamp	Value	Quality
8/6/2012 09:13:20	4	100.0000000
8/6/2012 09:16:40	4	100.0000000
8/6/2012 09:20:00	4	100.0000000
8/6/2012 09:23:20	2	100.0000000
8/6/2012 09:26:40	2	100.0000000
8/6/2012 09:30:00	2	100.0000000

Note: For bad data, the values are returned as string values based on the Enumerated State table though the enumerative value is set to FALSE.

Anticipated Usage

Use the ENUMNATIVEVALUE query modifier to plot tags that use enumerated values. You can put the string value in a data link and put the native value in a chart.