View (SavedQuery) table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Saved query against the database.
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
Create | POST /savedqueries See Create |
CreateRequest or Create |
Delete | DELETE /savedqueries(savedqueryid) See Delete |
DeleteRequest or Delete |
ExecuteByIdSavedQuery | Retrieve and execute predefined queries | ExecuteByIdSavedQueryRequest |
InstantiateFilters | InstantiateFilters | InstantiateFiltersRequest |
Retrieve | GET /savedqueries(savedqueryid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /savedqueries See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
RetrieveUnpublished | RetrieveUnpublished | RetrieveUnpublishedRequest |
RetrieveUnpublishedMultiple | RetrieveUnpublishedMultiple | RetrieveUnpublishedMultipleRequest |
SetState | PATCH /savedqueries(savedqueryid) Update statecode and statuscode properties. |
SetStateRequest |
Update | PATCH /savedqueries(savedqueryid) See Update |
UpdateRequest or Update |
Validate | Validate | ValidateRequest |
ValidateSavedQuery | ValidateSavedQuery | ValidateSavedQueryRequest |
ValidateUnpublished | ValidateUnpublished | ValidateUnpublishedRequest |
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 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 |
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 |
ConditionalFormatting
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 |
RoleDisplayConditionsXml
Added by: RoleBasedAccessControl Solution
Property | Value |
---|---|
Description | Contains the role display conditions for the SavedQuery. |
DisplayName | Role display conditions for the SavedQuery |
Format | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | roledisplayconditionsxml |
MaxLength | 1073741823 |
RequiredLevel | None |
Type | Memo |
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 columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- ComponentState
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- IsCustom
- IsManaged
- IsPrivate
- IsUserDefined
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OrganizationId
- OrganizationIdName
- 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 |
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
- lk_mobileofflineprofileitem_savedquery
- SavedQuery_BulkDeleteFailures
- SavedQuery_AsyncOperations
SavedQuery_SyncErrors
Same as the SavedQuery_SyncErrors many-to-one relationship for the syncerror table/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 table/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 table/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 table/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 table. Listed by SchemaName.
- lk_savedquery_modifiedonbehalfby
- lk_savedquerybase_createdby
- lk_savedquerybase_modifiedby
- organization_saved_queries
- lk_savedquery_createdonbehalfby
lk_savedquery_modifiedonbehalfby
See the lk_savedquery_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
lk_savedquerybase_createdby
See the lk_savedquerybase_createdby one-to-many relationship for the systemuser table/entity.
lk_savedquerybase_modifiedby
See the lk_savedquerybase_modifiedby one-to-many relationship for the systemuser table/entity.
organization_saved_queries
See the organization_saved_queries one-to-many relationship for the organization table/entity.
lk_savedquery_createdonbehalfby
See the lk_savedquery_createdonbehalfby one-to-many relationship for the systemuser table/entity.
See also
Dataverse table/entity reference
Web API Reference
savedquery EntityType
คำติชม
https://aka.ms/ContentUserFeedback
เร็วๆ นี้: ตลอดปี 2024 เราจะขจัดปัญหา GitHub เพื่อเป็นกลไกคำติชมสำหรับเนื้อหา และแทนที่ด้วยระบบคำติชมใหม่ สำหรับข้อมูลเพิ่มเติม ให้ดู:ส่งและดูข้อคิดเห็นสำหรับ