SavedQuery (View) Entity Metadata
[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 |
See Also
Reference
EntityMetadata
AttributeMetadata
OneToManyRelationshipMetadata
ManyToManyRelationshipMetadata
Concepts
Customize Entity Views
SavedQuery (View) Entity Messages and Methods
SavedQuery (View) Entity OptionSet Attribute Metadata
SavedQuery (View) Entity Privileges
Other Resources
Extend Microsoft Dynamics CRM for Outlook
Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.