TDV Adapter for JIRA

Build 21.0.8137

Filters

Query the set up Filters in JIRA. This table is not available in JIRA Server.

Table Specific Information

Select

The adapter uses the JIRA API to process some of the filters.

The adapter processes other filters within the adapter.

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.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137