Referenz zur Tabelle/Entität Saved View (UserQuery)
Hinweis
Unsicher bei Tabelle vs. Entität? Siehe Entwickler: Terminologie in Microsoft Dataverse verstehen.
Saved database query that is owned by a user.
Nachrichten
| Nachricht | Web-API-Vorgang | SDK-Klasse oder -Methode |
|---|---|---|
| Assign | PATCH [org URI]/api/data/v9.0/userqueries(userqueryid) Aktualisieren die Eigenschaft ownerid. |
AssignRequest |
| Create | POST [org URI]/api/data/v9.0/userqueries Weitere Informationen finden Sie unter Erstellen |
CreateRequest oder Create |
| Delete | DELETE [org URI]/api/data/v9.0/userqueries(userqueryid) Weitere Informationen finden Sie unter Löschen |
DeleteRequest oder Delete |
| ExecuteByIdUserQuery | Abrufen und Ausführen von vordefinierten Abfragen | ExecuteByIdUserQueryRequest |
| GrantAccess | GrantAccess Action | GrantAccessRequest |
| ModifyAccess | ModifyAccess Action | ModifyAccessRequest |
| Retrieve | GET [org URI]/api/data/v9.0/userqueries(userqueryid) Weitere Informationen finden Sie unter Abrufen |
RetrieveRequest oder Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/userqueries Weitere Informationen finden Sie unter Daten abfragen |
RetrieveMultipleRequest oder RetrieveMultiple |
| RetrievePrincipalAccess | RetrievePrincipalAccess Function | RetrievePrincipalAccessRequest |
| RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess Function | RetrieveSharedPrincipalsAndAccessRequest |
| RevokeAccess | RevokeAccess Action | RevokeAccessRequest |
| SetState | PATCH [org URI]/api/data/v9.0/userqueries(userqueryid) Aktualisieren der Eigenschaften statecode und statuscode. |
SetStateRequest |
| Update | PATCH [org URI]/api/data/v9.0/userqueries(userqueryid) Weitere Informationen finden Sie unter Aktualisieren |
UpdateRequest oder Update |
Eigenschaften
| Eigenschaft | Wert |
|---|---|
| CollectionSchemaName | UserQueries |
| DisplayCollectionName | Saved Views |
| DisplayName | Saved View |
| EntitySetName | userqueries |
| IsBPFEntity | False |
| LogicalCollectionName | userqueries |
| LogicalName | userquery |
| OwnershipType | UserOwned |
| PrimaryIdAttribute | userqueryid |
| PrimaryNameAttribute | name |
| SchemaName | UserQuery |
Schreibbare Spalten/Attribute
Diese Spalten/Attribute geben entweder für IsValidForCreate oder IsValidForUpdate (normalerweise beides) true zurück. Aufgelistet durch SchemaName.
- AdvancedGroupBy
- ColumnSetXml
- ConditionalFormatting
- Description
- FetchXml
- LayoutJson
- LayoutXml
- Name
- OfflineSqlQuery
- OwnerId
- OwnerIdType
- ParentQueryId
- QueryType
- ReturnedTypeCode
- StateCode
- StatusCode
- UserQueryId
AdvancedGroupBy
| Eigenschaft | Wert |
|---|---|
| Description | Type the column name that will be used to group the results from the data collected across multiple records from a user view. |
| DisplayName | Advanced Group By |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | advancedgroupby |
| MaxLength | 20 |
| RequiredLevel | None |
| Type | String |
ColumnSetXml
| Eigenschaft | Wert |
|---|---|
| Description | Shows the columns and sorting criteria for the saved 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
| Eigenschaft | Wert |
|---|---|
| Description | Type information about how the items in the user view are formatted. |
| DisplayName | User Group By |
| Format | TextArea |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | conditionalformatting |
| MaxLength | 1073741823 |
| RequiredLevel | None |
| Type | Memo |
Description
| Eigenschaft | Wert |
|---|---|
| Description | Type additional information to describe the saved view, such as the filter criteria or intended results set. |
| DisplayName | Description |
| Format | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | description |
| MaxLength | 2000 |
| RequiredLevel | None |
| Type | Memo |
FetchXml
| Eigenschaft | Wert |
|---|---|
| Description | Contains the Fetch XML query that defines the entities and attributes included in the saved view. |
| DisplayName | Fetch XML |
| Format | TextArea |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | fetchxml |
| MaxLength | 1073741823 |
| RequiredLevel | SystemRequired |
| Type | Memo |
LayoutJson
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| Description | Type a descriptive name for the saved view. |
| DisplayName | Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | name |
| MaxLength | 200 |
| RequiredLevel | SystemRequired |
| Type | String |
OfflineSqlQuery
| Eigenschaft | Wert |
|---|---|
| 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 |
OwnerId
| Eigenschaft | Wert |
|---|---|
| Description | Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. |
| DisplayName | Owner |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | ownerid |
| RequiredLevel | SystemRequired |
| Targets | systemuser,team |
| Type | Owner |
OwnerIdType
| Eigenschaft | Wert |
|---|---|
| Description | Type of the owner of the saved view, such as user, team, or business unit. |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
ParentQueryId
| Eigenschaft | Wert |
|---|---|
| Description | Choose the ID of the saved query that the record was created from. |
| DisplayName | Parent Query |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | parentqueryid |
| RequiredLevel | None |
| Targets | |
| Type | Lookup |
QueryType
| Eigenschaft | Wert |
|---|---|
| Description | Shows the code for the query type to indicate whether the saved view is an address book filter, advanced search, or other view. |
| DisplayName | Query Type |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | querytype |
| MaxValue | 1000000000 |
| MinValue | 0 |
| RequiredLevel | SystemRequired |
| Type | Integer |
ReturnedTypeCode
| Eigenschaft | Wert |
|---|---|
| Description | Type of entity that the saved view displays. |
| DisplayName | Returned Type |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | returnedtypecode |
| RequiredLevel | SystemRequired |
| Type | EntityName |
StateCode
| Eigenschaft | Wert |
|---|---|
| Description | Shows whether the saved view is active or inactive. |
| DisplayName | Status |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
StateCode Auswahlen/Optionen
| Wert | Etikett | Standardstatuswert | Invariante Name |
|---|---|---|---|
| 0 | Active | 1 | Active |
| 1 | Inactive | 2 | Inactive |
StatusCode
| Eigenschaft | Wert |
|---|---|
| Description | Select the item's status. |
| DisplayName | Status Reason |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
StatusCode Auswahlen/Optionen
| Wert | Etikett | Status |
|---|---|---|
| 1 | Active | 0 |
| 2 | Inactive | 1 |
| 3 | All | 0 |
UserQueryId
| Eigenschaft | Wert |
|---|---|
| Description | Unique identifier of the saved view. |
| DisplayName | User Query |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | userqueryid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
Schreibgeschützt Spalten/Attribute
Diese Spalten/Attribute geben false zurück für sowohl IsValidForCreate als auch IsValidForUpdate. Aufgelistet durch SchemaName.
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- VersionNumber
CreatedBy
| Eigenschaft | Wert |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | SystemRequired |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
| Eigenschaft | Wert |
|---|---|
| Description | Name of the user who created the saved view. |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
| Eigenschaft | Wert |
|---|---|
| Description | YomiName of the user who created the saved view. |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| Eigenschaft | Wert |
|---|---|
| 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 | SystemRequired |
| Type | DateTime |
CreatedOnBehalfBy
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Eigenschaft | Wert |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedBy
| Eigenschaft | Wert |
|---|---|
| Description | Shows who last updated the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | SystemRequired |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
| Eigenschaft | Wert |
|---|---|
| Description | Name of the user who last modified the saved view. |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
| Eigenschaft | Wert |
|---|---|
| Description | YomiName of the user who last modified the saved view. |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| Eigenschaft | Wert |
|---|---|
| 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 | Last Modified |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | SystemRequired |
| Type | DateTime |
ModifiedOnBehalfBy
| Eigenschaft | Wert |
|---|---|
| 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
| Eigenschaft | Wert |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Eigenschaft | Wert |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OwnerIdName
| Eigenschaft | Wert |
|---|---|
| Description | Name of the owner of the saved view. |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwnerIdYomiName
| Eigenschaft | Wert |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwningBusinessUnit
| Eigenschaft | Wert |
|---|---|
| Description | Shows the business unit that the record owner belongs to. |
| DisplayName | Owning Business Unit |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Targets | businessunit |
| Type | Lookup |
OwningBusinessUnitName
| Eigenschaft | Wert |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunitname |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
OwningTeam
| Eigenschaft | Wert |
|---|---|
| Description | Unique identifier of the team who owns this saved view. |
| DisplayName | Owning Team |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningteam |
| RequiredLevel | None |
| Targets | team |
| Type | Lookup |
OwningUser
| Eigenschaft | Wert |
|---|---|
| Description | Unique identifier of the user who owns this saved view. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
VersionNumber
| Eigenschaft | Wert |
|---|---|
| Description | Version number of the saved view. |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
Eins-zu-Viele-Beziehungen
Aufgelistet durch SchemaName.
UserQuery_BulkDeleteFailures
Wie die UserQuery_BulkDeleteFailures-Viele-zu-Eins-Beziehung für die bulkdeletefailure-Tabelle/-Entität.
| Eigenschaft | Wert |
|---|---|
| ReferencingEntity | bulkdeletefailure |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | UserQuery_BulkDeleteFailures |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
UserQuery_SyncErrors
Wie die UserQuery_SyncErrors-Viele-zu-Eins-Beziehung für die syncerror-Tabelle/-Entität.
| Eigenschaft | Wert |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | UserQuery_SyncErrors |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
UserQuery_AsyncOperations
Wie die UserQuery_AsyncOperations-Viele-zu-Eins-Beziehung für die asyncoperation-Tabelle/-Entität.
| Eigenschaft | Wert |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | UserQuery_AsyncOperations |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Viele-zu-Eins-Beziehungen
Jede Viele-zu-Eins-Beziehung wird durch eine entsprechende Viele-zu-Viele-Beziehungen mit der zugehörigen Tabelle definiert. Aufgelistet durch SchemaName.
- lk_userquery_modifiedonbehalfby
- business_unit_userquery
- user_userquery
- team_userquery
- lk_userquery_modifiedby
- lk_userquery_createdby
- lk_userquery_createdonbehalfby
lk_userquery_modifiedonbehalfby
Siehe die lk_userquery_modifiedonbehalfby-Eins-zu-Viele-Beziehung für die systemuser-Tabelle/-Entität.
business_unit_userquery
Siehe die business_unit_userquery-Eins-zu-Viele-Beziehung für die businessunit-Tabelle/-Entität.
user_userquery
Siehe die user_userquery-Eins-zu-Viele-Beziehung für die systemuser-Tabelle/-Entität.
team_userquery
Siehe die team_userquery-Eins-zu-Viele-Beziehung für die team-Tabelle/-Entität.
lk_userquery_modifiedby
Siehe die lk_userquery_modifiedby-Eins-zu-Viele-Beziehung für die systemuser-Tabelle/-Entität.
lk_userquery_createdby
Siehe die lk_userquery_createdby-Eins-zu-Viele-Beziehung für die systemuser-Tabelle/-Entität.
lk_userquery_createdonbehalfby
Siehe die lk_userquery_createdonbehalfby-Eins-zu-Viele-Beziehung für die systemuser-Tabelle/-Entität.
Siehe auch
Dataverse-Tabelle/-Entitätsreferenz Web-API-Referenz userquery EntityType
Feedback
Bald verfügbar: Im Laufe des Jahres 2024 werden wir GitHub-Issues stufenweise als Feedbackmechanismus für Inhalte abbauen und durch ein neues Feedbacksystem ersetzen. Weitere Informationen finden Sie unter https://aka.ms/ContentUserFeedback.
Feedback senden und anzeigen für