Référence d’entité/de table Saved View (UserQuery)
Notes
Vous n’êtes pas sûr de la table par rapport à l’entité ? Voir Développeurs : Comprendre la terminologie dans Microsoft Dataverse.
Saved database query that is owned by a user.
Messages
| Message | Opération de l'API web | Classe ou méthode SDK |
|---|---|---|
| Assign | PATCH [org URI]/api/data/v9.0/userqueries(userqueryid) Mettre à jour la propriété ownerid. |
AssignRequest |
| Create | POST [org URI]/api/data/v9.0/userqueries Voir Créer |
CreateRequest ou Create |
| Delete | DELETE [org URI]/api/data/v9.0/userqueries(userqueryid) Voir Supprimer |
DeleteRequest ou Delete |
| ExecuteByIdUserQuery | Extraire et exécuter des requêtes prédéfinies | ExecuteByIdUserQueryRequest |
| GrantAccess | GrantAccess Action | GrantAccessRequest |
| ModifyAccess | ModifyAccess Action | ModifyAccessRequest |
| Retrieve | GET [org URI]/api/data/v9.0/userqueries(userqueryid) Voir Récupérer |
RetrieveRequest ou Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/userqueries Voir Rechercher des données |
RetrieveMultipleRequest ou RetrieveMultiple |
| RetrievePrincipalAccess | RetrievePrincipalAccess Function | RetrievePrincipalAccessRequest |
| RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess Function | RetrieveSharedPrincipalsAndAccessRequest |
| RevokeAccess | RevokeAccess Action | RevokeAccessRequest |
| SetState | PATCH [org URI]/api/data/v9.0/userqueries(userqueryid) Mettre à jour les propriétés statecode et statuscode. |
SetStateRequest |
| Update | PATCH [org URI]/api/data/v9.0/userqueries(userqueryid) Voir Mettre à jour |
UpdateRequest ou Update |
Propriétés
| Propriété | Valeur |
|---|---|
| CollectionSchemaName | UserQueries |
| DisplayCollectionName | Saved Views |
| DisplayName | Saved View |
| EntitySetName | userqueries |
| IsBPFEntity | False |
| LogicalCollectionName | userqueries |
| LogicalName | userquery |
| OwnershipType | UserOwned |
| PrimaryIdAttribute | userqueryid |
| PrimaryNameAttribute | name |
| SchemaName | UserQuery |
Colonnes/Attributs inscriptibles
Ces colonnes/attributs renvoient la valeur true pour IsValidForCreate ou IsValidForUpdate (généralement les deux). Répertorié par SchemaName.
- AdvancedGroupBy
- ColumnSetXml
- ConditionalFormatting
- Description
- FetchXml
- LayoutJson
- LayoutXml
- Name
- OfflineSqlQuery
- OwnerId
- OwnerIdType
- ParentQueryId
- QueryType
- ReturnedTypeCode
- StateCode
- StatusCode
- UserQueryId
AdvancedGroupBy
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| Description | Type of entity that the saved view displays. |
| DisplayName | Returned Type |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | returnedtypecode |
| RequiredLevel | SystemRequired |
| Type | EntityName |
StateCode
| Propriété | Valeur |
|---|---|
| Description | Shows whether the saved view is active or inactive. |
| DisplayName | Status |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statecode |
| RequiredLevel | SystemRequired |
| Type | State |
Choix/Options StateCode
| Valeur | Étiquette | Statut par défaut | Nom invariant |
|---|---|---|---|
| 0 | Active | 1 | Active |
| 1 | Inactive | 2 | Inactive |
StatusCode
| Propriété | Valeur |
|---|---|
| Description | Select the item's status. |
| DisplayName | Status Reason |
| IsValidForCreate | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
Choix/Options StatusCode
| Valeur | Étiquette | État |
|---|---|---|
| 1 | Active | 0 |
| 2 | Inactive | 1 |
| 3 | All | 0 |
UserQueryId
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the saved view. |
| DisplayName | User Query |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | userqueryid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
Colonnes/Attributs en lecture seule
Ces colonnes/attributs renvoient la valeur false pour IsValidForCreate ou IsValidForUpdate. Répertorié par SchemaName.
- CreatedBy
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ModifiedBy
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningBusinessUnitName
- OwningTeam
- OwningUser
- VersionNumber
CreatedBy
| Propriété | Valeur |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | SystemRequired |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedBy
| Propriété | Valeur |
|---|---|
| Description | Shows who last updated the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | SystemRequired |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OwnerIdName
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwningBusinessUnit
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunitname |
| MaxLength | 160 |
| RequiredLevel | None |
| Type | String |
OwningTeam
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| 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
| Propriété | Valeur |
|---|---|
| Description | Version number of the saved view. |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
Relations un-à-plusieurs
Répertorié par SchemaName.
UserQuery_BulkDeleteFailures
Identique à la relation plusieurs à un UserQuery_BulkDeleteFailures pour la table/entité bulkdeletefailure.
| Propriété | Valeur |
|---|---|
| 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
Identique à la relation plusieurs à un UserQuery_SyncErrors pour la table/entité syncerror.
| Propriété | Valeur |
|---|---|
| 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
Identique à la relation plusieurs à un UserQuery_AsyncOperations pour la table/entité asyncoperation.
| Propriété | Valeur |
|---|---|
| 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 |
Relations plusieurs-à-un
Chaque relation plusieurs-à-un est définie par une relation un-à-plusieurs correspondante avec la table associée. Répertorié par SchemaName.
- lk_userquery_modifiedonbehalfby
- business_unit_userquery
- user_userquery
- team_userquery
- lk_userquery_modifiedby
- lk_userquery_createdby
- lk_userquery_createdonbehalfby
lk_userquery_modifiedonbehalfby
Voir la relation un à plusieurs lk_userquery_modifiedonbehalfby pour la table/entité systemuser.
business_unit_userquery
Voir la relation un à plusieurs business_unit_userquery pour la table/entité businessunit.
user_userquery
Voir la relation un à plusieurs user_userquery pour la table/entité systemuser.
team_userquery
Voir la relation un à plusieurs team_userquery pour la table/entité team.
lk_userquery_modifiedby
Voir la relation un à plusieurs lk_userquery_modifiedby pour la table/entité systemuser.
lk_userquery_createdby
Voir la relation un à plusieurs lk_userquery_createdby pour la table/entité systemuser.
lk_userquery_createdonbehalfby
Voir la relation un à plusieurs lk_userquery_createdonbehalfby pour la table/entité systemuser.
Voir aussi
Référence d’entité/de table Dataverse Référence d’API web userquery EntityType
Commentaires
Bientôt disponible : Tout au long de 2024, nous allons supprimer progressivement GitHub Issues comme mécanisme de commentaires pour le contenu et le remplacer par un nouveau système de commentaires. Pour plus d’informations, consultez https://aka.ms/ContentUserFeedback.
Envoyer et afficher des commentaires pour