View (SavedQuery) table/entity reference (Microsoft Dataverse)

2025-08-28

Saved query against the database.

Messages

The following table lists the messages for the View (SavedQuery) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
`Associate` Event: True	Associate records	Associate records
`Create` Event: False	`POST` /savedqueries See Create	Create records
`Delete` Event: False	`DELETE` /savedqueries(savedqueryid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`ExecuteByIdSavedQuery` Event: True		ExecuteByIdSavedQueryRequest
`ExecuteByIdUserQuery` Event: True		ExecuteByIdUserQueryRequest
`InstantiateFilters` Event: False	InstantiateFilters	InstantiateFiltersRequest
`Retrieve` Event: True	`GET` /savedqueries(savedqueryid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: True	`GET` /savedqueries See Query data	Query data
`RetrieveUnpublished` Event: False	RetrieveUnpublished	RetrieveUnpublishedRequest
`RetrieveUnpublishedMultiple` Event: False	RetrieveUnpublishedMultiple	RetrieveUnpublishedMultipleRequest
`SetState` Event: True	`PATCH` /savedqueries(savedqueryid) Update the `statecode` and `statuscode` properties.	SetStateRequest
`Update` Event: False	`PATCH` /savedqueries(savedqueryid) See Update	Update records
`Upsert` Event: False	`PATCH` /savedqueries(savedqueryid) See Upsert a table row	UpsertRequest
`Validate` Event: False	Validate	ValidateRequest
`ValidateSavedQuery` Event: False	ValidateSavedQuery	ValidateSavedQueryRequest
`ValidateUnpublished` Event: False	ValidateUnpublished	ValidateUnpublishedRequest

Properties

The following table lists selected properties for the View (SavedQuery) table.

Property	Value
DisplayName	View
DisplayCollectionName	Views
SchemaName	`SavedQuery`
CollectionSchemaName	`SavedQueries`
EntitySetName	`savedqueries`
LogicalName	`savedquery`
LogicalCollectionName	`savedqueries`
PrimaryIdAttribute	`savedqueryid`
PrimaryNameAttribute	`name`
TableType	`Standard`
OwnershipType	`OrganizationOwned`

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

AdvancedGroupBy
CanBeDeleted
ColumnSetXml
ConditionalFormatting
Description
EnableCrossPartition
FetchXml
IntroducedVersion
IsCustomizable
IsDefault
IsQuickFindQuery
LayoutJson
LayoutXml
Name
OfflineSqlQuery
QueryAppUsage
QueryType
ReturnedTypeCode
RoleDisplayConditionsXml
SavedQueryId
StateCode
StatusCode

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
IsValidForForm	False
IsValidForRead	True
LogicalName	`advancedgroupby`
RequiredLevel	None
Type	String
Format	TextArea
FormatName	TextArea
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

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
IsValidForForm	False
IsValidForRead	True
LogicalName	`columnsetxml`
RequiredLevel	None
Type	Memo
Format	TextArea
FormatName	TextArea
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

ConditionalFormatting

Property	Value
Description	Type information about how the items in the system view are formatted.
DisplayName	Conditional formatting
IsValidForForm	False
IsValidForRead	True
LogicalName	`conditionalformatting`
RequiredLevel	None
Type	Memo
Format	TextArea
FormatName	TextArea
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

Description

Property	Value
Description	Type additional information to describe the view, such as the filter criteria or intended results set.
DisplayName	Description
IsValidForForm	False
IsValidForRead	True
LogicalName	`description`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	True
MaxLength	2000

EnableCrossPartition

Property	Value
Description	Tells whether the view can retrieve data from all cluster partitions.
DisplayName	Default
IsValidForForm	False
IsValidForRead	True
LogicalName	`enablecrosspartition`
RequiredLevel	SystemRequired
Type	Boolean
GlobalChoiceName	`savedquery_enablecrosspartition`
DefaultValue	False
True Label	Yes
False Label	No

FetchXml

Property	Value
Description	String specifying the query in Fetch XML language.
DisplayName	Fetch XML
IsValidForForm	False
IsValidForRead	True
LogicalName	`fetchxml`
RequiredLevel	None
Type	Memo
Format	TextArea
FormatName	TextArea
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

IntroducedVersion

Property	Value
Description	Version in which the form is introduced.
DisplayName	Introduced Version
IsValidForForm	False
IsValidForRead	True
LogicalName	`introducedversion`
RequiredLevel	None
Type	String
Format	VersionNumber
FormatName	VersionNumber
ImeMode	Auto
IsLocalizable	False
MaxLength	48

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
GlobalChoiceName	`savedquery_isdefault`
DefaultValue	False
True Label	Yes
False Label	No

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
GlobalChoiceName	`savedquery_isquickfindquery`
DefaultValue	False
True Label	Yes
False Label	No

LayoutJson

Property	Value
Description	Layout data in JSON format.
DisplayName	Layout data in JSON format.
IsValidForForm	False
IsValidForRead	True
LogicalName	`layoutjson`
RequiredLevel	None
Type	Memo
Format	TextArea
FormatName	TextArea
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

LayoutXml

Property	Value
Description	For internal use only.
DisplayName	Layout XML
IsValidForForm	False
IsValidForRead	True
LogicalName	`layoutxml`
RequiredLevel	None
Type	Memo
Format	TextArea
FormatName	TextArea
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

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
IsValidForForm	False
IsValidForRead	True
LogicalName	`name`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	True
MaxLength	200

OfflineSqlQuery

Property	Value
Description	String specifying the corresponding sql query for the fetch xml specified for offline use.
DisplayName	Offline SQL Query
IsValidForForm	False
IsValidForRead	True
LogicalName	`offlinesqlquery`
RequiredLevel	None
Type	Memo
Format	TextArea
FormatName	TextArea
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

QueryAppUsage

Property	Value
Description	For internal use only.
DisplayName	Query Application Usage
IsValidForForm	False
IsValidForRead	True
LogicalName	`queryappusage`
RequiredLevel	None
Type	Integer
MaxValue	1000000000
MinValue	0

QueryType

Property	Value
Description	Shows the type of the query.
DisplayName	Query Type
IsValidForForm	False
IsValidForRead	True
LogicalName	`querytype`
RequiredLevel	SystemRequired
Type	Integer
MaxValue	1000000000
MinValue	0

ReturnedTypeCode

Property	Value
Description	Type of entity displayed in the view.
DisplayName	Entity Name
IsValidForForm	False
IsValidForRead	True
LogicalName	`returnedtypecode`
RequiredLevel	SystemRequired
Type	EntityName

RoleDisplayConditionsXml

Property	Value
Description	Contains the role display conditions for the SavedQuery.
DisplayName	Role display conditions for the SavedQuery
IsValidForForm	False
IsValidForRead	True
LogicalName	`roledisplayconditionsxml`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1073741823

SavedQueryId

Property	Value
Description	Unique identifier of the view.
DisplayName	View
IsValidForForm	False
IsValidForRead	True
LogicalName	`savedqueryid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

StateCode

Property	Value
Description	Shows the status of the view.
DisplayName	Status
IsValidForForm	True
IsValidForRead	True
LogicalName	`statecode`
RequiredLevel	SystemRequired
Type	State
DefaultFormValue	0
GlobalChoiceName	`savedquery_statecode`

StateCode Choices/Options

Value	Details
0	Label: Active DefaultStatus: 1 InvariantName: `Active`
1	Label: Inactive DefaultStatus: 2 InvariantName: `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
DefaultFormValue	-1
GlobalChoiceName	`savedquery_statuscode`

StatusCode Choices/Options

Value	Details
1	Label: Active State:0 TransitionData: None
2	Label: Inactive State:1 TransitionData: None

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

ComponentState
CreatedBy
CreatedOn
CreatedOnBehalfBy
IsCustom
IsManaged
IsPrivate
IsUserDefined
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OrganizationId
OrganizationTabOrder
OverwriteTime
QueryAPI
SavedQueryIdUnique
SolutionId
SupportingSolutionId
VersionNumber

ComponentState

Property	Value
Description	For internal use only.
DisplayName	Component State
IsValidForForm	False
IsValidForRead	True
LogicalName	`componentstate`
RequiredLevel	SystemRequired
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`componentstate`

ComponentState Choices/Options

Value	Label
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
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
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
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

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
Type	Lookup
Targets	systemuser

IsCustom

Property	Value
Description	Tells whether a user created the view.
DisplayName	Is Custom
IsValidForForm	False
IsValidForRead	True
LogicalName	`iscustom`
RequiredLevel	SystemRequired
Type	Boolean
GlobalChoiceName	`savedquery_iscustom`
DefaultValue	True
True Label	Yes
False Label	No

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
GlobalChoiceName	`ismanaged`
DefaultValue	False
True Label	Managed
False Label	Unmanaged

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
GlobalChoiceName	`savedquery_isprivate`
DefaultValue	False
True Label	Yes
False Label	No

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
GlobalChoiceName	`savedquery_isuserdefined`
DefaultValue	True
True Label	Yes
False Label	No

ModifiedBy

Property	Value
Description	Shows who last updated the record.
DisplayName	Modified By
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
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
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

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
Type	Lookup
Targets	systemuser

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
Type	Lookup
Targets	organization

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
IsValidForForm	False
IsValidForRead	True
LogicalName	`organizationtaborder`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

OverwriteTime

Property	Value
Description	For internal use only.
DisplayName	Record Overwrite Time
IsValidForForm	False
IsValidForRead	True
LogicalName	`overwritetime`
RequiredLevel	SystemRequired
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

QueryAPI

Property	Value
Description	For internal use only.
DisplayName	Query API
IsValidForForm	False
IsValidForRead	True
LogicalName	`queryapi`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

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`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

lk_savedquery_createdonbehalfby
lk_savedquery_modifiedonbehalfby
lk_savedquerybase_createdby
lk_savedquerybase_modifiedby
organization_saved_queries

lk_savedquery_createdonbehalfby

One-To-Many Relationship: systemuser lk_savedquery_createdonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdonbehalfby`
ReferencingEntityNavigationPropertyName	`createdonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_savedquery_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_savedquery_modifiedonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedonbehalfby`
ReferencingEntityNavigationPropertyName	`modifiedonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_savedquerybase_createdby

One-To-Many Relationship: systemuser lk_savedquerybase_createdby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdby`
ReferencingEntityNavigationPropertyName	`createdby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_savedquerybase_modifiedby

One-To-Many Relationship: systemuser lk_savedquerybase_modifiedby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedby`
ReferencingEntityNavigationPropertyName	`modifiedby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

organization_saved_queries

One-To-Many Relationship: organization organization_saved_queries

Property	Value
ReferencedEntity	`organization`
ReferencedAttribute	`organizationid`
ReferencingAttribute	`organizationid`
ReferencingEntityNavigationPropertyName	`organizationid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

lk_mobileofflineprofileitem_savedquery
SavedQuery_AsyncOperations
SavedQuery_BulkDeleteFailures
SavedQuery_SyncErrors

lk_mobileofflineprofileitem_savedquery

Many-To-One Relationship: mobileofflineprofileitem lk_mobileofflineprofileitem_savedquery

Property	Value
ReferencingEntity	`mobileofflineprofileitem`
ReferencingAttribute	`profileitemrule`
ReferencedEntityNavigationPropertyName	`lk_mobileofflineprofileitem_savedquery`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

SavedQuery_AsyncOperations

Many-To-One Relationship: asyncoperation SavedQuery_AsyncOperations

Property	Value
ReferencingEntity	`asyncoperation`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`SavedQuery_AsyncOperations`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

SavedQuery_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure SavedQuery_BulkDeleteFailures

Property	Value
ReferencingEntity	`bulkdeletefailure`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`SavedQuery_BulkDeleteFailures`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

SavedQuery_SyncErrors

Many-To-One Relationship: syncerror SavedQuery_SyncErrors

Property	Value
ReferencingEntity	`syncerror`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`SavedQuery_SyncErrors`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Feedback

Was this page helpful?