IQL query samples

Report Results

The 17.8.1 release includes changes that enable significant performance improvements in reporting.  However, these changes do impact report results for users who only have the ability to see Approved versions.  When creating a report for users without the ability to see unapproved versions (e.g. Viewers) - it's important to choose the Approved Version option.  If you have existing reports, which target this audience, it's important to make sure this option is selected.

While Latest Version is a valuable tool for users with the ability to see unapproved versions (e.g. Authors), for users without, the report results are limited to the latest versions which are also approved versions.

The following example Report definitions will return different results based on the permissions of the user running them. For any Generic List or Table report, choosing Approved Version adds the explicit choice to additionally limit the results to '...and approved'.

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.

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".

Note that 

not (ancestor.name="Accounts Payable")

and

ancestor.name<>"Accounts Payable"

do NOT accomplish this. Since "ancestor.name" is a list of names, the above two will usually be true because at least one ancestor will not have the name "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.