Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is …

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 22700 - ???
    • 22701 - ???
    • 22702 - ???
    • 22703 - ???

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
AdvQueryNode.BuilderOptions nvarchar(50)
AdvQueryNode.ClassTypeID int Identifier for the Type of Object
AdvQueryNode.CriteriaImageIndex int
AdvQueryNode.CriteriaType int
AdvQueryNode.DefinitionDisplayString nvarchar(50)
AdvQueryNode.FieldAggrFunc int
AdvQueryNode.FieldAliasName nvarchar(50)
AdvQueryNode.FieldFormat nvarchar(50)
AdvQueryNode.FieldName nvarchar(150)
AdvQueryNode.FieldOrderByIndex int
AdvQueryNode.FieldSelectionIndex int
AdvQueryNode.GroupID int
AdvQueryNode.ID int Primary Key for the Table
AdvQueryNode.ImageIndex int
AdvQueryNode.InputOption int
AdvQueryNode.InstanceDisplayString nvarchar(50)
AdvQueryNode.IsActive bit Not Used for This Table
AdvQueryNode.IsSystem bit Used to Mark Required Records
AdvQueryNode.ModifiedByComputer nvarchar(25) HostName of computer that last modified this record
AdvQueryNode.ModifiedByUser nvarchar(25) Windows User who last modified this record
AdvQueryNode.ModifiedDate datetime DateTime this Record was last modified
AdvQueryNode.NodeTableName nvarchar(50)
AdvQueryNode.NodeTableType int
AdvQueryNode.NodeText nvarchar(50)
AdvQueryNode.Operator int
AdvQueryNode.ParentClassTypeID int
AdvQueryNode.ParentID int ID of Category/Group Above
AdvQueryNode.QueryFieldNameForDisplay nvarchar(50)
AdvQueryNode.QueryFieldNameForValue1 nvarchar(50)
AdvQueryNode.QueryFieldNameForValue2 nvarchar(50)
AdvQueryNode.SeqID int
AdvQueryNode.SortIndex int
AdvQueryNode.SpawnIntoParentCategory bit
AdvQueryNode.StoreID int Not Used.
AdvQueryNode.UseRelativeDate bit
AdvQueryNode.Value1 nvarchar(50)
AdvQueryNode.Value2 nvarchar(50)
AdvQueryNode.ValueFormat nvarchar(50)
AdvQueryNode.VirtualQueryName nvarchar(50)

Related Tables

You could leave a comment if you were logged in.