Événements
31 mars, 23 h - 2 avr., 23 h
L’événement de la communauté Microsoft Fabric, Power BI, SQL et AI ultime. 31 mars au 2 avril 2025.
Inscrivez-vous aujourd’huiCe navigateur n’est plus pris en charge.
Effectuez une mise à niveau vers Microsoft Edge pour tirer parti des dernières fonctionnalités, des mises à jour de sécurité et du support technique.
Notes
Vous n’êtes pas sûr de la table par rapport à l’entité ? Voir Développeurs : Comprendre la terminologie dans Microsoft Dataverse.
Query that is used to filter the results of the goal rollup.
Message | Opération de l'API web | Classe ou méthode SDK |
---|---|---|
Assign | PATCH [org URI]/api/data/v9.0/goalrollupqueries(goalrollupqueryid) Mettre à jour la propriété ownerid . |
AssignRequest |
Create | POST [org URI]/api/data/v9.0/goalrollupqueries Voir Créer |
CreateRequest ou Create |
Delete | DELETE [org URI]/api/data/v9.0/goalrollupqueries(goalrollupqueryid) Voir Supprimer |
DeleteRequest ou Delete |
GrantAccess | GrantAccess Action | GrantAccessRequest |
ModifyAccess | ModifyAccess Action | ModifyAccessRequest |
Retrieve | GET [org URI]/api/data/v9.0/goalrollupqueries(goalrollupqueryid) Voir Récupérer |
RetrieveRequest ou Retrieve |
RetrieveMultiple | GET [org URI]/api/data/v9.0/goalrollupqueries 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/goalrollupqueries(goalrollupqueryid) Mettre à jour les propriétés statecode et statuscode . |
SetStateRequest |
Update | PATCH [org URI]/api/data/v9.0/goalrollupqueries(goalrollupqueryid) Voir Mettre à jour |
UpdateRequest ou Update |
Propriété | Valeur |
---|---|
CollectionSchemaName | goalrollupqueries |
DisplayCollectionName | Rollup Queries |
DisplayName | Rollup Query |
EntitySetName | goalrollupqueries |
IsBPFEntity | False |
LogicalCollectionName | goalrollupqueries |
LogicalName | goalrollupquery |
OwnershipType | UserOwned |
PrimaryIdAttribute | goalrollupqueryid |
PrimaryNameAttribute | name |
SchemaName | GoalRollupQuery |
Ces colonnes/attributs renvoient la valeur true pour IsValidForCreate ou IsValidForUpdate (généralement les deux). Répertorié par SchemaName.
Propriété | Valeur |
---|---|
Description | String that specifies the condition criteria in FetchXML. |
DisplayName | Condition Criteria |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | fetchxml |
MaxLength | 1073741823 |
RequiredLevel | ApplicationRequired |
Type | String |
Propriété | Valeur |
---|---|
Description | Unique identifier of the rollup query. |
DisplayName | Goal Rollup Query |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | goalrollupqueryid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
Propriété | Valeur |
---|---|
Description | Sequence number of the import that created this record. |
DisplayName | Import Sequence Number |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | importsequencenumber |
MaxValue | 2147483647 |
MinValue | -2147483648 |
RequiredLevel | None |
Type | Integer |
Propriété | Valeur |
---|---|
Description | Type a descriptive name for the goal rollup query. |
DisplayName | Name |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | name |
MaxLength | 100 |
RequiredLevel | ApplicationRequired |
Type | String |
Propriété | Valeur |
---|---|
DateTimeBehavior | UserLocal |
Description | Date and time that the record was migrated. |
DisplayName | Record Created On |
Format | DateOnly |
IsValidForForm | False |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | overriddencreatedon |
RequiredLevel | None |
Type | DateTime |
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 |
Propriété | Valeur |
---|---|
Description | Owner Id Type |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
Propriété | Valeur |
---|---|
Description | Enter the record type of the rollup query. |
DisplayName | Entity Type |
IsValidForForm | True |
IsValidForRead | True |
IsValidForUpdate | False |
LogicalName | queryentitytype |
RequiredLevel | ApplicationRequired |
Type | EntityName |
Propriété | Valeur |
---|---|
Description | Shows whether the goal rollup query is active or inactive. |
DisplayName | Status |
IsValidForCreate | False |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statecode |
RequiredLevel | SystemRequired |
Type | State |
Valeur | Étiquette | Statut par défaut | Nom invariant |
---|---|---|---|
0 | Active | 0 | Active |
1 | Inactive | 1 | Inactive |
Propriété | Valeur |
---|---|
Description | Select the goal rollup query's status. |
DisplayName | Status Reason |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | statuscode |
RequiredLevel | None |
Type | Status |
Valeur | Étiquette | État |
---|---|---|
0 | Open | 0 |
1 | Closed | 1 |
Propriété | Valeur |
---|---|
Description | For internal use only. |
DisplayName | Time Zone Rule Version Number |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timezoneruleversionnumber |
MaxValue | 2147483647 |
MinValue | -1 |
RequiredLevel | None |
Type | Integer |
Propriété | Valeur |
---|---|
Description | Time zone code that was in use when the record was created. |
DisplayName | UTC Conversion Time Zone Code |
Format | None |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | utcconversiontimezonecode |
MaxValue | 2147483647 |
MinValue | -1 |
RequiredLevel | None |
Type | Integer |
Ces colonnes/attributs renvoient la valeur false pour IsValidForCreate ou IsValidForUpdate. Répertorié par SchemaName.
Propriété | Valeur |
---|---|
Description | Shows who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Propriété | Valeur |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 | True |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
Propriété | Valeur |
---|---|
Description | Shows who created the record on behalf of another user. |
DisplayName | Created By (Delegate) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Propriété | Valeur |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Propriété | Valeur |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | createdonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Propriété | Valeur |
---|---|
Description | Shows who last updated the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Propriété | Valeur |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
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 | Modified On |
Format | DateAndTime |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
Propriété | Valeur |
---|---|
Description | Shows who last updated the record on behalf of another user. |
DisplayName | Modified By (Delegate) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedonbehalfby |
RequiredLevel | None |
Targets | systemuser |
Type | Lookup |
Propriété | Valeur |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyname |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Propriété | Valeur |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | modifiedonbehalfbyyominame |
MaxLength | 100 |
RequiredLevel | None |
Type | String |
Propriété | Valeur |
---|---|
Description | Name of the owner |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridname |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
Propriété | Valeur |
---|---|
Description | Yomi name of the owner |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridyominame |
MaxLength | 100 |
RequiredLevel | SystemRequired |
Type | String |
Propriété | Valeur |
---|---|
Description | Unique identifier of the business unit that owns the record. |
DisplayName | Owning Business Unit |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | owningbusinessunit |
RequiredLevel | None |
Targets | businessunit |
Type | Lookup |
Propriété | Valeur |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunitname |
MaxLength | 160 |
RequiredLevel | None |
Type | String |
Propriété | Valeur |
---|---|
Description | Unique identifier of the team who owns the record. |
DisplayName | Owning Team |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningteam |
RequiredLevel | None |
Targets | team |
Type | Lookup |
Propriété | Valeur |
---|---|
Description | Unique identifier of the user who owns the record. |
DisplayName | Owning User |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | None |
Targets | |
Type | Lookup |
Propriété | Valeur |
---|---|
Description | Version number of the goal rollup query. |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
RequiredLevel | None |
Type | BigInt |
Répertorié par SchemaName.
Identique à la relation plusieurs à un goalrollupquery_actualint pour la table/entité goal.
Propriété | Valeur |
---|---|
ReferencingEntity | goal |
ReferencingAttribute | rollupqueryactualintegerid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | goalrollupquery_actualint |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Identique à la relation plusieurs à un goal_rollupquery_actualmoney pour la table/entité goal.
Propriété | Valeur |
---|---|
ReferencingEntity | goal |
ReferencingAttribute | rollupqueryactualmoneyid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | goal_rollupquery_actualmoney |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Identique à la relation plusieurs à un goal_rollupquery_actualdecimal pour la table/entité goal.
Propriété | Valeur |
---|---|
ReferencingEntity | goal |
ReferencingAttribute | rollupqueryactualdecimalid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | goal_rollupquery_actualdecimal |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Identique à la relation plusieurs à un goal_rollupquery_customint pour la table/entité goal.
Propriété | Valeur |
---|---|
ReferencingEntity | goal |
ReferencingAttribute | rollupquerycustomintegerid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | goal_rollupquery_customint |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Identique à la relation plusieurs à un goal_rollupquery_custommoney pour la table/entité goal.
Propriété | Valeur |
---|---|
ReferencingEntity | goal |
ReferencingAttribute | rollupquerycustommoneyid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | goal_rollupquery_custommoney |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Identique à la relation plusieurs à un goal_rollupquery_customdecimal pour la table/entité goal.
Propriété | Valeur |
---|---|
ReferencingEntity | goal |
ReferencingAttribute | rollupquerycustomdecimalid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | goal_rollupquery_customdecimal |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Identique à la relation plusieurs à un goal_rollupquery_inprogressint pour la table/entité goal.
Propriété | Valeur |
---|---|
ReferencingEntity | goal |
ReferencingAttribute | rollupqueryinprogressintegerid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | goal_rollupquery_inprogressint |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Identique à la relation plusieurs à un goal_rollupquery_inprogressmoney pour la table/entité goal.
Propriété | Valeur |
---|---|
ReferencingEntity | goal |
ReferencingAttribute | rollupqueryinprogressmoneyid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | goal_rollupquery_inprogressmoney |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Identique à la relation plusieurs à un goal_rollupquery_inprogressdecimal pour la table/entité goal.
Propriété | Valeur |
---|---|
ReferencingEntity | goal |
ReferencingAttribute | rollupqueryinprogressdecimalid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | goal_rollupquery_inprogressdecimal |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Identique à la relation plusieurs à un GoalRollupQuery_SyncErrors pour la table/entité syncerror.
Propriété | Valeur |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | True |
ReferencedEntityNavigationPropertyName | GoalRollupQuery_SyncErrors |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
Identique à la relation plusieurs à un goalrollupquery_AsyncOperations pour la table/entité asyncoperation.
Propriété | Valeur |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | goalrollupquery_AsyncOperations |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Identique à la relation plusieurs à un GoalRollupQuery_DuplicateMatchingRecord pour la table/entité duplicaterecord.
Propriété | Valeur |
---|---|
ReferencingEntity | duplicaterecord |
ReferencingAttribute | duplicaterecordid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | GoalRollupQuery_DuplicateMatchingRecord |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Identique à la relation plusieurs à un GoalRollupQuery_DuplicateBaseRecord pour la table/entité duplicaterecord.
Propriété | Valeur |
---|---|
ReferencingEntity | duplicaterecord |
ReferencingAttribute | baserecordid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | GoalRollupQuery_DuplicateBaseRecord |
AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Identique à la relation plusieurs à un goalrollupquery_ProcessSessions pour la table/entité processsession.
Propriété | Valeur |
---|---|
ReferencingEntity | processsession |
ReferencingAttribute | regardingobjectid |
IsHierarchical | False |
IsCustomizable | False |
ReferencedEntityNavigationPropertyName | goalrollupquery_ProcessSessions |
AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Chaque relation plusieurs-à-un est définie par une relation un-à-plusieurs correspondante avec la table associée. Répertorié par SchemaName.
Voir la relation un à plusieurs team_goalrollupquery pour la table/entité team.
Voir la relation un à plusieurs lk_goalrollupquery_createdby pour la table/entité systemuser.
Voir la relation un à plusieurs lk_goalrollupquery_createdonbehalfby pour la table/entité systemuser.
Voir la relation un à plusieurs lk_goalrollupquery_modifiedby pour la table/entité systemuser.
Voir la relation un à plusieurs lk_goalrollupquery_modifiedonbehalfby pour la table/entité systemuser.
Voir la relation un à plusieurs business_unit_goalrollupquery pour la table/entité businessunit.
Référence d’entité/de table Dataverse Référence d’API web goalrollupquery EntityType
Événements
31 mars, 23 h - 2 avr., 23 h
L’événement de la communauté Microsoft Fabric, Power BI, SQL et AI ultime. 31 mars au 2 avril 2025.
Inscrivez-vous aujourd’hui