SavedQuery
This is a table representing the SavedQuery entities in Dynamics CRM.
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | String | False |
Unique identifier of the view. |
| AdvancedGroupBy | String | False |
Advanced Group By column. |
| ColumnSetXml | String | False |
Definition of the columns included in the view. |
| ComponentState | String | True |
For internal use only. |
| ConditionalFormatting | String | False |
Conditional formatting of this view |
| CreatedBy_Id | String | True |
Unique identifier of the user who created the view. |
| CreatedBy_LogicalName | String | True | |
| CreatedBy_Name | String | True | |
| CreatedOn | Datetime | True |
Date and time when the view was created. |
| CreatedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who created the savedquery. |
| CreatedOnBehalfBy_LogicalName | String | True | |
| CreatedOnBehalfBy_Name | String | True | |
| Description | String | False |
Description of the view. |
| FetchXml | String | False |
String specifying the query in Fetch XML language. |
| IsCustomizable | Boolean | False |
Information that specifies whether the view can be customized. |
| IsDefault | Boolean | False |
Information that specifies a default view. |
| IsManaged | Boolean | True |
Indicates whether the solution component is part of a managed solution. |
| IsPrivate | Boolean | True |
Indicates whether or not this is viewable by the entire organization. |
| IsQuickFindQuery | Boolean | False |
Information that specifies a quick find view. |
| IsUserDefined | Boolean | True |
Information that specifies whether the query was created by a user. |
| LayoutXml | String | False |
For internal use only. |
| ModifiedBy_Id | String | True |
Unique identifier of the user who last modified the view. |
| ModifiedBy_LogicalName | String | True | |
| ModifiedBy_Name | String | True | |
| ModifiedOn | Datetime | True |
Date and time when the view was last modified. |
| ModifiedOnBehalfBy_Id | String | True |
Unique identifier of the delegate user who last modified the savedquery. |
| ModifiedOnBehalfBy_LogicalName | String | True | |
| ModifiedOnBehalfBy_Name | String | True | |
| Name | String | False |
Name of the view. |
| OrganizationId_Id | String | True |
Unique identifier of the organization associated with the view. |
| OrganizationId_LogicalName | String | True | |
| OrganizationId_Name | String | True | |
| OrganizationTabOrder | Integer | True |
Default Organization tab order |
| OverwriteTime | Datetime | True |
For internal use only. |
| QueryAPI | String | True |
For internal use only. |
| QueryAppUsage | Integer | False |
For internal use only. |
| QueryType | Integer | False |
Type of the view. |
| ReturnedTypeCode | Integer | False |
Type of entity displayed in the view. |
| SavedQueryId | String | False |
Unique identifier of the view. |
| SavedQueryIdUnique | String | True |
For internal use only. |
| SolutionId | String | True |
Unique identifier of the associated solution. |
| StateCode | String | True |
Status of the view. |
| StatusCode | String | False |
Reason for the status of the view. |