Export (0) Print
Expand All

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

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

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft