Quick Start

https://youtu.be/0tfasoF8V8Q

Step 1: Create a spreadsheet of the users and managers you want to include

If you don’t have any headings, the first column will be treated as the users and the second column their managers.

If you do use headings, the user heading must be user and the manager heading must be manager. Here’s an example Google Spreadsheet:

Step 2: Click on Update Org Data and add org data

Click on the “Update Org Data” card

Then click on the “Add Org Data” button:

Copy your spreadsheet data and paste into the editor and click “Save”

Step 3: Test your data

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:

assignee in orgOf("William MacLane")

Verify the expansion is correct.