View (SavedQuery) entity reference
Artikkel 08/31/2022
4 kaasautorit
Tagasiside
Selles artiklis
Saved query against the database.
Messages
Properties
Property
Value
CollectionSchemaName
SavedQueries
DisplayCollectionName
Views
DisplayName
View
EntitySetName
savedqueries
IsBPFEntity
False
LogicalCollectionName
savedqueries
LogicalName
savedquery
OwnershipType
OrganizationOwned
PrimaryIdAttribute
savedqueryid
PrimaryNameAttribute
name
SchemaName
SavedQuery
Writable attributes
These attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName .
AdvancedGroupBy
Property
Value
Description
Type the column name that will be used to group the results from the data collected across multiple records from a system view.
DisplayName
Advanced Group By
FormatName
TextArea
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
advancedgroupby
MaxLength
2000
RequiredLevel
None
Type
String
CanBeDeleted
Property
Value
Description
Tells whether the view can be deleted.
DisplayName
Can Be Deleted
IsValidForForm
False
IsValidForRead
True
LogicalName
canbedeleted
RequiredLevel
SystemRequired
Type
ManagedProperty
ColumnSetXml
Property
Value
Description
Contains the columns and sorting criteria for the view, stored in XML format.
DisplayName
Column Set XML
Format
TextArea
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
columnsetxml
MaxLength
1073741823
RequiredLevel
None
Type
Memo
Property
Value
Description
Type information about how the items in the system view are formatted.
DisplayName
Conditional formatting
Format
TextArea
IsLocalizable
False
IsValidForCreate
False
IsValidForForm
False
IsValidForRead
True
LogicalName
conditionalformatting
MaxLength
1073741823
RequiredLevel
None
Type
Memo
Description
Property
Value
Description
Type additional information to describe the view, such as the filter criteria or intended results set.
DisplayName
Description
Format
Text
IsLocalizable
True
IsValidForForm
False
IsValidForRead
True
LogicalName
description
MaxLength
2000
RequiredLevel
None
Type
Memo
FetchXml
Property
Value
Description
String specifying the query in Fetch XML language.
DisplayName
Fetch XML
Format
TextArea
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
fetchxml
MaxLength
1073741823
RequiredLevel
None
Type
Memo
IntroducedVersion
Property
Value
Description
Version in which the form is introduced.
DisplayName
Introduced Version
FormatName
VersionNumber
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
IsValidForUpdate
False
LogicalName
introducedversion
MaxLength
48
RequiredLevel
None
Type
String
IsCustomizable
Property
Value
Description
Tells whether the component can be customized.
DisplayName
Customizable
IsValidForForm
False
IsValidForRead
True
LogicalName
iscustomizable
RequiredLevel
SystemRequired
Type
ManagedProperty
IsDefault
Property
Value
Description
Tells whether the view is the default view for the specified record type (entity).
DisplayName
Default
IsValidForForm
False
IsValidForRead
True
LogicalName
isdefault
RequiredLevel
SystemRequired
Type
Boolean
IsDefault Choices/Options
Value
Label
Description
1
Yes
0
No
DefaultValue : 0
IsQuickFindQuery
Property
Value
Description
Choose whether the view is compatible with Quick Find. When users search for specific items, you define the fields that are searched in.
DisplayName
Quick Find Compatible
IsValidForForm
False
IsValidForRead
True
LogicalName
isquickfindquery
RequiredLevel
SystemRequired
Type
Boolean
IsQuickFindQuery Choices/Options
Value
Label
Description
1
Yes
0
No
DefaultValue : 0
LayoutJson
Property
Value
Description
Layout data in JSON format.
DisplayName
Layout data in JSON format.
Format
TextArea
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
layoutjson
MaxLength
1073741823
RequiredLevel
None
Type
Memo
LayoutXml
Property
Value
Description
For internal use only.
DisplayName
Layout XML
Format
TextArea
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
layoutxml
MaxLength
1073741823
RequiredLevel
None
Type
Memo
Name
Property
Value
Description
Type a name for the view to describe what results the view will contain. This name is visible to users in the View list.
DisplayName
Name
FormatName
Text
IsLocalizable
True
IsValidForForm
False
IsValidForRead
True
LogicalName
name
MaxLength
200
RequiredLevel
SystemRequired
Type
String
OfflineSqlQuery
Property
Value
Description
String specifying the corresponding sql query for the fetch xml specified for offline use.
DisplayName
Offline SQL Query
Format
TextArea
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
offlinesqlquery
MaxLength
1073741823
RequiredLevel
None
Type
Memo
QueryAppUsage
Property
Value
Description
For internal use only.
DisplayName
Query Application Usage
Format
None
IsValidForForm
False
IsValidForRead
True
LogicalName
queryappusage
MaxValue
1000000000
MinValue
0
RequiredLevel
None
Type
Integer
QueryType
Property
Value
Description
Shows the type of the query.
DisplayName
Query Type
Format
None
IsValidForForm
False
IsValidForRead
True
LogicalName
querytype
MaxValue
1000000000
MinValue
0
RequiredLevel
SystemRequired
Type
Integer
ReturnedTypeCode
Property
Value
Description
Type of entity displayed in the view.
DisplayName
Entity Name
IsValidForForm
False
IsValidForRead
True
LogicalName
returnedtypecode
RequiredLevel
SystemRequired
Type
EntityName
SavedQueryId
Property
Value
Description
Unique identifier of the view.
DisplayName
View
IsValidForForm
False
IsValidForRead
True
IsValidForUpdate
False
LogicalName
savedqueryid
RequiredLevel
SystemRequired
Type
Uniqueidentifier
StateCode
Property
Value
Description
Shows the status of the view.
DisplayName
Status
IsValidForCreate
False
IsValidForForm
True
IsValidForRead
True
LogicalName
statecode
RequiredLevel
SystemRequired
Type
State
StateCode Choices/Options
Value
Label
DefaultStatus
InvariantName
0
Active
1
Active
1
Inactive
2
Inactive
StatusCode
Property
Value
Description
Shows the reason code that explains the status of the record.
DisplayName
Status Reason
IsValidForForm
True
IsValidForRead
True
LogicalName
statuscode
RequiredLevel
None
Type
Status
StatusCode Choices/Options
Value
Label
State
1
Active
0
2
Inactive
1
Read-only attributes
These attributes return false for both IsValidForCreate or IsValidForUpdate . Listed by SchemaName .
ComponentState
Property
Value
Description
For internal use only.
DisplayName
Component State
IsValidForForm
False
IsValidForRead
True
LogicalName
componentstate
RequiredLevel
SystemRequired
Type
Picklist
ComponentState Choices/Options
Value
Label
Description
0
Published
1
Unpublished
2
Deleted
3
Deleted Unpublished
CreatedBy
Property
Value
Description
Shows who created the record.
DisplayName
Created By
IsValidForForm
False
IsValidForRead
True
LogicalName
createdby
RequiredLevel
None
Targets
systemuser
Type
Lookup
CreatedByName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
createdbyname
MaxLength
100
RequiredLevel
None
Type
String
CreatedByYomiName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
createdbyyominame
MaxLength
100
RequiredLevel
None
Type
String
CreatedOn
Property
Value
DateTimeBehavior
UserLocal
Description
Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName
Created On
Format
DateAndTime
IsValidForForm
False
IsValidForRead
True
LogicalName
createdon
RequiredLevel
None
Type
DateTime
CreatedOnBehalfBy
Property
Value
Description
Shows who created the record on behalf of another user.
DisplayName
Created By (Delegate)
IsValidForForm
False
IsValidForRead
True
LogicalName
createdonbehalfby
RequiredLevel
None
Targets
systemuser
Type
Lookup
CreatedOnBehalfByName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
createdonbehalfbyname
MaxLength
100
RequiredLevel
None
Type
String
CreatedOnBehalfByYomiName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
createdonbehalfbyyominame
MaxLength
100
RequiredLevel
None
Type
String
IsCustom
Property
Value
Description
Tells whether a user created the view.
DisplayName
Is Custom
IsValidForForm
False
IsValidForRead
True
LogicalName
iscustom
RequiredLevel
SystemRequired
Type
Boolean
IsCustom Choices/Options
Value
Label
Description
1
Yes
0
No
DefaultValue : 1
IsManaged
Property
Value
Description
Tells whether the record is part of a managed solution.
DisplayName
State
IsValidForForm
False
IsValidForRead
True
LogicalName
ismanaged
RequiredLevel
SystemRequired
Type
Boolean
IsManaged Choices/Options
Value
Label
Description
1
Managed
0
Unmanaged
DefaultValue : 0
IsPrivate
Property
Value
Description
Indicates whether or not this is viewable by the entire organization.
DisplayName
Is Private
IsValidForForm
False
IsValidForRead
True
LogicalName
isprivate
RequiredLevel
SystemRequired
Type
Boolean
IsPrivate Choices/Options
Value
Label
Description
1
Yes
0
No
DefaultValue : 0
IsUserDefined
Property
Value
Description
Tells whether the view was created by a user.
DisplayName
User Defined
IsValidForForm
False
IsValidForRead
True
LogicalName
isuserdefined
RequiredLevel
None
Type
Boolean
IsUserDefined Choices/Options
Value
Label
Description
1
Yes
0
No
DefaultValue : 1
ModifiedBy
Property
Value
Description
Shows who last updated the record.
DisplayName
Modified By
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedby
RequiredLevel
None
Targets
systemuser
Type
Lookup
ModifiedByName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedbyname
MaxLength
100
RequiredLevel
None
Type
String
ModifiedByYomiName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedbyyominame
MaxLength
100
RequiredLevel
None
Type
String
ModifiedOn
Property
Value
DateTimeBehavior
UserLocal
Description
Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.
DisplayName
Modified On
Format
DateAndTime
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedon
RequiredLevel
None
Type
DateTime
ModifiedOnBehalfBy
Property
Value
Description
Shows who last updated the record on behalf of another user.
DisplayName
Modified By (Delegate)
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedonbehalfby
RequiredLevel
None
Targets
systemuser
Type
Lookup
ModifiedOnBehalfByName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedonbehalfbyname
MaxLength
100
RequiredLevel
None
Type
String
ModifiedOnBehalfByYomiName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
modifiedonbehalfbyyominame
MaxLength
100
RequiredLevel
None
Type
String
OrganizationId
Property
Value
Description
Choose the ID of the organization that the record is associated with.
DisplayName
Organization
IsValidForForm
False
IsValidForRead
True
LogicalName
organizationid
RequiredLevel
SystemRequired
Targets
organization
Type
Lookup
OrganizationIdName
Property
Value
Description
DisplayName
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
organizationidname
MaxLength
100
RequiredLevel
SystemRequired
Type
String
OrganizationTabOrder
Property
Value
Description
For the organization, type the tab order to determine how users navigate through the screen using only the Tab key.
DisplayName
Default Organization tab order
Format
None
IsValidForForm
False
IsValidForRead
True
LogicalName
organizationtaborder
MaxValue
2147483647
MinValue
0
RequiredLevel
None
Type
Integer
OverwriteTime
Property
Value
DateTimeBehavior
UserLocal
Description
For internal use only.
DisplayName
Record Overwrite Time
Format
DateOnly
IsValidForForm
False
IsValidForRead
True
LogicalName
overwritetime
RequiredLevel
SystemRequired
Type
DateTime
QueryAPI
Property
Value
Description
For internal use only.
DisplayName
Query API
FormatName
Text
IsLocalizable
False
IsValidForForm
False
IsValidForRead
True
LogicalName
queryapi
MaxLength
100
RequiredLevel
None
Type
String
SavedQueryIdUnique
Property
Value
Description
For internal use only.
DisplayName
IsValidForForm
False
IsValidForRead
True
LogicalName
savedqueryidunique
RequiredLevel
SystemRequired
Type
Uniqueidentifier
SolutionId
Property
Value
Description
Unique identifier of the associated solution.
DisplayName
Solution
IsValidForForm
False
IsValidForRead
True
LogicalName
solutionid
RequiredLevel
SystemRequired
Type
Uniqueidentifier
SupportingSolutionId
Property
Value
Description
For internal use only.
DisplayName
Solution
IsValidForForm
False
IsValidForRead
False
LogicalName
supportingsolutionid
RequiredLevel
None
Type
Uniqueidentifier
VersionNumber
Property
Value
Description
Version number of the view.
DisplayName
Version Number
IsValidForForm
False
IsValidForRead
True
LogicalName
versionnumber
MaxValue
9223372036854775807
MinValue
-9223372036854775808
RequiredLevel
None
Type
BigInt
One-To-Many Relationships
Listed by SchemaName .
SavedQuery_SyncErrors
Same as the SavedQuery_SyncErrors many-to-one relationship for the syncerror entity.
Property
Value
ReferencingEntity
syncerror
ReferencingAttribute
regardingobjectid
IsHierarchical
False
IsCustomizable
True
ReferencedEntityNavigationPropertyName
SavedQuery_SyncErrors
AssociatedMenuConfiguration
Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration
Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade
lk_mobileofflineprofileitem_savedquery
Same as the lk_mobileofflineprofileitem_savedquery many-to-one relationship for the mobileofflineprofileitem entity.
Property
Value
ReferencingEntity
mobileofflineprofileitem
ReferencingAttribute
profileitemrule
IsHierarchical
False
IsCustomizable
False
ReferencedEntityNavigationPropertyName
lk_mobileofflineprofileitem_savedquery
AssociatedMenuConfiguration
Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration
Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade
SavedQuery_BulkDeleteFailures
Same as the SavedQuery_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure entity.
Property
Value
ReferencingEntity
bulkdeletefailure
ReferencingAttribute
regardingobjectid
IsHierarchical
False
IsCustomizable
False
ReferencedEntityNavigationPropertyName
SavedQuery_BulkDeleteFailures
AssociatedMenuConfiguration
Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration
Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade
SavedQuery_AsyncOperations
Same as the SavedQuery_AsyncOperations many-to-one relationship for the asyncoperation entity.
Property
Value
ReferencingEntity
asyncoperation
ReferencingAttribute
regardingobjectid
IsHierarchical
False
IsCustomizable
False
ReferencedEntityNavigationPropertyName
SavedQuery_AsyncOperations
AssociatedMenuConfiguration
Behavior: DoNotDisplay Group: Details Label: Order:
CascadeConfiguration
Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related entity. Listed by SchemaName .
lk_savedquery_modifiedonbehalfby
See the lk_savedquery_modifiedonbehalfby one-to-many relationship for the systemuser entity.
lk_savedquerybase_createdby
See the lk_savedquerybase_createdby one-to-many relationship for the systemuser entity.
lk_savedquerybase_modifiedby
See the lk_savedquerybase_modifiedby one-to-many relationship for the systemuser entity.
organization_saved_queries
See the organization_saved_queries one-to-many relationship for the organization entity.
lk_savedquery_createdonbehalfby
See the lk_savedquery_createdonbehalfby one-to-many relationship for the systemuser entity.
See also
About the Entity Reference
Web API EntityType Reference