Référence d’entité/de table RollupField
Notes
Vous n’êtes pas sûr de la table par rapport à l’entité ? Voir Développeurs : Comprendre la terminologie dans Microsoft Dataverse.
Field to be rolled up to calculate the actual and in-progress values against the goal.
Messages
| Message | Opération de l'API web | Classe ou méthode SDK |
|---|---|---|
| Create | POST [org URI]/api/data/v9.0/rollupfields Voir Créer |
CreateRequest ou Create |
| Delete | DELETE [org URI]/api/data/v9.0/rollupfields(rollupfieldid) Voir Supprimer |
DeleteRequest ou Delete |
| Retrieve | GET [org URI]/api/data/v9.0/rollupfields(rollupfieldid) Voir Récupérer |
RetrieveRequest ou Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/rollupfields Voir Rechercher des données |
RetrieveMultipleRequest ou RetrieveMultiple |
| Update | PATCH [org URI]/api/data/v9.0/rollupfields(rollupfieldid) Voir Mettre à jour |
UpdateRequest ou Update |
Propriétés
| Propriété | Valeur |
|---|---|
| CollectionSchemaName | RollupFields |
| DisplayCollectionName | Rollup Fields |
| DisplayName | Rollup Field |
| EntitySetName | rollupfields |
| IsBPFEntity | False |
| LogicalCollectionName | rollupfields |
| LogicalName | rollupfield |
| OwnershipType | None |
| PrimaryIdAttribute | rollupfieldid |
| PrimaryNameAttribute | |
| SchemaName | RollupField |
Colonnes/Attributs inscriptibles
Ces colonnes/attributs renvoient la valeur true pour IsValidForCreate ou IsValidForUpdate (généralement les deux). Répertorié par SchemaName.
- DateAttribute
- EntityForDateAttribute
- GoalAttribute
- ImportSequenceNumber
- IsStateParentEntityAttribute
- MetricId
- RollupFieldId
- SourceAttribute
- SourceEntity
- SourceState
- SourceStatus
- TimeZoneRuleVersionNumber
- UTCConversionTimeZoneCode
DateAttribute
| Propriété | Valeur |
|---|---|
| Description | Select a date field for the selected record type, such as Actual Closed Date for the Opportunity record type. A record participates in the goal rollup, if the selected date falls between the start date and the end date for the goal. |
| DisplayName | Date Field |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | dateattribute |
| MaxLength | 100 |
| RequiredLevel | ApplicationRequired |
| Type | String |
EntityForDateAttribute
| Propriété | Valeur |
|---|---|
| Description | Select the record type that contains the date field that will be considered while rolling up data to the goal. |
| DisplayName | Record Type |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | entityfordateattribute |
| RequiredLevel | ApplicationRequired |
| Type | EntityName |
GoalAttribute
| Propriété | Valeur |
|---|---|
| Description | Select a rollup field where the metric rollup data will be displayed in the goal. The options are an integer or money, depending on the Metric Type you chose for the goal metric. |
| DisplayName | Rollup Field |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | goalattribute |
| MaxLength | 100 |
| RequiredLevel | ApplicationRequired |
| Type | String |
ImportSequenceNumber
| 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 |
IsStateParentEntityAttribute
| Propriété | Valeur |
|---|---|
| Description | Tells whether the state or status belongs to the parent entity. |
| DisplayName | Is State/Status From Parent Entity |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | isstateparententityattribute |
| RequiredLevel | None |
| Type | Boolean |
Choix/Options IsStateParentEntityAttribute
| Valeur | Étiquette | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
Valeur par défaut : 0
MetricId
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the goal metric associated with the rollup field. |
| DisplayName | Goal Metric |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | metricid |
| RequiredLevel | ApplicationRequired |
| Targets | metric |
| Type | Lookup |
RollupFieldId
| Propriété | Valeur |
|---|---|
| Description | Unique identifier of the rollup field. |
| DisplayName | Rollup Field |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | rollupfieldid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
SourceAttribute
| Propriété | Valeur |
|---|---|
| Description | Type the name of the field that the data for the goal rolls up from. |
| DisplayName | Source Field |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | sourceattribute |
| MaxLength | 100 |
| RequiredLevel | ApplicationRequired |
| Type | String |
SourceEntity
| Propriété | Valeur |
|---|---|
| Description | Type the name of the record type (entity) that the data for the goal must roll up from. |
| DisplayName | Source Record Type |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | sourceentity |
| RequiredLevel | ApplicationRequired |
| Type | EntityName |
SourceState
| Propriété | Valeur |
|---|---|
| Description | Select the state of the records you want to use as the source of the rollup data for the metric. |
| DisplayName | Source Record Type State |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | sourcestate |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
SourceStatus
| Propriété | Valeur |
|---|---|
| Description | Select the status of the records you want to use as the source of the rollup data for the metric. |
| DisplayName | Source Record Type Status |
| Format | None |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | sourcestatus |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
TimeZoneRuleVersionNumber
| 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 |
UTCConversionTimeZoneCode
| 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 |
Colonnes/Attributs en lecture seule
Ces colonnes/attributs renvoient la valeur false pour IsValidForCreate ou IsValidForUpdate. Répertorié par SchemaName.
- CreatedBy
- CreatedByName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- MetricIdName
- ModifiedBy
- ModifiedByName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OrganizationId
- VersionNumber
CreatedBy
| Propriété | Valeur |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| 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 | True |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
CreatedOnBehalfBy
| 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 |
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 |
MetricIdName
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | metricidname |
| 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 | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
| Propriété | Valeur |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| 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 | Modified On |
| Format | DateAndTime |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
ModifiedOnBehalfBy
| 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 |
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 |
OrganizationId
| Propriété | Valeur |
|---|---|
| Description | Choose the ID of the organization that the record is associated with. |
| DisplayName | Organization Id |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationid |
| RequiredLevel | None |
| Targets | |
| Type | Lookup |
VersionNumber
| Propriété | Valeur |
|---|---|
| Description | Version number of the rollup field. |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
Relations un-à-plusieurs
Répertorié par SchemaName.
rollupfield_ProcessSessions
Identique à la relation plusieurs à un rollupfield_ProcessSessions pour la table/entité processsession.
| Propriété | Valeur |
|---|---|
| ReferencingEntity | processsession |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | rollupfield_ProcessSessions |
| AssociatedMenuConfiguration | Behavior: UseCollectionName Group: Details Label: Order: 110 |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
RollupField_SyncErrors
Identique à la relation plusieurs à un RollupField_SyncErrors pour la table/entité syncerror.
| Propriété | Valeur |
|---|---|
| ReferencingEntity | syncerror |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | True |
| ReferencedEntityNavigationPropertyName | RollupField_SyncErrors |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: Cascade Delete: Cascade Merge: Cascade Reparent: Cascade Share: Cascade Unshare: Cascade |
rollupfield_AsyncOperations
Identique à la relation plusieurs à un rollupfield_AsyncOperations pour la table/entité asyncoperation.
| Propriété | Valeur |
|---|---|
| ReferencingEntity | asyncoperation |
| ReferencingAttribute | regardingobjectid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | rollupfield_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_rollupfield_createdby
- lk_rollupfield_createdonbehalfby
- lk_rollupfield_modifiedby
- lk_rollupfield_modifiedonbehalfby
- metric_rollupfield
lk_rollupfield_createdby
Voir la relation un à plusieurs lk_rollupfield_createdby pour la table/entité systemuser.
lk_rollupfield_createdonbehalfby
Voir la relation un à plusieurs lk_rollupfield_createdonbehalfby pour la table/entité systemuser.
lk_rollupfield_modifiedby
Voir la relation un à plusieurs lk_rollupfield_modifiedby pour la table/entité systemuser.
lk_rollupfield_modifiedonbehalfby
Voir la relation un à plusieurs lk_rollupfield_modifiedonbehalfby pour la table/entité systemuser.
metric_rollupfield
Voir la relation un à plusieurs metric_rollupfield pour la table/entité metric.
Voir aussi
Référence d’entité/de table Dataverse Référence d’API web rollupfield 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