How to query a Jira Align object's Functional Area field in Enterprise Insights

Summary

How to query a Jira Align object's Functional Area field in Enterprise Insights (EI).

This article shows an example of the Feature object, but a similar approach can be taken for other relevant objects like Defects, Process Steps and many more.

Environment

Jira Align

Solution

1. A Functional Area can be created under Administration | Settings > Setup > Functional Areas

   

2. Open a Feature's details panel, locate the 'Functional Area' field and add some text.

   

3. Allow enough time for the ETL job to run and sync the data from Jira Align to Enterprise Insights

4. The sample query to the right can be run against the Enterprise Insights database to find the Functional Area field value for the Feature.

   (where <FEATURE_NAME> is the name of your Feature)

   SELECT [Functional Area], * from current_dw.Feature WHERE [Feature Name]='<FEATURE_NAME>'

5. Result