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
You could leave a comment if you were logged in.