Identify all automation rules configured for a specific Jira DC project
プラットフォームについて: Data Center のみ。 - This article only applies to Atlassian apps on the Data Center プラットフォーム。
この KB は Data Center バージョンの製品用に作成されています。Data Center 固有ではない機能の Data Center KB は、製品のサーバー バージョンでも動作する可能性はありますが、テストは行われていません。 Server* 製品のサポートは 2024 年 2 月 15 日に終了しました。Server 製品を実行している場合は、 アトラシアン Server サポート終了 のお知らせにアクセスして、移行オプションを確認してください。
*Fisheye および Crucible は除く
要約
In Automation for Jira, automation rules can be configured to run only in specific projects.
In some instances, it may be helpful to identify all rules configured to run in a particular project, be it for audit purposes or to facilitate administration. This article provides options on how to do just that.
➕ You may also be interested in searching for Automation Rules executed by a specific actor.
ℹ️ We currently have the following feature request to improve A4J's automation search functionality JIRAAUTOSERVER-1109. If this topic interests you, be sure to vote and watch the feature to be informed about future updates.
環境
Any version of Jira Data Center, Jira Software, or Jira Service Management, with Automation for Jira bundled or installed as a user-installed app.
ソリューション
The Automation search in Jira only allows administrators to search by rule names; therefore, the only workaround available is to search the Jira database.
Option A: Search based on the desired project key
The query below was designed for Postgres database syntax, but it should work for different databases with little to no adjustment.
Database query:
SELECT rc."NAME" AS "Rule Name", rc."STATE", pj.pname AS "Project Name", pj.pkey AS "Project Key"
FROM "AO_589059_RULE_CFG_PROJ_ASSOC" rcpa
JOIN project pj ON rcpa."PROJECT_ID" = CAST(pj.id as varchar)
JOIN "AO_589059_RULE_CONFIG" rc ON rcpa."RULE_CONFIG_ID" = rc."ID"
WHERE pj.pkey = 'ProjectKey';ℹ️ To use this query, change ProjectKey with the actual project key for the project you want to search for.
Option B: Search all automation rules with the entire project association
The query below was designed for Postgres database syntax, but it should work for different databases with little to no adjustment.
Database query:
SELECT rc."NAME" AS "Rule Name", rc."STATE", pj.pname AS "Project Name", pj.pkey AS "Project Key"
FROM "AO_589059_RULE_CFG_PROJ_ASSOC" rcpa
JOIN project pj ON rcpa."PROJECT_ID" = CAST(pj.id as varchar)
JOIN "AO_589059_RULE_CONFIG" rc ON rcpa."RULE_CONFIG_ID" = rc."ID"
WHERE pj.pkey in (select pkey from project);この内容はお役に立ちましたか?