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 |