How to find Jira Cloud for Sheets subfields
プラットフォームについて: Cloud のみ - この記事は、 クラウド プラットフォームのアトラシアン製品にのみ適用されます。
要約
By default, subfields are not visible in Jira Cloud for Sheets. You need to follow the below steps to add them to your report.
With the extension Jira Cloud for Sheets, we can export different subfield data. Here are the steps on how to find all subfields available.
What is a subfield?
For example, we have a field "Reporter" which by default shows a display name, but if you want to retrieve the email address of the reporter then you will use the subfield "Reporter.emailAddress". The same goes for Account ID, "reporter.accountId".
ソリューション
Step 1. Open Google Sheets and navigate to "Extensions" - Jira Cloud for Sheets - Open...
Step 2. On the right side of the page "Jira Cloud for Sheets" will open and we need to click on "Get issues from Jira"
Step 3. Select "Fields" in the next screen and click on "Edit":
Step 4. The search bar will open "Filter by name or id" where you can search and check tickbox of the fields/subfields you need:
