Export Assets Object fields to Spreadsheets and Word
プラットフォームについて: Cloud のみ - この記事は、 クラウド プラットフォームのアトラシアン製品にのみ適用されます。
要約
When using the export options in Jira, such as Export CSV, Open in Excel, Open in Google Sheets, Export to Word, Print, and so on, Assets custom fields will be empty.
原因
- API-491Getting issue details... STATUS
- JSDCLOUD-10824Getting issue details... STATUS
- JSDCLOUD-11838Getting issue details... STATUS
ソリューション
Using Automation, it's possible to copy the value of the Assets Object custom field to another custom field so the values can be exported correctly when using any of the Export options via the Issue navigator.
手順:
- Create a Text Field (single line) or Text Field (read only) custom field and associate it with the screens.
例:
- [プロジェクトの設定] > [自動化] > [ルールを作成] に移動します。
- When: New trigger (in this example, we will be using the Scheduled trigger).
- The trigger depends on what is best for your environment. If the Assets fields are filled at the moment the ticket is created, you can use the Issue created trigger.
- You can also use Scheduled so the automation can run on specific hours or days to update the field or Field value changed in case the Assets fields are constantly updated.
- New Condition or Branch.
- This will also depend on your environment. You can add branches or conditions to better filter the tickets that will be edited.
- 新しいアクション: 課題を編集
- After selecting the field we will need to add a smart value in order to copy the Assets custom field value to the text field.
- There are two possible smart values: Using the custom field name or its ID.
{{Field Name.Name}}
{{
customfield_12345.Name}}
- There are two possible smart values: Using the custom field name or its ID.
例:
- フィールドに対応したスマート バリューを見つける
- For the Assets object custom field, it's also possible to find its ID via the Edit Assets objects field configuration.
Please, be aware of the Automation execution limit. If you use the Assets fields in multiple projects and need all of them to get updated, be aware of the limitations. For more details, refer to the documentation How is my usage calculated?