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.
See also
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho