Rollup Query (GoalRollupQuery) entity reference
Query that is used to filter the results of the goal rollup.
Messages
| Message | SDK class or method |
|---|---|
| Assign | AssignRequest |
| Create | CreateRequest or Create |
| Delete | DeleteRequest or Delete |
| GrantAccess | GrantAccessRequest |
| ModifyAccess | ModifyAccessRequest |
| Retrieve | RetrieveRequest or Retrieve |
| RetrieveMultiple | RetrieveMultipleRequest or RetrieveMultiple |
| RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
| RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
| RevokeAccess | RevokeAccessRequest |
| SetState | SetStateRequest |
| Update | UpdateRequest or Update |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | goalrollupqueries |
| DisplayCollectionName | Rollup Queries |
| DisplayName | Rollup Query |
| EntitySetName | goalrollupqueries |
| IsBPFEntity | False |
| LogicalCollectionName | goalrollupqueries |
| LogicalName | goalrollupquery |
| OwnershipType | UserOwned |
| PrimaryIdAttribute | goalrollupqueryid |
| PrimaryNameAttribute | name |
| SchemaName | GoalRollupQuery |
Writable attributes
These attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- FetchXml
- GoalRollupQueryId
- ImportSequenceNumber
- Name
- OverriddenCreatedOn
- OwnerId
- OwnerIdType
- QueryEntityType
- StateCode
- StatusCode
- TimeZoneRuleVersionNumber
- UTCConversionTimeZoneCode
FetchXml
| Property | Value |
|---|---|
| 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 |
GoalRollupQueryId
| Property | Value |
|---|---|
| Description | Unique identifier of the rollup query. |
| DisplayName | Goal Rollup Query |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | goalrollupqueryid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
ImportSequenceNumber
| Property | Value |
|---|---|
| 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 |
Name
| Property | Value |
|---|---|
| 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 |
OverriddenCreatedOn
| Property | Value |
|---|---|
| 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 |
OwnerId
| Property | Value |
|---|---|
| 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
| Property | Value |
|---|---|
| Description | Owner Id Type |
| DisplayName | |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridtype |
| RequiredLevel | SystemRequired |
| Type | EntityName |
QueryEntityType
| Property | Value |
|---|---|
| Description | Enter the record type of the rollup query. |
| DisplayName | Entity Type |
| IsValidForForm | True |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | queryentitytype |
| RequiredLevel | ApplicationRequired |
| Type | EntityName |
StateCode
| Property | Value |
|---|---|
| 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 |
StateCode Choices/Options
| Value | Label | DefaultStatus | InvariantName |
|---|---|---|---|
| 0 | Active | 0 | Active |
| 1 | Inactive | 1 | Inactive |
StatusCode
| Property | Value |
|---|---|
| Description | Select the goal rollup query's status. |
| DisplayName | Status Reason |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | statuscode |
| RequiredLevel | None |
| Type | Status |
StatusCode Choices/Options
| Value | Label | State |
|---|---|---|
| 0 | Open | 0 |
| 1 | Closed | 1 |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| 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
| Property | Value |
|---|---|
| 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 |
Read-only attributes
These attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- CreatedBy
- CreatedByName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- ModifiedBy
- ModifiedByName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OwnerIdName
- OwnerIdYomiName
- OwningBusinessUnit
- OwningTeam
- OwningUser
- VersionNumber
CreatedBy
| Property | Value |
|---|---|
| Description | Shows who created the record. |
| DisplayName | Created By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| Property | Value |
|---|---|
| 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
| Property | Value |
|---|---|
| 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
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedBy
| Property | Value |
|---|---|
| Description | Shows who last updated the record. |
| DisplayName | Modified By |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| Property | Value |
|---|---|
| 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
| Property | Value |
|---|---|
| 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
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OwnerIdName
| Property | Value |
|---|---|
| Description | Name of the owner |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwnerIdYomiName
| Property | Value |
|---|---|
| Description | Yomi name of the owner |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owneridyominame |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OwningBusinessUnit
| Property | Value |
|---|---|
| Description | Unique identifier of the business unit that owns the record. |
| DisplayName | Owning Business Unit |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owningbusinessunit |
| RequiredLevel | None |
| Targets | businessunit |
| Type | Lookup |
OwningTeam
| Property | Value |
|---|---|
| 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 |
OwningUser
| Property | Value |
|---|---|
| Description | Unique identifier of the user who owns the record. |
| DisplayName | Owning User |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | owninguser |
| RequiredLevel | None |
| Targets | |
| Type | Lookup |
VersionNumber
| Property | Value |
|---|---|
| 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 |
One-To-Many Relationships
Listed by SchemaName.
- goalrollupquery_actualint
- goal_rollupquery_actualmoney
- goal_rollupquery_actualdecimal
- goal_rollupquery_customint
- goal_rollupquery_custommoney
- goal_rollupquery_customdecimal
- goal_rollupquery_inprogressint
- goal_rollupquery_inprogressmoney
- goal_rollupquery_inprogressdecimal
- GoalRollupQuery_SyncErrors
- goalrollupquery_AsyncOperations
- GoalRollupQuery_DuplicateMatchingRecord
- GoalRollupQuery_DuplicateBaseRecord
- goalrollupquery_ProcessSessions
goalrollupquery_actualint
Same as the goalrollupquery_actualint many-to-one relationship for the goal entity.
| Property | Value |
|---|---|
| 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 |
goal_rollupquery_actualmoney
Same as the goal_rollupquery_actualmoney many-to-one relationship for the goal entity.
| Property | Value |
|---|---|
| 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 |
goal_rollupquery_actualdecimal
Same as the goal_rollupquery_actualdecimal many-to-one relationship for the goal entity.
| Property | Value |
|---|---|
| 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 |
goal_rollupquery_customint
Same as the goal_rollupquery_customint many-to-one relationship for the goal entity.
| Property | Value |
|---|---|
| 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 |
goal_rollupquery_custommoney
Same as the goal_rollupquery_custommoney many-to-one relationship for the goal entity.
| Property | Value |
|---|---|
| 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 |
goal_rollupquery_customdecimal
Same as the goal_rollupquery_customdecimal many-to-one relationship for the goal entity.
| Property | Value |
|---|---|
| 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 |
goal_rollupquery_inprogressint
Same as the goal_rollupquery_inprogressint many-to-one relationship for the goal entity.
| Property | Value |
|---|---|
| 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 |
goal_rollupquery_inprogressmoney
Same as the goal_rollupquery_inprogressmoney many-to-one relationship for the goal entity.
| Property | Value |
|---|---|
| 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 |
goal_rollupquery_inprogressdecimal
Same as the goal_rollupquery_inprogressdecimal many-to-one relationship for the goal entity.
| Property | Value |
|---|---|
| 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 |
GoalRollupQuery_SyncErrors
Same as the GoalRollupQuery_SyncErrors many-to-one relationship for the syncerror entity.
| Property | Value |
|---|---|
| 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 |
goalrollupquery_AsyncOperations
Same as the goalrollupquery_AsyncOperations many-to-one relationship for the asyncoperation entity.
| Property | Value |
|---|---|
| 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 |
GoalRollupQuery_DuplicateMatchingRecord
Same as the GoalRollupQuery_DuplicateMatchingRecord many-to-one relationship for the duplicaterecord entity.
| Property | Value |
|---|---|
| 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 |
GoalRollupQuery_DuplicateBaseRecord
Same as the GoalRollupQuery_DuplicateBaseRecord many-to-one relationship for the duplicaterecord entity.
| Property | Value |
|---|---|
| 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 |
goalrollupquery_ProcessSessions
Same as the goalrollupquery_ProcessSessions many-to-one relationship for the processsession entity.
| Property | Value |
|---|---|
| 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 |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related entity. Listed by SchemaName.
- team_goalrollupquery
- lk_goalrollupquery_createdby
- lk_goalrollupquery_createdonbehalfby
- lk_goalrollupquery_modifiedby
- lk_goalrollupquery_modifiedonbehalfby
- business_unit_goalrollupquery
team_goalrollupquery
See the team_goalrollupquery one-to-many relationship for the team entity.
lk_goalrollupquery_createdby
See the lk_goalrollupquery_createdby one-to-many relationship for the systemuser entity.
lk_goalrollupquery_createdonbehalfby
See the lk_goalrollupquery_createdonbehalfby one-to-many relationship for the systemuser entity.
lk_goalrollupquery_modifiedby
See the lk_goalrollupquery_modifiedby one-to-many relationship for the systemuser entity.
lk_goalrollupquery_modifiedonbehalfby
See the lk_goalrollupquery_modifiedonbehalfby one-to-many relationship for the systemuser entity.
business_unit_goalrollupquery
See the business_unit_goalrollupquery one-to-many relationship for the businessunit entity.