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.

Tableau Connector for Microsoft Dynamics CRM

SavedQuery

Columns