Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • currentUser() - Filter on user attributes connected to the current (logged in) user. Attribute needs to be of type User.
  • currentReporter() - Filter on user attributes connected to current reporter in custom fields. Attribute needs to be of type User.
  • user(user1, user2, ..) - Filter on user attributes having the specified users

Group:

  • group(group1, group2,...) - Filter on any object connected to a user within a specific group.
  • user(user1, user2, ...) - Filter on any object connected to a user within a specific group.

Code Block
titleExample
User in group("jira-users", "jira-administrators")
User having user("admin")
Group having user("currentReporter()")

Project:

  • currentProject() - Filter on any object connected to the current project in a custom field. Works only in the context of a ticket.

Code Block
Project = currentProject()


References:

The reference functions can take two arguments: an IQL and/or Reference Types Names.

The IQL argument can be an arbitrary IQL including an IQL with reference function. 

The Reference Type argument is optional.

NameAliasDescription

inboundReferences(IQL)

inR(IQL)Filter objects having inbound references where the objects referencing to the object matches the IQL, e.g. object having inboundReferences() filters all objects having inbound references since the empty IQL will match all objects. If the query is changed to object having inboundReferences(Name="My Name") all objects that are referenced by an object with the name "My Name" are filtered.
outboundReferences(IQL)outR(IQL)Filter objects having outbound references where the referenced objects match the IQL, e.g. object having outboundReferences() filters all objects having outbound references since the empty IQL will match all objects.
inboundReferences(IQL, referenceTypes)
inR(IQL, refTypes)

Filter object having inbound references where the objects referencing to the object matches the IQL. E.g. object having inboundReferences() will filter all objects having inbound references since the empty IQL will match all objects. If the query is changed to object having inboundReferences(Name="My Name") all objects that is referenced by an object with the name My Name will be filtered.

The Reference Type argument can be simple or advanced:

simple can take only one Reference Type name as parameter and looks like "Installed", e.g. object having inR("", "Installed")

advanced has the following structure: argumentName + operator + ("value 1", "value 2", "value 3"), where

      • argumentName: refType or referenceType
      • operator: IN or NOT IN
outboundReferences(IQL, referenceTypes)
outR(IQL, refTypes)

Filter object having outbound references where the referenced objects match the IQL. E.g. object having outboundReferences() will filter all objects having outbound references since the empty IQL will match all objects.

The Reference Type argument can be simple or advanced:

simple can take only one Reference Type name as parameter and looks like "Installed"

e.g. object having outR("", "Installed")

advanced has the following structure: argumentName + operator + ("value 1", "value 2", "value 3"), where

      • argumentName: refType or referenceType
      • operator: IN or NOT IN
    e.g. object having inR(label = application, refType IN ("depends", "installed", "using"))

Placeholders, references, and IQL can be combined in powerful ways. For example, you could add multiple object references to a custom field attached to an object, and then search those references for a specific key:

Code Block
titleExample
object HAVING inboundReferences(Key IN (${MyCustomField${0}}))

Or a specific label, by using dot notation:

Code Block
titleExample
object HAVING inboundReferences(Label IN (${Portfolios.label${0}}))

Connected Tickets:

The connectedTickets() function is used to filter objects having tickets connected to them. Specific Jira issues may be selected by providing a proper Jira Query Language (JQL) query. If no JQL query is provided, all objects having Jira issues connected are returned.

NameDescription
connectedTickets()
All objects having tickets connected to them are returned.
connectedTickets(JQL)
Object having tickets connected to them that match given JQL queryare returned.
Info

Please observe that this powerful function may produce results that are not obvious at the first sight especially when complex queries, that uses for example negation, are constructed. To help interprete them one should think about the query as a two step action: 1. JQL execution 2. IQL execution operating on the JQL result.

Info

To avoid confusion please remember that Insight Object Detail View presents Unresolved connected tickets by default.

Code Block
titleExamples
object HAVING connectedTickets(labels is not empty)
object NOT HAVING connectedTickets(labels is empty)
object HAVING connectedTickets()
Warning

"connectedJiraIssues" is deprecated


Object Types:

  • objectTypeAndChildren(Name) - Filter objects based on the object type specified by the Name and its children.
  • objectTypeAndChildren(ID) - Filter objects based on the object type specified by the ID and its children.
Code Block
titleExample
objectType in objectTypeAndChildren("Object Type Name")


...