IQL query samples
Worked iGrafx Query Language (IQL) examples for common reporting scenarios. Copy a sample's settings into your own report, then adjust the filter and properties to fit your repository. For the syntax itself, see Use IQL in a report.
Created by ME
This query lists all documents and objects created by the signed-in user. It requires your user account to be linked to a resource object. Read more: Linking Users to Labor Resources
Report Type: Generic List or Table
creator=ME.linkedUserToResource
creator
Created within last week
This query lists all documents and objects created within the last week, and shows who is responsible for them, their Summary, and Purpose.
Report Type: Generic List or Table
createDate > -7d
responsible, summary, purpose
Created or modified this month
This query lists all documents and objects modified this month, and shows who is responsible for them, their Summary, and Purpose.
Report Type: Generic List or Table
(createDate > -1mos or modifyDate > -1mos)
responsible, summary, purpose
Modified between 3 and 6 months ago
This query lists all documents and objects modified between 3 and 6 months ago, and shows the modify date and create date.
Report Type: Generic List or Table
(modifyDate > -180d) and (modifyDate < -90d)
modifyDate, createDate
Client documents (.igx files) not modified in over one year
This query lists all .igx files that haven't been modified in over one year, and shows the modify date and create date.
Report Type: Generic List or Table
type=ObjectType.DOCUMENT and (modifyDate < -1y)
modifyDate, createDate
Not endorsed documents
This query returns a list of iGrafx Client documents that haven't been endorsed, showing columns for owner, folder, and last modification date, and including approved documents only.
Report Type: Generic List or Table
type=ObjectType.DOCUMENT and endorsed=false
owner, folderName, modifyDate
Documents in an approval cycle
This query returns a list of all repository items that have an active, in-progress approval cycle, and shows when the cycle started and who started it. You can create similar reports for Review and Endorse cycles. To report approval cycles scheduled to start in the future, use "approvalNextStartDate" as the Filter instead.
Report Type: Generic List or Table
approvalStartDate
approvalStartDate, approvalApplicant
RACI matrix
This query creates a RACI matrix of processes and resources.
When you run this query, a View Options drop-down list appears. Select "all" or any of the specific relationships to control which intersections in the matrix appear gray. An Include All Objects check box also appears: if you select it, all processes and resources appear in the matrix; otherwise the matrix shows only processes and resources that have relationships.
Report Type: Generic Matrix
type=ObjectType.PROCESS
type=ObjectType.RESOURCE
responsible, accountable, consulted, informed
Strategic KPIs
This query returns a list of strategic KPIsKPI A quantitative measure used to evaluate process performance against a target — for example, average throughput time, automation rate, or rework percentage. and any performance indicators that are rolled into them, along with their types.
Report Type: Generic List or Table
type=ObjectType.PERFORMANCE\_INDICATOR and subtype.name="Strategic Performance Indicator (S-KPI)"
rollsUp subtype
Risk Map
This query returns a risk map for processes within a business unit (folder).
Report Type: Risk Map
type=ObjectType.PROCESS and ancestor.name="Commercial"
Custom properties within diagram
This query returns custom properties used within a Client-authored diagram and assumes that prop1 and prop2 have been defined as custom properties on Diagram Element.
Report Type: Generic List or Table
type=ObjectType.DIAGRAM
diagramElement.shapeNumber, diagramElement.custom:prop1, diagramElement.custom:prop2
Text contained within a field or document content
This query returns a list of objects containing the word "bird" or "nest" in any text field of the object itself (for example, name or summary), or in the content if the object is a document (for example, .igx or PDF files).
Report Type: Generic List or Table
text~"bird nest"
none necessary
To filter for a string, use the ~ character as a 'like' operator, not the equal sign.
Diagrams that do not describe any object
This query returns a list of diagrams (Client-authored or web-authored) that don't describe any object from either the diagram or any shape on the diagram.
Report Type: Generic List or Table
(type=ObjectType.DIAGRAM or type=ObjectType.WEB\_DIAGRAM) and not describes and not diagramElement.describes
No properties necessary.
Diagrams that have never been approved
This query returns a list of diagrams (Client-authored or web-authored) that have never completed an approval cycle.
This also returns diagrams where the approval on a diagram was revoked and a new (or previous) version hasn't been approved.
Report Type: Generic List or Table
currentApprovedVersionID = 0 and (type=ObjectType.DIAGRAM or type=ObjectType.WEB\_DIAGRAM)
No properties necessary.
Web diagrams checked out to ME
This query lists the checkout time for all web diagram objects checked out by the signed-in user. It requires your user account to be linked to a resource object. Read more: Linking Users to Labor Resources
Report Type: Generic List or Table
type=ObjectType.WEB\_DIAGRAM and checkedOutTo=ME.linkedUserToResource
checkedOutDate
All resources of type "Role" and what they are Responsible for
This query returns a list of resources of type "Role", their Parent object in the repository tree, and the repository object they are Responsible for. You can run a similar report on GROUP, JOB, PERSON, and the other resource types.
Report Type: Generic List or Table
resourceType.specialResourceType=SpecialResourceType.ROLE
parent isResponsibleFor
All files in the "Accounts Payable" folder
This query returns a list of all files in the "Accounts Payable" folder. Substitute your folder name for "Accounts Payable".
If you have two "Accounts Payable" folders, specify the correct folder by adding the parent folder name to the Filter like this:
ancestor.name="Accounts Payable" and ancestor.parent.name="North America"
If you're unsure, use the ID like this:
ancestor.ID=42
Report Type: Generic List or Table
ancestor.name="Accounts Payable"
as desired
All files NOT in the "Accounts Payable" folder
This query returns a list of all files that aren't in or under the "Accounts Payable" folder. Substitute your folder name for "Accounts Payable".
Report Type: Generic List or Table
not (ancestor.name = "Accounts Payable")
as desired
All Work Products in a part of the object folder structure
This query returns a list of all Work Products. To limit the results, combine it with a filter for the ID or name of a folder.
Report Type: Generic List or Table
sends
All objects the current user is responsible for
This query returns a list of all items in the repository the current user is directly responsible for. It requires the signed-in user to be linked to their person resource in the repository.
Report Type: Generic List or Table
responsible.resource = ME
All diagrams that have open comment threads
This query returns a list of all items in the repository that have open comments, and shows how many there are for each item.
Report Type: Generic List or Table
openCommentsCount
openCommentsCount
Processes with more than three responsible resources
This query returns processes that have more than three resources responsible for them, and shows the count of responsible resources for each. Wrap a relationship or list property in count(...) to count how many items it holds.
Report Type: Generic List or Table
type=ObjectType.PROCESS and count(responsible) > 3
count(responsible)