Metadata-Version: 2.1
Name: jira-select
Version: 1.2.0
Summary: Easily export JIRA issues to CSV
Home-page: https://github.com/coddingtonbear/jira-select/
Author: Adam Coddington
Author-email: me@adamcoddington.net
License: MIT
Keywords: jira,csv
Platform: UNKNOWN
Classifier: Development Status :: 4 - Beta
Classifier: Environment :: Console
Classifier: Programming Language :: Python :: 3
Description-Content-Type: text/markdown; charset=UTF-8
Requires-Dist: rich (<4.0.0,>=3.3.2)
Requires-Dist: appdirs (<2.0.0,>=1.4.4)
Requires-Dist: keyring (<23.0.0,>=21.2.1)
Requires-Dist: jira (<3.0.0,>=2.0.0)
Requires-Dist: python-dateutil (<3.0.0,>=2.8.1)
Requires-Dist: pyyaml (<6.0.0,>=5.3.1)
Requires-Dist: simpleeval (<1.0.0,>=0.9.10)
Requires-Dist: prompt-toolkit (<4.0.0,>=3.0.5)
Requires-Dist: dotmap (<2.0.0,>=1.3.17)
Requires-Dist: typing-extensions (<4.0.0.0,>=3.7.4.2)
Requires-Dist: visidata (>=1.0.0)
Requires-Dist: pygments (<3.0.0,>=2.6.1)

![](https://github.com/coddingtonbear/jira-select/workflows/Run%20Tests/badge.svg) [![Join the chat at https://gitter.im/coddingtonbear/jira-select](https://badges.gitter.im/Join%20Chat.svg)](https://gitter.im/coddingtonbear/jira-select?utm_source=badge&utm_medium=badge&utm_campaign=pr-badge&utm_content=badge)

# Jira-Select: Get the data you want to see out of Jira

![](https://coddingtonbear-public.s3-us-west-2.amazonaws.com/github/jira-select/demo.2.gif)

Jira-select is a command-line tool and library that helps you
generate the useful insights you need out of Jira.

Jira has its own query language -- it's called JQL --
but there are many limitations in what is possible via JQL.
Some data is returned in arcane formats (e.g. sprint information),
data cannot be grouped (there's nothing like SQL's `GROUP BY` statement),
and because of that lack of grouping, there are no aggregation functions --
no `SUM`-ing story points or estimates for you,
and if you want to write a custom function for processing a field,
well, I'm not even sure where you'd begin.
Jira-select makes those things possible and easy.

If you've ever found yourself held back by the limitations of Jira's
built-in query language, this tool may make your life easier.
Using Jira-select you can perform a wide variety of SQL-like query
operations including grouping, aggregation, custom functions, and more.

## Installation

You can either install from pip:

```
pip install jira-select
```

_or_ from source:

```
git clone https://github.com/coddingtonbear/jira-select.git
cd jira-select
pip install -e .
```

## Quickstart

First, you need to configure `jira-csv` to connect to your jira instance:

```
jira-csv configure
```

Then, you can open up your shell:

```
jira-csv shell
```

Now, you can type out your query -- the below will find issues assigned
to you:

```yaml
select:
  - key
  - summary
from: issues
where:
  - assignee = "your-email@somecompany.com"
  - resolution is null
```

The editor uses `vi` bindings by default; so once you're ready to submit
your query, press `Esc` followed by `Enter` and after a short wait (watch the progressbars), you'll be shown your results. Press `q` to exit your results.

---

- Documentation for Jira-select is available on [ReadTheDocs](http://jira-select.readthedocs.org/).
- Please post issues on [Github](http://github.com/coddingtonbear/jira-select/issues).
- Questions? Ask them on [Gitter](https://gitter.im/coddingtonbear/jira-select).



