CustomQueries
The CustomQueries table.
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | False |
Unique identifer |
Deleted | Bool | False |
Record deletion indicator |
Date_Entered | Datetime | False |
Date record created |
Date_Modified | Datetime | False |
Date record last modified |
Modified_User_Id | String | True |
User who last modified record |
Created_By | String | True |
User ID who created record |
Name | String | False |
Name of the custom query |
Description | String | False |
Full description of the custom query |
Custom_Query | String | False |
The SQL statement |
Query_Type | String | False |
The type of query (unused) |
List_Order | Int | True |
The relative order of this query (unused) |
Query_Locked | Bool | False |
Indicates whether query body (the SQL statement) can be changed |
Team_Id | String | False |
Team ID for the account |
Team_Set_Id | String | False | |
Acl_Team_Set_Id | String | False | |
Team_Count | String | False | |
Team_Name | String | False | |
Acl_Team_Names | String | True |