SavedQuery (View) Entity Metadata

Article
10/04/2013

[Applies to: Microsoft Dynamics CRM 2011]

The following information is for the saved query (view) entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is SavedQuery.

To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.

In This Topic

Entity Metadata

Privilege Metadata

Attribute Metadata

One-to-Many Relationships

Many-to-Many Relationships

Many-to-One Relationships

Entity Metadata

The following table shows the metadata for the saved query (view) entity.

Entity metadata property	Value
OTC	1039
EntityLogicalName	savedquery
DisplayName	View
DisplayCollectionName	Views
IsCustomizable	True
OwnershipType	OrganizationOwned
AutoRouteToOwnerQueue	False
CanBeInManyToMany	False
CanBePrimaryEntityInRelationship	False
CanBeRelatedEntityInRelationship	False
CanCreateAttributes	False
CanCreateCharts	False
CanCreateForms	False
CanCreateViews	False
CanModifyAdditionalSettings	True
CanTriggerWorkflow	False
IsActivity	False
IsActivityParty	False
IsAuditEnabled	False
IsAvailableOffline	True
IsChildEntity	False
IsConnectionsEnabled	canmodifyconnectionsettings
IsCustomEntity	False
IsDocumentManagementEnabled	False
IsDuplicateDetectionEnabled	False
IsEnabledForCharts	False
IsImportable	False
IsIntersect	False
IsMailMergeEnabled	False
IsManaged	True
IsMappable	False
IsReadingPaneEnabled	True
IsRenameable	False
IsValidForAdvancedFind	True
IsValidForQueue	False
IsVisibleInMobile	False
PrimaryIdAttribute	savedqueryid
PrimaryNameAttribute	name
ReportViewName	FilteredSavedQuery
Description	Saved query against the database.

Privilege Metadata

The following table shows the privilege metadata for the saved query (view) entity.

PrivilegeName	Id	Type	CanBeBasic	CanBeDeep	CanBeGlobal	CanBeLocal
prvCreateQuery	371f85f8-0d1b-4177-a790-550d371e91ec	Create	False	False	True	False
prvDeleteQuery	7389889c-4149-4f74-86f6-12c2a9cc577b	Delete	False	False	True	False
prvReadQuery	902d70d3-2ff8-4d93-92f9-8efdcf889af8	Read	False	False	True	False
prvWriteQuery	ece4c21d-060a-4e86-982b-f97410ca5f71	Write	False	False	True	False

Attribute Metadata

The following table shows the attribute metadata for the saved query (view) entity.

LogicalName	SchemaName	Type	RequiredLevel	IsValidForCreate	IsValidForRead	IsValidForUpdate	CanBeSecuredForCreate	CanBeSecuredForRead	CanBeSecuredForUpdate	IsCustomizable	IsAuditEnabled	IsManaged	IsPrimaryId	IsPrimaryName	IsRenameable	IsSecured	IsValidForAdvancedFind	DisplayName	DeprecatedVersion	Description
advancedgroupby	AdvancedGroupBy	String	None	True	True	True	False	False	False	True	True	True	False	False	False	False	False	Advanced Group By		Advanced Group By column.
canbedeleted	CanBeDeleted	ManagedProperty	SystemRequired	True	True	True	False	False	False	False	False	True	False	False	False	False	False	Can Be Deleted		Information that specifies whether the view can be deleted.
columnsetxml	ColumnSetXml	Memo	None	True	True	True	False	False	False	True	True	True	False	False	False	False	False	Column Set XML		Definition of the columns included in the view.
componentstate	ComponentState	Picklist	SystemRequired	False	True	False	False	False	False	True	False	True	False	False	False	False	False	Component State		For internal use only.
conditionalformatting	ConditionalFormatting	Memo	None	False	True	True	False	False	False	True	True	True	False	False	False	False	False	Conditional formatting		Conditional formatting of this view
createdby	CreatedBy	Lookup	None	False	True	False	False	False	False	False	False	True	False	False	False	False	True	Created By		Unique identifier of the user who created the view.
createdon	CreatedOn	DateTime	None	False	True	False	False	False	False	False	False	True	False	False	False	False	True	Created On		Date and time when the view was created.
createdonbehalfby	CreatedOnBehalfBy	Lookup	None	False	True	False	False	False	False	True	False	True	False	False	False	False	True	Created By (Delegate)		Unique identifier of the delegate user who created the savedquery.
description	Description	Memo	None	True	True	True	False	False	False	True	True	True	False	False	False	False	True	Description		Description of the view.
fetchxml	FetchXml	Memo	None	True	True	True	False	False	False	True	True	True	False	False	False	False	True	Fetch XML		String specifying the query in Fetch XML language.
iscustomizable	IsCustomizable	ManagedProperty	SystemRequired	True	True	True	False	False	False	False	False	True	False	False	False	False	False	Customizable		Information that specifies whether the view can be customized.
isdefault	IsDefault	Boolean	SystemRequired	True	True	True	False	False	False	True	True	True	False	False	False	False	False	Default		Information that specifies a default view.
ismanaged	IsManaged	Boolean	SystemRequired	False	True	False	False	False	False	True	True	True	False	False	False	False	False	State		Indicates whether the solution component is part of a managed solution.
isprivate	IsPrivate	Boolean	SystemRequired	False	True	False	False	False	False	False	False	True	False	False	False	False	False		5.0.0.0	Indicates whether or not this is viewable by the entire organization.
isquickfindquery	IsQuickFindQuery	Boolean	SystemRequired	True	True	True	False	False	False	True	True	True	False	False	False	False	True	Quick Find Compatible		Information that specifies a quick find view.
isuserdefined	IsUserDefined	Boolean	None	False	True	False	False	False	False	True	True	True	False	False	False	False	False	User Defined		Information that specifies whether the query was created by a user.
layoutxml	LayoutXml	Memo	None	True	True	True	False	False	False	True	False	True	False	False	False	False	False	Layout XML		For internal use only.
modifiedby	ModifiedBy	Lookup	None	False	True	False	False	False	False	False	False	True	False	False	False	False	True	Modified By		Unique identifier of the user who last modified the view.
modifiedon	ModifiedOn	DateTime	None	False	True	False	False	False	False	False	False	True	False	False	False	False	True	Modified On		Date and time when the view was last modified.
modifiedonbehalfby	ModifiedOnBehalfBy	Lookup	None	False	True	False	False	False	False	True	False	True	False	False	False	False	True	Modified By (Delegate)		Unique identifier of the delegate user who last modified the savedquery.
name	Name	String	SystemRequired	True	True	True	False	False	False	True	True	True	False	True	False	False	True	Name		Name of the view.
organizationid	OrganizationId	Lookup	SystemRequired	False	True	False	False	False	False	False	False	True	False	False	False	False	False	Organization		Unique identifier of the organization associated with the view.
organizationtaborder	OrganizationTabOrder	Integer	None	False	True	False	False	False	False	True	True	True	False	False	False	False	False	Default Organization tab order		Default Organization tab order
overwritetime	OverwriteTime	DateTime	SystemRequired	False	True	False	False	False	False	True	False	True	False	False	False	False	False	Record Overwrite Time		For internal use only.
queryapi	QueryAPI	String	None	False	True	False	False	False	False	True	False	True	False	False	False	False	False	Query API		For internal use only.
queryappusage	QueryAppUsage	Integer	None	True	True	True	False	False	False	True	False	True	False	False	False	False	False	Query Application Usage		For internal use only.
querytype	QueryType	Integer	SystemRequired	True	True	True	False	False	False	True	True	True	False	False	False	False	False	Query Type		Type of the view.
returnedtypecode	ReturnedTypeCode	EntityName	SystemRequired	True	True	True	False	False	False	True	True	True	False	False	False	False	False	Returned Type		Type of entity displayed in the view.
savedqueryid	SavedQueryId	Uniqueidentifier	SystemRequired	True	True	False	False	False	False	False	False	True	True	False	False	False	True	View		Unique identifier of the view.
savedqueryidunique	SavedQueryIdUnique	Uniqueidentifier	SystemRequired	False	True	False	False	False	False	False	False	True	False	False	False	False	False			For internal use only.
solutionid	SolutionId	Uniqueidentifier	SystemRequired	False	True	False	False	False	False	False	False	True	False	False	False	False	False	Solution		Unique identifier of the associated solution.
statecode	StateCode	State	SystemRequired	False	True	False	False	False	False	True	True	True	False	False	False	False	True	Status		Status of the view.
statuscode	StatusCode	Status	None	True	True	True	False	False	False	True	True	True	False	False	False	False	True	Status Reason		Reason for the status of the view.
supportingsolutionid	SupportingSolutionId	Uniqueidentifier	None	False	False	False	False	False	False	False	False	True	False	False	False	False	False	Solution		For internal use only.
versionnumber	VersionNumber	BigInt	None	False	True	False	False	False	False	False	False	True	False	False	False	False	False	Version Number		Version number of the view.

One-to-Many Relationships

The following table shows the entities that are the referencing entity in a one-to-many relationship with the saved query (view) entity.

Relationship schema name	Referencing entity
SavedQuery_AsyncOperations	asyncoperation
SavedQuery_BulkDeleteFailures	bulkdeletefailure
userentityinstancedata_savedquery	userentityinstancedata

Many-to-Many Relationships

The following table shows the many-to-many relationships for the saved query (view) entity.

Many-to-One Relationships

The following table shows the entities that are the referenced entity in a many-to-one relationship with the saved query (view) entity.

Relationship schema name	Referenced entity
organization_saved_queries	organization
lk_savedquery_modifiedonbehalfby	systemuser
lk_savedquerybase_createdby	systemuser
lk_savedquerybase_modifiedby	systemuser
lk_savedquery_createdonbehalfby	systemuser

SavedQuery (View) Entity Metadata

In This Topic

Entity Metadata

Privilege Metadata

Attribute Metadata

One-to-Many Relationships

Many-to-Many Relationships

Many-to-One Relationships

See Also

Reference

Concepts

Other Resources

Additional resources