Versions Compared

Key

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

The OrgJQL plugin allows you to add organizational info adds organizational filters to your JQL queries.

Table of Contents
minLevel1
maxLevel2
outlinefalse
stylenone
typelist
printabletrue

Quick Start

This will get you up and running with OrgJQL in two minutes.

https://youtu.be/0tfasoF8V8Q

Prerequisites

You’ll need a spreadsheet with the following columns:

  • First column: Jira display names of users (you don’t need a complete org listing – just add the people that are relevant for your queries)

  • Second column: Manager display name for each user

Here’s an example:

image-20240614-170336.png

Step 1: Go to the “Update Org Data” card

image-20240614-171221.png

Click on add org data and give your data a name.

image-20240614-171334.png

Then paste your user/manager spreadsheet into the form (see Prerequisites) and click “Save”.

image-20240614-171441.png

Step 2: Test the org data by going to the “Test Org Data” tab

Click on the “Test Org Data” tab and enter a query using your org data. OrgJQL defines an orgOf JQL function that takes a manager’s name and returns a list of everyone who rolls up to them. Here’s an example query:

Code Block
assignee in orgOf("William MacLane")

Verify the expansion is correct.

image-20240614-171622.png

Step 3: Try OrgJQL in the Issue Navigator

Copy your query from Step 2 and run it in Jira’s issue navigator. Verify the results, and you’re ready to go!

image-20240614-171745.png

Step 4: Leave a review

Let us know if you run into any problems or if you’d like to request a feature by visiting the Forthix JSM Portal