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

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
• 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

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

See also

Dataverse table/entity reference
Dataverse Web API Reference
savedquery