Versions Compared

Old Version 9

changes.mady.by.user Nisha Shantilal

Saved on

compared with

New Version 10

changes.mady.by.user Nisha Shantilal

Saved on

Key

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

Tableau Connector Pro for Jira app integrates with Insight in Jira Service Management. This integration further extends the capabilities of Insight asset and configuration management in Jira cloud and DC/Server to visualize the required data for actionable insights in Tableau. With this integration, you can import Insight Attributes and Insight Types field information to Tableau Desktop.

...

Note

Pre-requisite to use Insight (Assets):

Steps to integrate Tableau Connector Pro for Jira and Insight in Jira Service Management

Info

  • Insight is now called Assets. For more information, refer toInsight is now called Assets.

  • It is required to define a custom field in Jira to import the values of Insight Attributes and Insight Types.

...

4. A form displays the Jira and JSM fields. The Insight Attributes and Insight Types list the Insight fields.

Import the Insight data

Tableau Connector Pro for Jira Cloud

a. To import the Insight data, you need to set up the Email and API Token once. Enter the Email and API Token to grant access to Insight dataand select the required Insight fields for the data source. Click Continue.

...

d. To import the Insight data, click Continue. To know about the checks performed before importing Insight data, refer to Form validation.

Tableau Connector Pro for Jira Data Center

a. To import the Insight data, select the required Insight fields for the data source and click Continue.

...

d. Click Continue. To know about the checks performed before importing Insight data, refer to Form validation.

Data imported in Tableau Desktop

The Insight data gets imported and appears in a table format in Tableau.

...

Anchor
formvalidation
formvalidation
Form validation

On the click of Continue, the form is validated for the Email and API Token and the AQL syntax in sequence before importing the Insight data.

...

  • The AQL syntax is validated once the Email and API Token pass the validation check. The error message is displayed if the AQL syntax is not valid. For more information about error handling, refer to AQL syntax validation.

...

Anchor
AQL
AQL
How to use Asset Query Language syntax?

Assets Query Language (AQL) is a language format used in Assets in Jira Service Management to create search queries for one or more objects.

Basic syntax

The basic syntax of an AQL query is <attribute> <operator> <value/function>. The query returns one or more objects when the attributes of these objects match the operator and value specified.

...

Example

Query

Limit the search result to a specific object schema name.

Code Block
objectSchema = "ITSM Schema"

Limit the search result on object schema ids.

Code Block
objectSchemaId in (1, 2)

Limit the search result to a specific object type.

Code Block
objectType = "Employment Start Date"

Limit the search result on object type ids.

Code Block
objectTypeId in (1, 2)

Search all attributes on all objects for a relevant match.

Code Block
"anyAttribute = 123.123.123.123"

Limit the search to the object having any inbound references to it.

Code Block
"object having inboundReferences()"

Find an object by object Id.

Code Block
"objectId = 114"

Anchor
AQL_syntax
AQL_syntax
AQL syntax validation

The Assets app manages the AQL syntax validation and error messages.

...

Example

Query provided with invalid syntax

Error message

Limit the search result to a specific object schema name.

Code Block
objectSchema =

Limit the search result on object schema ids.

Code Block
objectSchemaId in

Limit the search result to a specific object type.

Code Block
objectType = "IT

References