# Google Analytics

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.

SettingValue

Report Type

Generic List or Table

Filter

createDate > -7d

Properties

responsible, summary, 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.

SettingValue

Report Type

Generic List or Table

Filter

(createDate > -1m or modifyDate > -1m)

Properties

responsible, summary, 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.

SettingValue

Report Type

Generic List or Table

Filter

(modifyDate > -180d) and (modifyDate < -90d)

Properties

modifyDate, createDate

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.

SettingValue

Report Type

Generic List or Table

Filter

type=ObjectType.DOCUMENT  and  (modifyDate < -1y)

Properties

modifyDate, createDate

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.

SettingValue

Report Type

Generic List or Table

Filter

type=ObjectType.DOCUMENT and endorsed=false

Properties

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

SettingValue

Report Type

Generic List or Table

Filter

approvalStartDate

Properties

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

SettingValue

Report Type

Generic Matrix

Row Filter

type=ObjectType.PROCESS
Column Filtertype=ObjectType.RESOURCE

Relationships

responsible, accountable, consulted, informed

Strategic KPIs

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

SettingValue

Report Type

Generic List or Table

Filter

type=ObjectType.PERFORMANCE_INDICATOR and subtype.name="Strategic Performance Indicator (S-KPI)"

Properties

rollsUp subtype

Risk Map

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

SettingValue

Report Type

Risk Map

Filter

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.

SettingValue

Report Type

Generic List or Table

Filter

type=ObjectType.DIAGRAM

Properties

diagramElement.shapeNumber, diagramElement.custom:prop1, diagramElement.custom:prop2

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)

SettingValue

Report Type

Generic List or Table

Filter

text~"bird nest"

Properties

none necessary

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.

SettingValue

Report Type

Generic List or Table

Filter

(type=ObjectType.DIAGRAM or type=ObjectType.WEB_DIAGRAM) and not describes and not diagramElement.describes

Properties

No properties necessary.

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.

SettingValue

Report Type

Generic List or Table

Filter

resourceType.specialResourceType=SpecialResourceType.ROLE

Properties

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, 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
SettingValue

Report Type

Generic List or Table

Filter

ancestor.name="Accounts Payable"

Properties

as desired

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

SettingValue

Report Type

Generic List or Table

Filter

ancestor.name not in ("Accounts Payable")

Properties

as desired

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.

SettingValue

Report Type

Generic List or Table

Properties

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

SettingValue

Report Type

Generic List or Table

Properties

responsible.resource = ME

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.

SettingValue

Report Type

Generic List or Table

Filter

openCommentsCount
PropertiesopenCommentsCount


This article contains