Rollup Query (GoalRollupQuery) table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Query that is used to filter the results of the goal rollup.
Messages
Message | Web API Operation | SDK class or method |
---|---|---|
Assign | PATCH /goalrollupqueries(goalrollupqueryid) Update ownerid property. |
AssignRequest |
Create | POST /goalrollupqueries See Create |
CreateRequest or Create |
Delete | DELETE /goalrollupqueries(goalrollupqueryid) See Delete |
DeleteRequest or Delete |
GrantAccess | GrantAccess | GrantAccessRequest |
ModifyAccess | ModifyAccess | ModifyAccessRequest |
Retrieve | GET /goalrollupqueries(goalrollupqueryid) See Retrieve |
RetrieveRequest or Retrieve |
RetrieveMultiple | GET /goalrollupqueries See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
RetrievePrincipalAccess | RetrievePrincipalAccess | RetrievePrincipalAccessRequest |
RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccess | RetrieveSharedPrincipalsAndAccessRequest |
RevokeAccess | RevokeAccess | RevokeAccessRequest |
SetState | PATCH /goalrollupqueries(goalrollupqueryid) Update statecode and statuscode properties. |
SetStateRequest |
Update | PATCH /goalrollupqueries(goalrollupqueryid) See 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 columns/attributes
These columns/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 columns/attributes
These columns/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
- OwningBusinessUnitName
- 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 | True |
IsValidForRead | True |
LogicalName | owningbusinessunit |
RequiredLevel | None |
Targets | businessunit |
Type | Lookup |
OwningBusinessUnitName
Property | Value |
---|---|
Description | |
DisplayName | |
FormatName | Text |
IsLocalizable | False |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunitname |
MaxLength | 160 |
RequiredLevel | None |
Type | String |
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 table/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 table/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 table/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 table/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 table/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 table/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 table/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 table/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 table/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 table/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 table/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 table/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 table/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 table/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 table. 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 table/entity.
lk_goalrollupquery_createdby
See the lk_goalrollupquery_createdby one-to-many relationship for the systemuser table/entity.
lk_goalrollupquery_createdonbehalfby
See the lk_goalrollupquery_createdonbehalfby one-to-many relationship for the systemuser table/entity.
lk_goalrollupquery_modifiedby
See the lk_goalrollupquery_modifiedby one-to-many relationship for the systemuser table/entity.
lk_goalrollupquery_modifiedonbehalfby
See the lk_goalrollupquery_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.
business_unit_goalrollupquery
See the business_unit_goalrollupquery one-to-many relationship for the businessunit table/entity.
See also
Dataverse table/entity reference
Web API Reference
goalrollupquery EntityType
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για