Updated: 2009-09-21



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is ...



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 22600 - Advanced Query



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| AdvQuery.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| AdvQuery.CreatedByID || int ||  ||   ||
|| AdvQuery.Description || ntext ||  ||   ||
|| AdvQuery.ID || int || Primary Key for the Table ||   ||
|| AdvQuery.IsActive || bit || Indicates if Enabled.  1Record is Active, 0Record is Not Active ||   ||
|| AdvQuery.IsPrivate || bit ||  ||   ||
|| AdvQuery.IsSystem || bit || Used to Mark Required Records ||   ||
|| AdvQuery.LastModifiedDate || datetime ||  ||   ||
|| AdvQuery.ModifiedByComputer || nvarchar(25) || HostName of computer that last modified this record ||   ||
|| AdvQuery.ModifiedByUser || nvarchar(25) || Windows User who last modified this record ||   ||
|| AdvQuery.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| AdvQuery.OwnedQuery || bit ||  ||   ||
|| AdvQuery.ParentClassTypeID || int ||  ||   ||
|| AdvQuery.ParentID || int || ID of Category/Group Above ||   ||
|| AdvQuery.ParentStoreID || int || Not Used. ||   ||
|| AdvQuery.QueryName || nvarchar(50) ||  ||   ||
|| AdvQuery.QuerySortFields || text ||  ||   ||
|| AdvQuery.QueryType || int ||  ||   ||
|| AdvQuery.QueryXML || text ||  ||   ||
|| AdvQuery.SeqID || int ||  ||   ||
|| AdvQuery.ShowRange || int ||  ||   ||
|| AdvQuery.ShowRangeCount || int ||  ||   ||
|| AdvQuery.StoreID || int || Not Used. ||   ||
|| AdvQuery.TableNodeID || int ||  ||   ||
Related Tables