ihEnumeratedStates Table

The ihEnumeratedStates table contains information about enumerated sets that are defined in the system. The following table describes the columns of the ihEnumeratedStates table.

Table 1. ihEnumeratedStates Table
Column NameData TypeDescription
SetNameVT_BSTRThe name of the set.
DescriptionVT_BSTRThe description of the set.
NumberofStatesVT_I4The number of states a set contains.
NumberofTagReferencesVT_I4The number of tags with which a set is associated.
SetDataTypeVT_BSTRThe data type of the set.
AdministratorSecurityGroupVT_BSTRThe security group to which the set belongs.
LastModifiedUserVT_BSTRIndicates which user last modified the set.
LastModifiedTimeVT_DBTimeStampIndicates the last time the set was modified.
RowCountVT_I4Indicates the maximum number of rows that can be returned. A value of 0 indicates that there is no limit to the number of rows returned.

ihEnumeratedStates Examples

Sample SQL statements for the ihEnumeratedStates table are outlined in the following examples.

Example 1: Retrieve All States That Belong to a Specific Set

SELECT * FROM ihEnumeratedStates
WHERE setname=plcset1 order by statelowvalue ascending

Example 2: Retrieve All States From a Specific Set

SELECT * FROM ihEnumeratedStates
WHERE setname = 'setname'