# Google Analytics

IQL query properties

Properties

Property elements specify properties an object may have, and appear in the report as columns in a list. Furthermore, most can be used to filter report results. The following table lists all the available property elements (including those that represent relationships). See Enterprise Object Relationships for more detailed information on relationships.


PropertyApplies ToPossible Values
accountable (.resource, .role)All
acknowledgementApplicantDocuments, WebDiagrams, ExternalFiles, Reportsusername

acknowledgementGroupActionCompleted

Documents, WebDiagrams, ExternalFiles, ReportsUsers who have acknowledged in the cycle
acknowledgementGroupActionPendingDocuments, WebDiagrams, ExternalFiles, ReportsUsers the acknowledgement cycle is waiting on
acknowledgementGroupUsersDocuments, WebDiagrams, ExternalFiles, ReportsAll users in the acknowledgement cycle
acknowledgementStartDateDocuments, WebDiagrams, ExternalFiles, ReportsDate when the active, in-progress acknowledgement cycle started
acknowledgementStateDocuments, WebDiagrams, ExternalFiles, ReportsCycleState
allocationResources
ancestorAllAccess objects that have this common ancestor
approvalApplicantDocuments, WebDiagrams, ExternalFiles, Reportsusername
approvalDateDocuments, WebDiagrams, ExternalFiles, ReportsDate when approved
approvalGroupActionCompletedDocuments, WebDiagrams, ExternalFiles, ReportsUsers who have voted in the cycle
approvalGroupActionPendingDocuments, WebDiagrams, ExternalFiles, ReportsUsers the approval cycle is waiting on
approvalGroupUsersDocuments, WebDiagrams, ExternalFiles, ReportsAll users in the approval cycle
approvalNextStartDateDocuments, WebDiagrams, ExternalFiles, ReportsDate when next scheduled approval cycle will start
approvalStartDateDocuments, WebDiagrams, ExternalFiles, ReportsDate when the active, in-progress approval cycle started
approvalStateDocuments, WebDiagrams, ExternalFiles, ReportsCycleState
approvedDocuments, WebDiagrams, ExternalFiles, Reportstrue/false
approversDocuments, WebDiagrams, ExternalFiles, Reports
auditsBusiness Rules
benefitProvidedByAll Enterprise Objects(Web-authored) Diagram, (Client-authored) IGX Document, IGX Diagram, IGX Sheet, External File, Web Address
checkedOutDateDocuments, WebDiagrams, ExternalFiles, ReportsDate/time
checkedOutToDocuments, WebDiagrams, ExternalFiles, Reportsusername
childAll
commentDocuments, WebDiagrams, ExternalFiles, Reports
consulted (.resource, .role)All
controlsBusiness Rules
createDateAllDate/time
creatorAllusername
currentRiskData.factDateRisks, Risk InstancesDate/time
currentRiskData.factFinancialImpactRisks, Risk Instances
currentRiskData.factValueRisks, Risk Instances
currentRiskData.inherentRiskRisks, Risk Instances
currentRiskData.initialRiskRisks, Risk Instances
currentRiskData.reasonRisks, Risk Instances
currentRiskData.residualRiskRisks, Risk Instances
currentRiskData.risk:appetiteRisks, Risk InstancesLevel
currentRiskData.risk:impactRisks, Risk InstancesLevel
currentRiskData.risk:likelihoodRisks, Risk InstancesLevel
currentRiskData.savedByRisks, Risk InstancesUsername
custom:xxxxAnyCustom Properties and their custom types are user defined for specific object types
deliveredByProduct, Business Service
deliversCapability
depthAllDepth in the repository tree hierarchy (0=Root, 1 = within a top level folder, etc.)
describesDiagram and WebDiagramCan also access this relationship for diagram elements on the diagram as

diagramElement.describes

diagramElement (.ID, .name, .shapeNumber)Diagram and WebDiagramSpecial relationship to access Custom Properties on objects inside a diagram (via .custom:property)
documentsDocuments, WebDiagrams, WebAddresses, ExternalFiles
enabledByProcess/Activity, Journey/Moment/Touch
enablesCapability
endorsedDocuments, WebDiagrams, ExternalFiles, Reportstrue/false
endorsementApplicantDocuments, WebDiagrams, ExternalFiles, Reportsusername
endorsementDateDocuments, WebDiagrams, ExternalFiles, ReportsDate when endorsed
endorsementGroupActionCompletedDocuments, WebDiagrams, ExternalFiles, ReportsUsers who have endorsed the cycle
endorsementGroupActionPendingDocuments, WebDiagrams, ExternalFiles, ReportsUsers the endorsement cycle is waiting on
endorsementGroupUsersDocuments, WebDiagrams, ExternalFiles, ReportsAll users in the endorsement cycle
endorsementNextStartDateDocuments, WebDiagrams, ExternalFiles, ReportsDate when next scheduled endorsement cycle will start
endorsementStartDateDocuments, WebDiagrams, ExternalFiles, ReportsDate when the active, in-progress endorsement cycle started
endorsementStateDocuments, WebDiagrams, ExternalFiles, ReportsCycleState
endorsersDocuments, WebDiagrams, ExternalFiles, Reports
flows (.from, .to)Work Product
folderNameAll
hasCapabilityResource, External Agent
hasControlInstanceControl
hasGoalEnterprise Objects
hasLocationResources
hasOpportunityAll Enterprise Objects(Web-authored) Diagram, (Client-authored) IGX Document, IGX Diagram, IGX Sheet, External File, Web Address
hasOpportunityInstanceOpportunity
hasRequirementEnterprise Objects
hasRiskAll Enterprise Objects(Web-authored) Diagram, (Client-authored) IGX Document, IGX Diagram, IGX Sheet, External File, Web AddressAssociated risk objects of an Enterprise Object through the Has Risk relationship
hasRiskInstanceEnterprise ObjectsAssociated risk instance objects of an Enterprise Object through the Has Risk Instance relationship
hasSAPLogicalComponentSAPProcessSteps, SAPMasterData, SAPInterfaces
hasStrategyEnterprise Objects
IDAllRepository ID or Diagram Element ID
implementsProcess/Activity, Journey/Moment/Touch, Capability, Product, Business Service, Work Products
informed (.resource, .role)All
isAccountableFor (.object, .role)Resources
isAllocatedToResources
isAuditedByEnterprise Objects
isCapabityForCapability
isCheckedOutDocuments, WebDiagrams, ExternalFiles, Reportstrue/false
isConsultedAbout (.object, .role)Resources
isControlInstanceForControl Instance
isControlledByEnterprise Objects
isDescribedByEnterprise Objects
isDescribedByDiagramElementEnterprise Objects
isDocumentedByEnterprise Objects
isDocumentedByUrlEnterprise Objects
isGoalOfGoals
isImplementedByControl, Control Instance, Class
isInformedAbout (.object, .role)Resources
isKeyControlControl, Control Instance
isLocationOfResources
isMeasuredByEnterprise Objects
isOpportunityForRisk, Risk Instance,Opportunity, Opportunity Instance
isOpportunityInstanceForRisk Instance, Opportunity Instance
isRequirementOfRequirement
isResponsibleFor (.object, .role)Resources
isRiskForRisk, Risk Instance, Opportunity, Opportunity Instance
isRiskInstanceForRisk Instance
isRolledUpInPerformance Indicator
isSAPLogicalComponentForSAP Logical Component
isStrategyOfStrategy
isSupportedBy (.object, .sapInScope)Enterprise Objects (most)
linkedUrl1Web Diagrams, IGX Diagrams
linksObjectWeb Diagrams, IGX Diagrams and Terms
MEUser mapped to ResourceReturns the Resource Object associated with the logged-in user. Only available as filter property.
measuresPerformance Indicator
modifierAllusername
modifyDateAlldate/time
nameAll
objectLinkedByAllTargeted by linksObject
ownerAllusername
parentAll
piDataSeriesTypePerformance IndicatorsPIDataSeriesType
piFactIdentiferPerformance Indicators
piPreemptPerformance Indicatorstrue/false
piRatingSystemPerformance IndicatorsPIRatingSystem
piTypePerformance IndicatorsPIType
piUnitPerformance Indicators
piWeightingPerformance IndicatorsPIWeighting
posesThreatToAll Enterprise Objects(Web-authored) Diagram, (Client-authored) IGX Document, IGX Diagram, IGX Sheet, External File, Web Address
projectEndDateDocuments, WebDiagrams, ExternalFiles, Reportsdate/time
projectNameDocuments, WebDiagrams, ExternalFiles, Reports
projectPercentCompleteDocuments, WebDiagrams, ExternalFiles, Reports
projectStartDateDocuments, WebDiagrams, ExternalFiles, Reportsdate/time
providesBenefitToAll Enterprise Objects(Web-authored) Diagram, (Client-authored) IGX Document, IGX Diagram, IGX Sheet, External File, Web Address
purposeAll
ratingControls, Control InstancesControl Rating
receives (.from, .workProduct)Process, Activity, External Agent
requiredForCapability
requirementTypeRequirementsRequirementType
requiresMoment, Touch, Product, Business Service
resourceAttendedResourcesOnly applies to Resources of type Bot
resourceAvailabilityPercentageResources
resourceAvailabilityTimeAwayExpressionResources
resourceAvailabilityTimeAwayUnitResourcesTimeUnit
resourceCountResources
resourceCountUnlimitedResourcestrue/false
resourceHourlyRateResources
resourceLatitudeResources
resourceLongitudeResources
resourceMaximumHourlyOvertimePerDayResources
resourceOvertimeHourlyRateResources
resourcePerUseCostResources
resourceInstanceResourceTypeAccess RESOURCE objects from RESOURCE_TYPE object
resourceTypeResourcesAccess RESOURCE_TYPE object from RESOURCE object
responsible (.resource, .role)All
reviewApplicantDocuments, WebDiagrams, ExternalFiles, Reportsusername
reviewDateDocuments, WebDiagrams, ExternalFiles, ReportsDate when reviewed
reviewedDocuments, WebDiagrams, ExternalFiles, Reportstrue/false
reviewersDocuments, WebDiagrams, ExternalFiles, Reports, Enterprise Objects
reviewGroupActionCompletedDocuments, WebDiagrams, ExternalFiles, ReportsUsers who have reviewed the cycle
reviewGroupActionPendingDocuments, WebDiagrams, ExternalFiles, ReportsUsers the review cycle is waiting on
reviewGroupUsersDocuments, WebDiagrams, ExternalFiles, ReportsAll users in the review cycle
reviewNextStartDateDocuments, WebDiagrams, ExternalFiles, ReportsDate when next scheduled review cycle will start
reviewStartDateDocuments, WebDiagrams, ExternalFiles, ReportsDate when the active, in-progress review cycle started
reviewStateDocuments, WebDiagrams, ExternalFiles, ReportsCycleState
risk:categoryControls, Control Instances, Risks, Risk InstancesRisk Category
riskDataSeriesTypeRisk and Risk Instances
riskFinancialImpactUnitRisk and Risk Instances
riskPreemptRisk and Risk Instances
riskWeightingRisk and Risk Instances
rollsUpPerformance Indicator
rootResourceTypeResourceType ObjectsRootResourceType
sapCustomTransactionSAP Transactionstrue/false
sapDocumentBlueprintRelevantDocuments, WebDiagrams, ExternalFiles, Reportstrue/false
sapDocumentStatusDocuments, WebDiagrams, ExternalFiles, ReportsSAPStatus
sapDocumentTypeDocuments, WebDiagrams, ExternalFiles, Reports
sapInScopeSAP objectstrue/false
sends (.to, .workProduct)Process, Activity, External Agent
shapeLibraryUsedByWeb Diagram
shortcutsAll
shortcutToShortcuts
sizeDocuments, WebDiagrams, ExternalFiles, Reports
specialResourceTypeResourceType ObjectsSpecialResourceType
subtypeControls, Control Instances, Performance Indicators, Risks, Risk InstancesThe sub type of the type. Examples include Business Rule, Control, Gap, Measurement, Instance and Compliance
summaryAll
supports (.object, .sapInScope)Process/Activity, Class, Interface/Service, Journey/Moment/Touch, Capability, Product, Business Service, External Agent, Operation, Resource, SAP Branch/SAP Scenario/SAP Process/SAP Process Step, SAP Interface, SAP Service, SAP Master Data, SAP Transaction
textAllFulltext search for words included in string fields and document content. Only available as filter property.
threatPosedByAll Enterprise Objects(Web-authored) Diagram, (Client-authored) IGX Document, IGX Diagram, IGX Sheet, External File, Web Address
typeAllObjectType
urlWeb Addresses
usesShapeLibraryShape Library
versionDocuments, WebDiagrams, ExternalFiles, ReportsUser Displayable version of object
versionIDDocuments, WebDiagrams, ExternalFiles, ReportsInternal version of object
workProductLayerWork ProductsWorkProductLayer


Custom Properties

When you create custom object properties in a repository, they are assigned a display name and a property name. The property name must start with a letter, and use only letters, numbers, and underscores. This is required so that you can use this custom property name as an element in report filter strings.

To use a custom property in a report filter string, prefix it with "custom:".

For example, if you had a custom property named "kpiCategory" you could use it in a report filter string as "custom:kpiCategory".