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
Display Name
Rollup Query
Primary Key
Primary Key Attribute
Operations Supported


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
Values Label
0 Active
1 Inactive
statuscode Edm.Int32

Select the goal rollup query's status.

Display Name: Status Reason

Default Options
Values Label
0 Open
1 Closed
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


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

See also