IQL query samples

Created by ME

This query lists all documents and objects that have been created by the user who is currently logged in and has a resource object linked to the user. Read more: Linking Users to Labor Resources

Created within last week

This query lists all documents and objects that have been created within the last week, and shows who is responsible for them, their Summary, and Purpose.

Created or modified this month

This query lists all documents and objects that have been modified this month, and shows who is responsible for them, their Summary, and Purpose.

Modified between 3 and 6 months ago

This query lists all documents and objects that have been modified between 3 and 6 months ago, and shows the modify date and create date.

Client documents (.igx files) not modified in over one year

This query lists all .igx files that have not been modified in over one year, and shows shows the modify date and create date.

Not endorsed documents

This query returns a list of iGrafx Client documents that have not been endorsed, showing columns for owner, folder, and last modification date, and including approved documents only.

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 was started and who started the cycle. Similar reports can be created for Review and Endorse cycles. In addition, use "approvalNextStartDate" for the Filter to report approval cycles that are scheduled to start in the future.

RACI Matrix

This query creates a RACI matrix of processes and resources.

When you run this query, a View Options drop-down list appears, where you can select "all" or any of the specific relationships that will affect which intersections in the matrix appear gray. An Include All Objects check box also appears; if selected, all processes and resources appear in the matrix, otherwise the matrix will show only Processes and Resources that have relationships.

Strategic KPIs

This query returns a list of strategic KPIs and any performance indicators that are rolled into them, along with their types.

Risk Map

This query returns a risk map for processes within a business unit (folder).

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.

Text contained in within a field or document content

This query returns a list of objects containing the word "bird" or "nest" in any text field (i.e. name or summary) of the object itself or in the content if the object is a document (i.e. igx or pdf files)

To filter for a string the ~ character is used as 'like' operator is used not the equal sign.

The text is a property only available for the filter configuration but can't be returned in the result.

Diagrams that do not describe any object

This query returns a list of diagrams (Client-authored or web-authored) that do not describe any object from either the diagram or any shape on the diagram.

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.

Note: This also returns diagrams where the approval on a diagram was revoked and a new (or previous) version has not been approved.

Web Diagrams checked out to ME

This query lists the checkout time for all web diagram objects that are checked out by the user who is currently logged in and has a resource object linked to the user. Read more: Linking Users to Labor Resources

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.  A similar report on GROUP, JOB, PERSON, etc. can be performed.

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, then you can 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 are unsure then you can use the ID like this:

ancestor.ID=42

All files NOT in the "Accounts Payable" folder

This query returns a list of all files that are not in or under the "Accounts Payable" folder. Substitute your folder name for "Accounts Payable".

All Work Products in a part of the object folder structure

This query returns a list of all Work Products, you can combine it with a filter for the ID or name of a folder to limit the results.

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. Please note the the login user needs to be linked to the person resource in the repository.

All Diagrams that have open comment threads

This query returns a list of all items in the repository which have open comments, and shows how many there are for each item.