Filters
Displays saved filters created by users to retrieve specific issue sets. Not available in Jira Server deployments.
テーブル固有の情報
Select
connector はJira API を使用して一部のフィルタを処理します。
connector は他のフィルタをconnector 内で処理します。
すべてのフィルタを取得：
SELECT * FROM Filters
特定のフィルタのId を指定：
SELECT * FROM Filters WHERE Id = 10001
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| Id [KEY] | Integer | = | Cloud | The unique identifier of the filter used to reference it in the Jira API and user interface. | |
| Name | String | Cloud | The display name assigned to the filter for easier identification. | ||
| JQLExpression | String | Cloud | The Jira Query Language (JQL) expression that defines the filter's search criteria for issues. | ||
| Description | String | Cloud | A short explanation of what the filter does or what it is intended to find. | ||
| OwnerDisplayName | String | = | Cloud | The display name of the user who created and owns the filter. | |
| Favourite | Boolean | Cloud | If the value is 'true', the filter is marked as a favourite by the current user. | ||
| FavouritedCount | Integer | Cloud | The number of users who have marked this filter as a favourite. | ||
| SubscriptionsAggregate | String | Cloud | A list of users who are subscribed to receive notifications when the filter results change. | ||
| SharePermissionsAggregate | String | Cloud | A list of groups or users with whom the filter has been shared. |