{$page} 



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 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]