# Google Analytics

IQL query types

Types

The following table lists all type prefixes that are available for reporting on specific properties, along with their possible values.

Type PrefixApplies To PropertyPossible Values
ObjectTypetype

All enterprise object types (such as PROCESS, REQUIREMENT, ACTIVITY, etc.). See ObjectType Values for a complete list.

RequirementTyperequirementTypeBUSINESS, FINANCIAL, FUNCTIONAL, GOVERNANCE, NONE, PERFORMANCE, PERSONAL, PRODUCT, RISK, TECHNICAL
CycleStateapprovalState, endorsementState, reviewStateIN_PROCESS, NOT_IN_PROCESS, REJECTED
PIDataSeriesTypepiDataSeriesTypeCATEGORY_BASED, ROLLUP, TIME_BASED, TIME_BASED_TEXT
PIRatingSystempiRatingSystemGAR, GR, NONE, RAG, RAGAR, RG
subtypesubtype

Any enterprise object (e.g. Risk, Risk Instance, Control, Control Instance, Performance Indicator) that has a sub-type. For example, to report all Strategic KPIs, put the subtype value in quotes as shown in this Filter:

type=ObjectType.PERFORMANCE_INDICATOR and subtype.name="Strategic Performance Indicator (S-KPI)"
resourceTyperesourceTypeAny resource or resource sub-type
PIWeightingpiWeightingHIGH, LOW, MEDIUM, NONE, VERY_HIGH, VERY_LOW
TimeUnitresourceAvailabilityTimeAwayUnitDAYS, HOURS, MINUTES, MONTHS, SECONDS, WEEKS, YEARS
Levelrisk.impact, risk.likelihoodHIGH, LOW, MEDIUM, VERY_HIGH, VERY_LOW
RootResourceTyperootResourceTypeEQUIPMENT, INFRASTRUCTURE, ITARCHITECTURE, LABOR, LOCATION, ORGANIZATION
SpecialResourceTypespecialResourceTypeBOARD, GROUP, JOB, LEGAL_ENTITY, NONE, PERSON, ROLE, ROOT, SAP_END_USER_ROLE_JOB, SAP_END_USER_ROLE_ORGANIZATIONAL_UNIT, SAP_END_USER_ROLE_USER, SAP_LOGICAL_COMPONENT, SAP_ORGANIZATIONAL_UNIT
SAPStatussapDocumentStatusCOPY_EDITING, IN_PROCESSING, NONE, RELEASED, REVIEW
WorkProductLayerworkProductLayerBUSINESS, INFORMATION, DATA

ObjectType Values

The list below includes all built-in enumeration values that can follow the Type prefix "ObjectType".

ObjectNote
ACTIVITY
BUSINESS_RULE
CHART
CLASS
CLASS_FOLDER
COMPONENT
CONTROL_FOLDER
DASHBOARD
DASHBOARD_FOLDER
DEPARTMENT
DIAGRAMFor Client-authored diagrams
DOCUMENTFor Client-authored .igx files
EXTERNAL_AGENT
EXTERNAL_AGENT_FOLDER
EXTERNAL_FILEMicrosoft Office documents for example
FOLDER
GOAL
INTERFACE
INTERFACE_FOLDER
OPERATION
PERFORMANCE_INDICATOR
PROCESS
PROCESS_FOLDER
REQUIREMENT
REQUIREMENT_FOLDER
RESOURCE
RESOURCE_FOLDER
RESOURCE_TYPE
RISK_FOLDER
RISK_TEMPLATE
ROOT_CLASS_FOLDER
ROOT_CONTROL_FOLDER
ROOT_DASHBOARD_FOLDER
ROOT_EXTERNAL_AGENT_FOLDER
ROOT_FOLDER
ROOT_INTERFACE_FOLDER
ROOT_PROCESS_FOLDER
ROOT_REQUIREMENT_FOLDER
ROOT_RESOURCE_FOLDER
ROOT_RESOURCE_TYPE_FOLDER
ROOT_STRATEGY_FOLDER
ROOT_WORK_PRODUCT_FOLDER
SAP_INTERFACE
SAP_INTERFACE_FOLDER
SAP_MASTER_DATA
SAP_PROCESS
SAP_PROCESS_STEP
SAP_PROJECT
SAP_RESOURCE_FOLDER
SAP_SCENARIO
SAP_SERVICE
SAP_TRANSACTION
SERVICE
STRATEGY
STRATEGY_FOLDER
TABLE
WEB_ADDRESS
WEB_DIAGRAMFor Web-authored diagrams
WORK_PRODUCT

WORK_PRODUCT_FOLDER


Special System Types

The following table lists special systems types that properties can have. The possible values of properties with these special types are listed below.

TypePossible Values
true/falsetrue or false (These values do not require a type prefix).
usernameUser is mapped to User's display name
date/timeGMT is mapped to profile's timezone