Skip to main content

IQL query properties

Properties

Property elements are the iGrafx Query Language (IQL) elements that specify properties an object may have, and they appear in the report as columns in a list. Most can also 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.

Property

Possible Values

Applies To

accountable (.resource, .role)

Resource objects

All

acknowledgementApplicant

username of the user who started the running cycle

Documents, WebDiagrams, ExternalFiles, Reports

acknowledgementCycleLog

All actions that take place in acknowledgement cycles

Documents, WebDiagrams, ExternalFiles, Reports

acknowledgmentCycleNonparticipants

Users in the cycle that have not acknowledged yet.

Documents, WebDiagrams, ExternalFiles, Reports

acknowledgementCycleParticipation

Acknowledged By usernames

Documents, WebDiagrams, ExternalFiles, Reports

acknowledgementGroupActionCompleted

Users who have acknowledged in the cycle (only accessible if a cycle is running on the respective version)

Documents, WebDiagrams, ExternalFiles, Reports

acknowledgementGroupActionPending

Users the acknowledgement cycle is waiting on (only accessible if a cycle is running on the respective version)

Documents, WebDiagrams, ExternalFiles, Reports

acknowledgementGroupActions

Cycle groups in the current acknowledgement cycle, and actions taken by members of those groups

Documents, WebDiagrams, ExternalFiles, Reports

acknowledgementGroupName

The name of the cycle group assigned to this object for acknowledgement cycles

Documents, WebDiagrams, ExternalFiles, Reports

acknowledgementGroupUsers

All users in the acknowledgement cycle group configured for this object

Documents, WebDiagrams, ExternalFiles, Reports

acknowledgementStartDate

Date when the active, in-progress acknowledgement cycle started

Documents, WebDiagrams, ExternalFiles, Reports

acknowledgementState

CycleState

Documents, WebDiagrams, ExternalFiles, Reports

activeAcknowledgementGroupName

The name of the cycle group used by the currently-running acknowledgement cycle

Documents, WebDiagrams, ExternalFiles, Reports

activeApprovalGroupName

The name of the cycle group used by the currently-running approval cycle

Documents, WebDiagrams, ExternalFiles, Reports

activeEndorsementGroupName

The name of the cycle group used by the currently-running endorsement cycle

Documents, WebDiagrams, ExternalFiles, Reports

activeReviewGroupName

The name of the cycle group used by the currently-running review cycle

All

allocation

Resource objects

Resources

ancestor

Access objects that have this common ancestor

All

approvalApplicant

username of the user who started the running cycle

Documents, WebDiagrams, ExternalFiles, Reports

approvalCycleLog

All actions that take place in approval cycles

Documents, WebDiagrams, ExternalFiles, Reports

approvalCycleNonparticipants

Users in the cycle that have not voted yet. Note that some users listed might not be able to vote currently if they are in an ordered cycle group, or if they are in a group that already has the required number of voters.

Documents, WebDiagrams, ExternalFiles, Reports

approvalCycleParticipation

Vote Approval Yes, Vote Approval No by usernames

Documents, WebDiagrams, ExternalFiles, Reports

approvalDate

Date when approved

Documents, WebDiagrams, ExternalFiles, Reports

approvalDateOmitVersion

Date when any version of the object was last approved

Documents, WebDiagrams, ExternalFiles, Reports

approvalGroupActionCompleted

Users who have voted in the cycle (only accessible if a cycle is running on the respective version)

Documents, WebDiagrams, ExternalFiles, Reports

approvalGroupActionPending

Users the approval cycle is waiting on (only accessible if a cycle is running on the respective version)

Documents, WebDiagrams, ExternalFiles, Reports

approvalGroupActions

Cycle groups in the current approval cycle, and actions taken by members of those groups

Documents, WebDiagrams, ExternalFiles, Reports

approvalGroupName

The name of the cycle group assigned to this object for approval cycles

Documents, WebDiagrams, ExternalFiles, Reports

approvalGroupUsers

All users in the approval cycle group configured for this object

Documents, WebDiagrams, ExternalFiles, Reports

approvalNextStartDate

Date when next scheduled approval cycle will start

Documents, WebDiagrams, ExternalFiles, Reports

approvalStartDate

Date when the active, in-progress approval cycle started

Documents, WebDiagrams, ExternalFiles, Reports

approvalState

CycleState

Documents, WebDiagrams, ExternalFiles, Reports

approved

true/false

Documents, WebDiagrams, ExternalFiles, Reports

approvers

All users that have voted yes on the latest approval of the given version of an object

Documents, WebDiagrams, ExternalFiles, Reports

audits

Products, Business Services, Processes, Controls

Business Services, Capabilities, Processes, Journeys, Resources, Interfaces

benefitProvidedBy


Any Objects

All Enterprise Objects, (Web-authored) Diagram, (Client-authored) IGX Document, IGX Diagram, IGX Sheet, External File, Web Address

changeDate

date/time

All

checkedOutDate

date/time

Documents, WebDiagrams, ExternalFiles, Reports

checkedOutTo

username

Documents, WebDiagrams, ExternalFiles, Reports

child

All direct children objects

All

comment

check-in comment

Documents, WebDiagrams, ExternalFiles, Reports

comments (.author, .content, .date, .resolved)

All comments and replies.

comments.resolved: true/false

WebDiagrams, IGX Diagrams

commentsCount

number, count of all comments and replies

WebDiagrams, IGX Diagrams

consulted (.resource, .role)

Resource objects

All

controls

Processes, Activities, Business Services

Business Services

createDate

date/time

All

creationSource

CreationSource type values. This mostly applies to Diagram objects, but can also include any enterprise objects created via standalone proposals.

All

creator

username

All

currentApprovedVersionID

The version ID of the current approved version of the object. The value is zero if it has not been approved or if there is no current approved version.

Documents, WebDiagrams, ExternalFiles, Reports

currentRiskData.factDate

date/time

Risks, Risk Instances

currentRiskData.factFinancialImpact

numeric value

Risks, Risk Instances

currentRiskData.factValue

numeric value

Risks, Risk Instances

currentRiskData.inherentRisk

numeric value and range color

Risks, Risk Instances

currentRiskData.initialRisk

numeric value and range color

Risks, Risk Instances

currentRiskData.reason

text string

Risks, Risk Instances

currentRiskData.residualRisk

numeric value and range color

Risks, Risk Instances

currentRiskData.risk:appetite

Level

Risks, Risk Instances

currentRiskData.risk:impact

Level

Risks, Risk Instances

currentRiskData.risk:likelihood

Level

Risks, Risk Instances

currentRiskData.savedBy

Username

Risks, Risk Instances

currentRiskDataIcs.factDate

date/time — the date the data point becomes effective

Risks, Risk Instances (ICS)

currentRiskDataIcs.riskRelevantObject

The linked risk-relevant object the data point is recorded against, or empty

Risks, Risk Instances (ICS)

currentRiskDataIcs.initialFinancialImpact (.residualFinancialImpact, .targetFinancialImpact)

numeric value, in the repository's ICS risk currency

Risks, Risk Instances (ICS)

currentRiskDataIcs.initialLikelihood (.residualLikelihood, .targetLikelihood)

percentage (0–100)

Risks, Risk Instances (ICS)

currentRiskDataIcs.initialRegulatoryImpact (.residualRegulatoryImpact, .targetRegulatoryImpact)

Not Applicable, Low, Medium, High

Risks, Risk Instances (ICS)

currentRiskDataIcs.initialReputationalImpact (.residualReputationalImpact, .targetReputationalImpact)

Not Applicable, Low, Medium, High

Risks, Risk Instances (ICS)

currentRiskDataIcs.isMaterial

Empty, True, False — whether the current data point is considered material

Risks, Risk Instances (ICS)

currentRiskDataIcs.reason

text string

Risks, Risk Instances (ICS)

currentRiskDataIcs.savedBy

Username

Risks, Risk Instances (ICS)

custom:xxxx

Custom Properties and their custom types are user defined for specific object types

Any

deliveredBy

Capabilities

Product, Business Service

delivers

Products, Business Services

Capability

depth

Depth in the repository tree hierarchy (0=Root, 1 = within a top level folder, etc.)

All

describes

Can also access this relationship for diagram elements on the diagram as

diagramElement.describes

Diagram and WebDiagram

describesState

Contains information if the diagram itself or the respective diagram element describe an object in your enterprise model. Possible values are

  • None

  • Accepted (see property: describes )

  • New Object Proposed

  • Existing Object Proposed (see property: proposedObject)

WebDiagram and Diagram Elements

diagramElement (.ID, .name, .describes, .describesState, .diagram, .elementType, .note, .proposedObject, .shapeNumber)

Special relationship to access Custom Properties on objects inside a diagram (via .custom:property)

Diagram and WebDiagram

diagramType

ArchiMate, Basic, BPMN, Cause and Effect, Generic, IDEF, Journey, Navigation, Process, Value Stream Map

Diagram and WebDiagram

elementType

Can also access element type for diagram elements in the diagram as

diagramElement.elementType

See list of element types

Diagram and WebDiagram

documents

Enterprise Objects

Documents, WebDiagrams, WebAddresses, ExternalFiles

electiveWatchers

List of users who have elected to watch the object

All

enabledBy

Capability

Process/Activity, Journey/Moment/Touch

enables

Process/Activity, Journey/Moment/Touch

Capability

endorsed

true/false

Documents, WebDiagrams, ExternalFiles, Reports

endorsementApplicant

username of the user who started the running cycle

Documents, WebDiagrams, ExternalFiles, Reports

endorsementCycleLog

All actions that take place in endorsement cycles

Documents, WebDiagrams, ExternalFiles, Reports

endorsementCycleNonparticipants

Users in the cycle that have not endorsed yet. Note that some users listed might not be able to endorse currently if they are in an ordered cycle group, or if they are in a group that already has the required number of endorsers.

Documents, WebDiagrams, ExternalFiles, Reports

endorsementCycleParticipation

Endorsed By usernames

Documents, WebDiagrams, ExternalFiles, Reports

endorsementDate

Date when endorsed

Documents, WebDiagrams, ExternalFiles, Reports

endorsementDateOmitVersion

Date when any version of the object was last endorsed

Documents, WebDiagrams, ExternalFiles, Reports

endorsementGroupActionCompleted

Users who have endorsed the cycle (only accessible if a cycle is running on the respective version)

Documents, WebDiagrams, ExternalFiles, Reports

endorsementGroupActionPending

Users the endorsement cycle is waiting on (only accessible if a cycle is running on the respective version)

Documents, WebDiagrams, ExternalFiles, Reports

endorsementGroupActions

Cycle groups in the current endorsement cycle, and actions taken by members of those groups

Documents, WebDiagrams, ExternalFiles, Reports

endorsementGroupName

The name of the cycle group assigned to this object for endorsement cycles

Documents, WebDiagrams, ExternalFiles, Reports

endorsementGroupUsers

All users in the endorsement cycle group configured for this object

Documents, WebDiagrams, ExternalFiles, Reports

endorsementNextStartDate

Date when next scheduled endorsement cycle will start

Documents, WebDiagrams, ExternalFiles, Reports

endorsementStartDate

Date when the active, in-progress endorsement cycle started

Documents, WebDiagrams, ExternalFiles, Reports

endorsementState

CycleState

Documents, WebDiagrams, ExternalFiles, Reports

endorsers

All users that have submitted a vote in the latest endorsement cycle of the given version of an object

Documents, WebDiagrams, ExternalFiles, Reports

flows (.from, .to)

Enterprise objects

Work Product

folderName

text string. Name of the direct parent folder.

All

groupRoleAssignments

The groups and respective item roles directly assigned on an object.

ℹ️ This property does not show item roles inherited from ancestors, only group assignments made on the object itself.

All

hasCapability

Capability

Resource, External Agent

hasControlInstance

Control Instance

Control

hasGoal

Goal

Enterprise Objects

hasLocation

Resource

Resources

hasOpportunity


Risk

All Enterprise Objects, (Web-authored) Diagram, (Client-authored) IGX Document, IGX Diagram, IGX Sheet, External File, Web Address

hasOpportunityInstance

Opportunity Instance

Opportunity

hasRequirement

Requirement

Enterprise Objects

hasRisk

Associated risk objects of an Enterprise Object through the Has Risk relationship

All Enterprise Objects, (Web-authored) Diagram, (Client-authored) IGX Document, IGX Diagram, IGX Sheet, External File, Web Address

hasRiskInstance

Associated risk instance objects of an Enterprise Object through the Has Risk Instance relationship

Enterprise Objects

hasRiskRelevantObject

The risk-relevant objects (such as a Resource/Legal Entity) linked to this risk. This relationship is managed through the Data tab on ICS style risks.

Risks and Risk Instances

hasSAPLogicalComponent

true/false

SAPProcessSteps, SAPMasterData, SAPInterfaces

hasStrategy

Strategy

Enterprise Objects

ID

Repository ID or Diagram Element ID

All

implements

Control

Process/Activity, Journey/Moment/Touch, Capability, Product, Business Service, Work Products

informed (.resource, .role)

Resources

All

isAccountableFor (.object, .role)

All objects

Resources

isAllocatedTo

Resources

Resources

isAuditedBy

Business Rules, Capabilities, Processes, Journeys, Resources, Interfaces

Products, Business Rules, Processes, Controls

isCapabilityFor

Resource, External Agent

Capability

isCheckedOut

true/false

Documents, WebDiagrams, ExternalFiles, Reports

isConsultedAbout (.object, .role)

All objects

Resources

isControlInstanceFor

Control

Control Instance

isControlledBy

Control

Enterprise Objects

isDescribedBy

Processes

Diagrams, Web Diagrams

isDescribedByDiagramElement

text string. Name of shape in diagram.

Enterprise Objects

isDocumentedBy

Web Diagrams, External Files

Enterprise Objects

isDocumentedByUrl

clickable link

Enterprise Objects

isGoalOf

Enterprise objects

Goals

isImplementedBy

Process

Control, Control Instance, Class

isInformedAbout (.object, .role)

All objects

Resources

isKeyControl

true/false

Control, Control Instance

isLocationOf

Resources

Resources

isMeasuredBy

Performance Indicators

Enterprise Objects

isOpportunityFor

All non-folder objects

Risk, Risk Instance,Opportunity, Opportunity Instance

isOpportunityInstanceFor

All non-folder objects

Risk Instance, Opportunity Instance

isRequirementOf

Enterprise objects

Requirement

isResponsibleFor (.object, .role)

All objects

Resources

isRiskFor

All non-folder objects

Risk, Risk Instance, Opportunity, Opportunity Instance

isRiskInstanceFor

All non-folder objects

Risk Instance

isRolledUpIn

Performance Indicators

Performance Indicator

isSAPLogicalComponentFor

Enterprise objects

SAP Logical Component

isStrategyOf

Enterprise objects

Strategy

isSupportedBy (.object, .sapInScope)

Process, Activity, Classes, Resources, Interfaces

Enterprise Objects (most)

lastApprovalEffectiveEndDate

The most recent date that the effective approval date for any version of an object was revoked.

All

linkedUrl1

clickable links. (Links defined on shapes within Diagrams)

Web Diagrams, IGX Diagrams

linkedUserToResource(.username, .enabled, .id)

References the user that is linked to a resource. *enabled and Id are not available as a filter property

Resources

linksObject

References repository objects that are linked in diagram elements and diagram element notes, summary, purpose or description.

All

ME

Returns the Resource Object associated with the logged-in user. Only available as filter property.

User mapped to Resource

materialityThreshold.startDate

date/time — when the materiality threshold value becomes effective

Risk-relevant objects (ICS)

materialityThreshold.thresholdValue

numeric value — the value at which a linked risk's data is considered material

Risk-relevant objects (ICS)

measures

Enterprise objects.

Performance Indicator

modifier

username

All

modifyDate

date/time

All

name

text string. Name of object.

All

objectLinkedBy

References objects that contain diagram elements, notes, summary, purpose or instructions that link to this repository object

All

openComments (.date)

All unresolved comments (with date)

WebDiagrams, IGX Diagrams

openCommentsCount

number, count of unresolved comments

WebDiagrams, IGX Diagrams

owner

username

All

parent

The direct parent object

All

piDataSeriesType

PIDataSeriesType

Performance Indicators

piFactIdentifer

text string. Hash identifier for the Performance Indicator.

Performance Indicators

piPreempt

true/false

Performance Indicators

piRatingSystem

PIRatingSystem

Performance Indicators

piType

PIType

Performance Indicators

piUnit

text string. Unit name for the values

Performance Indicators

piWeighting

PIWeighting

Performance Indicators

posesThreatTo


all non-folder objects

All Enterprise Objects, (Web-authored) Diagram, (Client-authored) IGX Document, IGX Diagram, IGX Sheet, External File, Web Address

processOwner

username. Indicates the person (not resource object) that is the Process Owner for this object.

Diagrams, Processes

projectEndDate

date/time

Documents, WebDiagrams, ExternalFiles, Reports

projectName

text string

Documents, WebDiagrams, ExternalFiles, Reports

projectPercentComplete

text string. Numerical value.

Documents, WebDiagrams, ExternalFiles, Reports

projectStartDate

date/time

Documents, WebDiagrams, ExternalFiles, Reports

proposedObject

If the describesState of a diagram is Existing Object Proposed , this property will contain the object that was proposed for the describes relationship.

WebDiagrams and Diagram Elements

providesBenefitTo


all non-folder objects

All Enterprise Objects, (Web-authored) Diagram, (Client-authored) IGX Document, IGX Diagram, IGX Sheet, External File, Web Address

purpose

text string. Purpose descriptions

All

rating

Control Rating

Controls, Control Instances

receives (.from, .workProduct)

Work Product

Process, Activity, External Agent

requiredFor

Moment, Touch, Product, Business Service

Capability

requiredGroupWatchers

List of groups that are required to watch the object

All

requiredUserWatchers

List of users that are required to watch the object

All

requirementType

RequirementType

Requirements

requires

Capability

Moment, Touch, Product, Business Service

resourceAttended

Only applies to Resources of type Bot

Resources

resourceAvailabilityPercentage

text string

Resources

resourceAvailabilityTimeAwayExpression

text string

Resources

resourceAvailabilityTimeAwayUnit

TimeUnit

Resources

resourceCount

text string. Numeric value

Resources

resourceCountUnlimited

true/false

Resources

resourceHourlyRate

text string

Resources

resourceLatitude

text string

Resources

resourceLongitude

text string

Resources

resourceMaximumHourlyOvertimePerDay

text string

Resources

resourceOvertimeHourlyRate

text string

Resources

resourcePerUseCost

text string

Resources

resourceType

Access RESOURCE_TYPE object from RESOURCE object

Resources

responsible (.resource, .role)

Resources

All

reviewApplicant

username of the user who started the running cycle

Documents, WebDiagrams, ExternalFiles, Reports

reviewCycleLog

All actions that take place in review cycles

All

reviewCycleNonparticipants

Users in the cycle that have not reviewed yet. Note that some users listed might not be able to review currently if they are in an ordered cycle group, or if they are in a group that already has the required number of reviewers.

All

reviewCycleParticipation

Reviewed By usernames

All

reviewDate

Date when reviewed

Documents, WebDiagrams, ExternalFiles, Reports

reviewDateOmitVersion

Date when any version of the object was last reviewed

Documents, WebDiagrams, ExternalFiles, Reports

reviewed

true/false

Documents, WebDiagrams, ExternalFiles, Reports

reviewers

All users that have submitted a vote in the latest review cycle of the given version of an object

Documents, WebDiagrams, ExternalFiles, Reports, Enterprise Objects

reviewGroupActionCompleted

Users who have reviewed the cycle (only accessible if a cycle is running on the respective version)

Documents, WebDiagrams, ExternalFiles, Reports

reviewGroupActionPending

Users the review cycle is waiting on (only accessible if a cycle is running on the respective version)

Documents, WebDiagrams, ExternalFiles, Reports

reviewGroupActions

Cycle groups in the current review cycle, and actions taken by members of those groups

Documents, WebDiagrams, ExternalFiles, Reports

reviewGroupName

The name of the cycle group assigned to this object for review cycles

All

reviewGroupUsers

All users in the review cycle group configured for this object

All

reviewNextStartDate

Date when next scheduled review cycle will start

Documents, WebDiagrams, ExternalFiles, Reports

reviewStartDate

Date when the active, in-progress review cycle started

Documents, WebDiagrams, ExternalFiles, Reports

reviewState

CycleState

Documents, WebDiagrams, ExternalFiles, Reports

risk:category

Risk Category

Controls, Control Instances, Risks, Risk Instances

riskDataSeriesType

text string

Risk and Risk Instances

riskFinancialImpactUnit

text string

Risk and Risk Instances

riskPreempt

true/false

Risk and Risk Instances

riskRelevantObjectFor

The risks and risk instances this object is linked to as a risk-relevant object. This relationship is managed on the Data tab for ICS style risks.

Enterprise Objects

riskWeighting

text string

Risk and Risk Instances

rollsUp

Performance Indicator

Performance Indicator

rootResourceType

RootResourceType

ResourceType Objects

sapCustomTransaction

true/false

SAP Transactions

sapDocumentBlueprintRelevant

true/false

Documents, WebDiagrams, ExternalFiles, Reports

sapDocumentStatus

SAPStatus

Documents, WebDiagrams, ExternalFiles, Reports

sapDocumentType

text string

Documents, WebDiagrams, ExternalFiles, Reports

sapInScope

true/false

SAP objects

scheduledCycles

multipart data. Provides cycleType, scheduler (user name), scheduleType (text string), nextScheduledDate (date/time), manualStart (true/false), and comment (text string)

All

sends (.to, .workProduct)

Work Product

Process, Activity, External Agent

shapeLibraryUsedBy

Shape Library

Web Diagram

shortcuts

Shortcut objects

All

shortcutTo

All objects

Shortcuts

size

text string. Numeric value

Documents, WebDiagrams, ExternalFiles, Reports

specialResourceType

SpecialResourceType

ResourceType Objects

subtype

The sub type of the type. Examples include Business Rule, Control, Gap, Measurement, Instance and Compliance

Controls, Control Instances, Performance Indicators, Risks, Risk Instances

summary

text string. Summary description

All

supports (.object, .sapInScope)


Capability, Process, Activity

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

text

Fulltext search for words included in string fields and document content. Only available as filter property.

All

threatPosedBy


All non-folder objects

All Enterprise Objects, (Web-authored) Diagram, (Client-authored) IGX Document, IGX Diagram, IGX Sheet, External File, Web Address

type

ObjectType

All

url

clickable link

Web Addresses

userRoleAssignments

The users and respective item roles directly assigned on an object.

ℹ️ This property does not show item roles inherited from ancestors, only user assignments made on the object itself.

All

usesShapeLibrary

Web Diagram

Shape Library

version

User Displayable version of object

Documents, WebDiagrams, ExternalFiles, Reports

versionID

Internal version of object

Documents, WebDiagrams, ExternalFiles, Reports

workProductLayer

WorkProductLayer

Work Products

warning

SAP functionality is retired. Existing SAP objects are retained, though you can no longer create new SAP objects and connections.

The currentRiskDataIcs and materialityThreshold properties apply to ICS risks — see ICS risks for what they represent.

Custom properties

When you create a custom object property in a repository, you give it a display name and a property name. The property name must start with a letter, and use only letters, numbers, and underscores — this lets you use it as an element in report filter strings.

To use a custom property in a report filter string, prefix it with "custom:". For example, a custom property named "kpiCategory" appears in a report filter string as "custom:kpiCategory".