goalrollupquery EntityType
Query that is used to filter the results of the goal rollup.
- Entity set path:
- [organization URI]/api/data/v9.2/goalrollupqueries
- Base type:
- crmbaseentity
- Table type:
- Standard
- Display name:
- Rollup Query
- Primary key:
- goalrollupqueryid
- Primary name column:
- name
- Operations supported:
- POST GET PATCH DELETE
Properties
Properties represent fields of data stored in the entity. Some properties are read-only.
| Name | Type | Details | ||||||
|---|---|---|---|---|---|---|---|---|
| createdon | Edm.DateTimeOffset |
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. Display name: Created On Read only
|
||||||
| fetchxml | Edm.String |
String that specifies the condition criteria in FetchXML. Display name: Condition Criteria |
||||||
| goalrollupqueryid | Edm.Guid |
Unique identifier of the rollup query. Display name: Goal Rollup Query |
||||||
| importsequencenumber | Edm.Int32 |
Sequence number of the import that created this record. Display name: Import Sequence Number |
||||||
| modifiedon | Edm.DateTimeOffset |
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. Display name: Modified On Read only
|
||||||
| name | Edm.String |
Type a descriptive name for the goal rollup query. Display name: Name |
||||||
| overriddencreatedon | Edm.DateTimeOffset |
Date and time that the record was migrated. Display name: Record Created On |
||||||
| queryentitytype | Edm.String |
Enter the record type of the rollup query. Display name: Entity Type |
||||||
| statecode | Edm.Int32 |
Shows whether the goal rollup query is active or inactive. Display name: Status
Default options
|
||||||
| statuscode | Edm.Int32 |
Select the goal rollup query's status. Display name: Status Reason
Default options
|
||||||
| timezoneruleversionnumber | Edm.Int32 |
For internal use only. Display name: Time Zone Rule Version Number |
||||||
| utcconversiontimezonecode | Edm.Int32 |
Time zone code that was in use when the record was created. Display name: UTC Conversion Time Zone Code |
||||||
| versionnumber | Edm.Int64 |
Version number of the goal rollup query. Display name: Version Number Read only
|
Lookup properties
Lookup properties are read-only, computed properties which contain entity primary key Edm.Guid data for one or more corresponding single-valued navigation properties. More information: Lookup properties and Lookup property data.
| Name | Single-valued navigation property | Description |
|---|---|---|
| _createdby_value | createdby |
Shows who created the record. |
| _createdonbehalfby_value | createdonbehalfby |
Shows who created the record on behalf of another user. |
| _modifiedby_value | modifiedby |
Shows who last updated the record. |
| _modifiedonbehalfby_value | modifiedonbehalfby |
Shows who last updated the record on behalf of another user. |
| _ownerid_value | ownerid |
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. |
| _owningbusinessunit_value | owningbusinessunit |
Unique identifier of the business unit that owns the record. |
| _owningteam_value | owningteam |
Unique identifier of the team who owns the record. |
Single-valued navigation properties
Single-valued navigation properties represent lookup fields where a single entity can be referenced. Each single-valued navigation property has a corresponding partner collection-valued navigation property on the related entity.
| Name | Type | Partner |
|---|---|---|
| createdby | systemuser | lk_goalrollupquery_createdby |
| createdonbehalfby | systemuser | lk_goalrollupquery_createdonbehalfby |
| modifiedby | systemuser | lk_goalrollupquery_modifiedby |
| modifiedonbehalfby | systemuser | lk_goalrollupquery_modifiedonbehalfby |
| ownerid | principal | owner_goalrollupquery |
| owningbusinessunit | businessunit | business_unit_goalrollupquery |
| owningteam | team | team_goalrollupquery |
Collection-valued navigation properties
Collection-valued navigation properties represent collections of entities which may represent either a one-to-many (1:N) or many-to-many (N:N) relationship between the entities.
| Name | Type | Partner |
|---|---|---|
| goal_rollupquery_actualdecimal | goal | rollupqueryactualdecimalid |
| goal_rollupquery_actualmoney | goal | rollupqueryactualmoneyid |
| goal_rollupquery_customdecimal | goal | rollupquerycustomdecimalid |
| goal_rollupquery_customint | goal | rollupquerycustomintegerid |
| goal_rollupquery_custommoney | goal | rollupquerycustommoneyid |
| goal_rollupquery_inprogressdecimal | goal | rollupqueryinprogressdecimalid |
| goal_rollupquery_inprogressint | goal | rollupqueryinprogressintegerid |
| goal_rollupquery_inprogressmoney | goal | rollupqueryinprogressmoneyid |
| goalrollupquery_actualint | goal | rollupqueryactualintegerid |
| goalrollupquery_AsyncOperations | asyncoperation | regardingobjectid_goalrollupquery |
| GoalRollupQuery_DuplicateBaseRecord | duplicaterecord | baserecordid_goalrollupquery |
| GoalRollupQuery_DuplicateMatchingRecord | duplicaterecord | duplicaterecordid_goalrollupquery |
| goalrollupquery_ProcessSessions | processsession | regardingobjectid_goalrollupquery |
| GoalRollupQuery_SyncErrors | syncerror | regardingobjectid_goalrollupquery_syncerror |
Operations
The following operations can be used with the goalrollupquery entity type.
| Name | Binding |
|---|---|
| GrantAccess | Not Bound |
| ModifyAccess | Not Bound |
| RetrievePrincipalAccess | Not Bound |
| RetrieveSharedPrincipalsAndAccess | Not Bound |
| RevokeAccess | Not Bound |