Filters
Query the set up Filters in Jira. This table is not available in Jira Server.
テーブル固有の情報
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 Id of the filter. | |
| Name | String | Cloud | The name assigned to the filter. | ||
| JQLExpression | String | Cloud | The JQL by which the filter will search issues by. | ||
| Description | String | Cloud | The description given to the filter. | ||
| OwnerDisplayName | String | = | Cloud | The board Id the sprint originated from. | |
| Favourite | Boolean | Cloud | Whether you have set this filter as a favourite. | ||
| FavouritedCount | Integer | Cloud | How many users have this filter as a favourite. | ||
| SubscriptionsAggregate | String | Cloud | Collection of user subscriptions to the filter . | ||
| SharePermissionsAggregate | String | Cloud | Aggregate of share permissions to the filter. |