Filters

Displays saved filters created by users to retrieve specific issue sets. Not available in Jira Server deployments.

Table Specific Information

The component uses the Jira API to process some of the filters.

The component processes other filters within the component.

Retrieve all filters:

SELECT * FROM Filters

By specifying the Id of a certain filter:

SELECT * FROM Filters WHERE Id = 10001


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.