Filters
Query the set up Filters in Jira. This table is not available in Jira Server.
Table Specific Information
Select
The connector uses the Jira API to process some of the filters.
The connector processes other filters within the connector.
Retrieve all filters:
SELECT * FROM Filters
By specifying the Id of a certain filter:
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. |