# Google Analytics

IQL query samples



The page provides a list of example Report definitions.

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

Approved Version

Unselected (unchecked)

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

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

Properties

responsible, summary, purpose

Approved Version

Unselected (unchecked)

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

Approved Version

Unselected (unchecked)

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

Approved Version

Unselected (unchecked)

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

Approved Version

Selected (checked)

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

Approved Version

Selected (checked)

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

Approved Version

Unselected (unchecked)

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.

Approved Version

Not selected (unchecked)

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

Approved Version

Not selected (unchecked)

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

Approved Version

Not selected (unchecked)

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

Approved Version

Not selected (unchecked)

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

Approved Version

Not selected (unchecked)

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

Approved Version

Not selected (unchecked)


This article contains