UserQuery (Saved View) Entity Metadata

  • Article

[Applies to: Microsoft Dynamics CRM 2011]

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

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 user query (saved view) entity.

Metadata property Value

OTC

4230

EntityLogicalName

userquery

DisplayName

Saved View

OwnershipType

UserOwned

IsCustomizable

True

Description

Saved database query that is owned by a user.

IsAvailableOffline

True

IsAuditEnabled

False

AutoRouteToOwnerQueue

False

CanBeInManyToMany

False

CanBePrimaryEntityInRelationship

False

CanBeRelatedEntityInRelationship

False

CanCreateAttributes

False

CanCreateCharts

False

CanCreateForms

False

CanCreateViews

False

CanModifyAdditionalSettings

True

CanTriggerWorkflow

False

IsActivity

False

IsActivityParty

False

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

False

IsValidForQueue

False

IsVisibleInMobile

False

PrimaryIdAttribute

userqueryid

PrimaryNameAttribute

name

ReportViewName

FilteredUserQuery

RecurrenceBaseEntityLogicalName

DisplayCollectionName

Saved Views

Privilege Metadata

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

PrivilegeName Id Type CanBeBasic CanBeDeep CanBeGlobal CanBeLocal

prvAssignUserQuery

d2a1330e-6eef-4c7a-8074-11636d728915

Assign

True

False

False

False

prvCreateUserQuery

6ec3c27f-73fd-40a2-8e42-cdd129a59845

Create

True

False

False

False

prvDeleteUserQuery

9f128840-94d4-4b7d-a592-98365e3f4987

Delete

True

False

False

False

prvReadUserQuery

f3b782a2-e6d5-4b86-9b7d-33f627fe5c5d

Read

True

False

False

False

prvShareUserQuery

0437ca80-43df-4fdb-acc5-6b5b24618586

Share

True

False

False

False

prvWriteUserQuery

f4875cdf-c281-484b-bb7d-7e2abffcf3c9

Write

True

False

False

False

Attribute Metadata

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

LogicalName Description Type SchemaName IsCustomAttribute IsCustomizable RequiredLevel IsValidForCreate IsValidForRead IsValidForUpdate CanBeSecuredForCreate CanBeSecuredForRead CanBeSecuredForUpdate IsAuditEnabled IsManaged IsPrimaryId IsPrimaryName IsRenameable IsSecured IsValidForAdvancedFind DisplayName DeprecatedVersion

advancedgroupby

Advanced Group By

String

AdvancedGroupBy

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Advanced Group By

columnsetxml

Collection of attributes displayed in the saved view.

Memo

ColumnSetXml

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Column Set XML

conditionalformatting

User Group By

Memo

ConditionalFormatting

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

User Group By

createdby

Unique Identifier of the user who created the saved view.

Lookup

CreatedBy

False

False

SystemRequired

False

True

False

False

False

False

False

True

False

False

False

False

False

Created By

createdon

Date and time when the saved view was created.

DateTime

CreatedOn

False

False

SystemRequired

False

True

False

False

False

False

False

True

False

False

False

False

False

Created On

createdonbehalfby

Unique identifier of the delegate user who created the userquery.

Lookup

CreatedOnBehalfBy

False

True

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Created By (Delegate)

description

Description of the saved view.

Memo

Description

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

False

Description

fetchxml

String that specifies the query in Fetch XML language.

Memo

FetchXml

False

True

SystemRequired

True

True

True

False

False

False

True

True

False

False

False

False

False

Fetch XML

layoutxml

For internal use only.

Memo

LayoutXml

False

True

None

True

True

True

False

False

False

False

True

False

False

False

False

False

Layout XML

modifiedby

Unique identifier of the user who last modified the saved view.

Lookup

ModifiedBy

False

False

SystemRequired

False

True

False

False

False

False

False

True

False

False

False

False

False

Modified By

modifiedon

Date and time when the saved view was last modified.

DateTime

ModifiedOn

False

False

SystemRequired

False

True

False

False

False

False

False

True

False

False

False

False

False

Last Modified

modifiedonbehalfby

Unique identifier of the delegate user who last modified the userquery.

Lookup

ModifiedOnBehalfBy

False

True

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Modified By (Delegate)

name

Name given to the saved view.

String

Name

False

True

SystemRequired

True

True

True

False

False

False

True

True

False

True

False

False

False

Name

ownerid

Unique identifier of the user or team who owns the saved view.

Owner

OwnerId

False

True

SystemRequired

True

True

False

False

False

False

True

True

False

False

False

False

False

Owner

owningbusinessunit

Unique identifier of the business unit that owns this saved view.

Lookup

OwningBusinessUnit

False

True

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Owning Business Unit

owningteam

Unique identifier of the team who owns this saved view.

Lookup

OwningTeam

False

True

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Owning Team

owninguser

Unique identifier of the user who owns this saved view.

Lookup

OwningUser

False

True

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Owning User

parentqueryid

Unique identifier of the Saved Query this was instantiated from.

Lookup

ParentQueryId

False

True

None

True

True

True

False

False

False

True

True

False

False

False

False

True

Parent Query

querytype

Type of saved view.

Integer

QueryType

False

True

SystemRequired

True

True

False

False

False

False

True

True

False

False

False

False

False

Query Type

returnedtypecode

Type of entity that the saved view displays.

EntityName

ReturnedTypeCode

False

True

SystemRequired

True

True

True

False

False

False

True

True

False

False

False

False

False

Returned Type

statecode

Status of the view.

State

StateCode

False

True

SystemRequired

False

True

False

False

False

False

True

True

False

False

False

False

False

Status

statuscode

Reason for the status of the view.

Status

StatusCode

False

True

None

False

True

False

False

False

False

True

True

False

False

False

False

False

Status Reason

userqueryid

Unique identifier of the saved view.

Uniqueidentifier

UserQueryId

False

False

SystemRequired

True

True

False

False

False

False

False

True

True

False

False

False

False

User Query

versionnumber

Version number of the saved view.

BigInt

VersionNumber

False

False

None

False

True

False

False

False

False

False

True

False

False

False

False

False

Version Number

One-to-Many Relationships

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

Relationship schema name Referencing entity

UserQuery_AsyncOperations

asyncoperation

UserQuery_BulkDeleteFailures

bulkdeletefailure

userentityinstancedata_userquery

userentityinstancedata

Many-to-Many Relationships

There are no many-to-many relationships for the user query (saved 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 user query (saved view) entity.

Relationship schema name Referenced entity

business_unit_userquery

businessunit

owner_userquerys

owner

lk_userquery_modifiedonbehalfby

systemuser

user_userquery

systemuser

lk_userquery_modifiedby

systemuser

lk_userquery_createdby

systemuser

lk_userquery_createdonbehalfby

systemuser

team_userquery

team

See Also

Reference

EntityMetadata
AttributeMetadata
OneToManyRelationshipMetadata
ManyToManyRelationshipMetadata

Concepts

UserQuery (Saved View) Entity Messages and Methods
UserQuery (Saved View) Entity Privileges

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.