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 Prefix | Applies To Property | Possible Values |
|---|---|---|
| ObjectType | type | All enterprise object types (such as PROCESS, REQUIREMENT, ACTIVITY, etc.). See ObjectType Values for a complete list. |
| RequirementType | requirementType | BUSINESS, FINANCIAL, FUNCTIONAL, GOVERNANCE, NONE, PERFORMANCE, PERSONAL, PRODUCT, RISK, TECHNICAL |
| CycleState | approvalState, endorsementState, reviewState | IN_PROCESS, NOT_IN_PROCESS, REJECTED |
| PIDataSeriesType | piDataSeriesType | CATEGORY_BASED, ROLLUP, TIME_BASED, TIME_BASED_TEXT |
| PIRatingSystem | piRatingSystem | GAR, GR, NONE, RAG, RAGAR, RG |
| subtype | subtype | 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)" |
| resourceType | resourceType | Any resource or resource sub-type |
| PIWeighting | piWeighting | HIGH, LOW, MEDIUM, NONE, VERY_HIGH, VERY_LOW |
| TimeUnit | resourceAvailabilityTimeAwayUnit | DAYS, HOURS, MINUTES, MONTHS, SECONDS, WEEKS, YEARS |
| Level | risk.impact, risk.likelihood | HIGH, LOW, MEDIUM, VERY_HIGH, VERY_LOW |
| RootResourceType | rootResourceType | EQUIPMENT, INFRASTRUCTURE, ITARCHITECTURE, LABOR, LOCATION, ORGANIZATION |
| SpecialResourceType | specialResourceType | BOARD, 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 |
| SAPStatus | sapDocumentStatus | COPY_EDITING, IN_PROCESSING, NONE, RELEASED, REVIEW |
| WorkProductLayer | workProductLayer | BUSINESS, INFORMATION, DATA |
ObjectType Values
The list below includes all built-in enumeration values that can follow the Type prefix "ObjectType".
| Object | Note |
|---|---|
| ACTIVITY | |
| BUSINESS_RULE | |
| CHART | |
| CLASS | |
| CLASS_FOLDER | |
| COMPONENT | |
| CONTROL_FOLDER | |
| DASHBOARD | |
| DASHBOARD_FOLDER | |
| DEPARTMENT | |
| DIAGRAM | For Client-authored diagrams |
| DOCUMENT | For Client-authored .igx files |
| EXTERNAL_AGENT | |
| EXTERNAL_AGENT_FOLDER | |
| EXTERNAL_FILE | Microsoft 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_DIAGRAM | For 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.
| Type | Possible Values |
|---|---|
| true/false | true or false (These values do not require a type prefix). |
| username | User is mapped to User's display name |
| date/time | GMT is mapped to profile's timezone |