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 मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें