Referencia de tabla o entidad RollupField
Nota
¿No está seguro de tabla frente a entidad? Vea Desarrolladores: comprender la terminología en Microsoft Dataverse.
Field to be rolled up to calculate the actual and in-progress values against the goal.
Mensajes
| Mensaje | Operación de API web | Método o clase de SDK |
|---|---|---|
| Create | POST [org URI]/api/data/v9.0/rollupfields Vea Crear |
CreateRequest o Create |
| Delete | DELETE [org URI]/api/data/v9.0/rollupfields(rollupfieldid) Vea Eliminar |
DeleteRequest o Delete |
| Retrieve | GET [org URI]/api/data/v9.0/rollupfields(rollupfieldid) Vea Recuperar |
RetrieveRequest o Retrieve |
| RetrieveMultiple | GET [org URI]/api/data/v9.0/rollupfields Vea Consultar datos |
RetrieveMultipleRequest o RetrieveMultiple |
| Update | PATCH [org URI]/api/data/v9.0/rollupfields(rollupfieldid) Vea Actualizar |
UpdateRequest o Update |
Propiedades
| Propiedad | Valor |
|---|---|
| CollectionSchemaName | RollupFields |
| DisplayCollectionName | Rollup Fields |
| DisplayName | Rollup Field |
| EntitySetName | rollupfields |
| IsBPFEntity | False |
| LogicalCollectionName | rollupfields |
| LogicalName | rollupfield |
| OwnershipType | None |
| PrimaryIdAttribute | rollupfieldid |
| PrimaryNameAttribute | |
| SchemaName | RollupField |
Columnas/atributos que se pueden escribir
Estas columnas o atributos devuelven true para IsValidForCreate o IsValidForUpdate (generalmente ambos). Listado por SchemaName.
- DateAttribute
- EntityForDateAttribute
- GoalAttribute
- ImportSequenceNumber
- IsStateParentEntityAttribute
- MetricId
- RollupFieldId
- SourceAttribute
- SourceEntity
- SourceState
- SourceStatus
- TimeZoneRuleVersionNumber
- UTCConversionTimeZoneCode
DateAttribute
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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 |
Elecciones/opciones de IsStateParentEntityAttribute
| Valor | Etiqueta | Descripción |
|---|---|---|
| 1 | Yes | |
| 0 | No |
Valor predeterminado: 0
MetricId
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| Description | Unique identifier of the rollup field. |
| DisplayName | Rollup Field |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | rollupfieldid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
SourceAttribute
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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 |
Columnas/atributos de sólo lectura
Estas columnas o atributos devuelven false tanto para IsValidForCreate como para IsValidForUpdate. Listado por SchemaName.
- CreatedBy
- CreatedByName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- MetricIdName
- ModifiedBy
- ModifiedByName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OrganizationId
- VersionNumber
CreatedBy
| Propiedad | Valor |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
MetricIdName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | metricidname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedBy
| Propiedad | Valor |
|---|---|
| Description | Shows who last updated the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Propiedad | Valor |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OrganizationId
| Propiedad | Valor |
|---|---|
| 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
| Propiedad | Valor |
|---|---|
| Description | Version number of the rollup field. |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
Relaciones de uno a varios
Listado por SchemaName.
rollupfield_ProcessSessions
Igual que la relación de varios a uno rollupfield_ProcessSessions de la tabla processsession.
| Propiedad | Valor |
|---|---|
| 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
Igual que la relación de varios a uno RollupField_SyncErrors de la tabla syncerror.
| Propiedad | Valor |
|---|---|
| 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
Igual que la relación de varios a uno rollupfield_AsyncOperations de la tabla asyncoperation.
| Propiedad | Valor |
|---|---|
| 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 |
Relaciones de varios a uno
Cada relación de varios a uno se define mediante una relación de uno a varios correspondiente con la tabla relacionada. Listado por SchemaName.
- lk_rollupfield_createdby
- lk_rollupfield_createdonbehalfby
- lk_rollupfield_modifiedby
- lk_rollupfield_modifiedonbehalfby
- metric_rollupfield
lk_rollupfield_createdby
Consulte la relación de uno a varios lk_rollupfield_createdby de la tabla systemuser.
lk_rollupfield_createdonbehalfby
Consulte la relación de uno a varios lk_rollupfield_createdonbehalfby de la tabla systemuser.
lk_rollupfield_modifiedby
Consulte la relación de uno a varios lk_rollupfield_modifiedby de la tabla systemuser.
lk_rollupfield_modifiedonbehalfby
Consulte la relación de uno a varios lk_rollupfield_modifiedonbehalfby de la tabla systemuser.
metric_rollupfield
Consulte la relación de uno a varios metric_rollupfield de la tabla metric.
Consultar también
Referencia de tabla o entidad de Dataverse Referencia de la API web rollupfield EntityType
Comentarios
Próximamente: A lo largo de 2024 iremos eliminando gradualmente GitHub Issues como mecanismo de comentarios sobre el contenido y lo sustituiremos por un nuevo sistema de comentarios. Para más información, vea: https://aka.ms/ContentUserFeedback.
Enviar y ver comentarios de