 [](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
Jira-select is a command-line tool and library that lets you run SQL-like
queries against your Jira instance that are far beyond what Jira's built-in
query language can provide.
Jira has its own query language
but there are many limitations around what JQL is capable of.
Some data is returned in arcane formats
(e.g. sprint names are returned as a string looking something like
``com.atlassian.greenhopper.service.sprint.Sprint@14b1c359[id=436...``),
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 per-assignee 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 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.
## Supported Platforms
- Linux
- Windows
- OSX
## Installation
You can either install from pip:
```
pip install jira-select
```
_or_ you can download the latest packaged release here:
https://github.com/coddingtonbear/jira-select/releases
_or_ you can build from source:
```
git clone https://github.com/coddingtonbear/jira-select.git
cd jira-select
pip install -e .
```
## Quickstart
First, you need to configure `jira-select` to connect to your jira instance:
```
jira-select configure
```
Then, you can open up your shell:
```
jira-select shell
```
Now, you can type out your query -- the below will find issues assigned
to you:
```yaml
select:
Issue Key: key
Issue Summary: 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).
Raw data
{
"_id": null,
"home_page": "https://github.com/coddingtonbear/jira-select",
"name": "jira-select",
"maintainer": null,
"docs_url": null,
"requires_python": ">=3.6",
"maintainer_email": null,
"keywords": "jira, csv, sql",
"author": "Adam Coddington",
"author_email": "me@adamcoddington.net",
"download_url": "https://files.pythonhosted.org/packages/84/86/8a2fd633cd8804ffd7d2f8f0b52269bb2141f9e921df97a608c52cad72de/jira-select-3.3.0.tar.gz",
"platform": null,
"description": " [](https://gitter.im/coddingtonbear/jira-select?utm_source=badge&utm_medium=badge&utm_campaign=pr-badge&utm_content=badge)\n\n# Jira-Select: Get the data you want to see out of Jira\n\n\n\nJira-select is a command-line tool and library that lets you run SQL-like\nqueries against your Jira instance that are far beyond what Jira's built-in\nquery language can provide.\n\nJira has its own query language\nbut there are many limitations around what JQL is capable of.\nSome data is returned in arcane formats\n(e.g. sprint names are returned as a string looking something like\n``com.atlassian.greenhopper.service.sprint.Sprint@14b1c359[id=436...``),\ndata cannot be grouped (there's nothing like SQL's `GROUP BY` statement),\nand because of that lack of grouping, there are no aggregation functions --\nno `SUM`-ing story points or estimates per-assignee for you.\nAnd if you want to write a custom function for processing a field,\nwell, I'm not even sure where you'd begin.\nJira-select makes those things easy.\n\nIf you've ever found yourself held back by the limitations of Jira's\nbuilt-in query language, this tool may make your life easier.\nUsing Jira-select you can perform a wide variety of SQL-like query\noperations including grouping, aggregation, custom functions, and more.\n\n## Supported Platforms\n\n- Linux\n- Windows\n- OSX\n\n## Installation\n\nYou can either install from pip:\n\n```\npip install jira-select\n```\n\n_or_ you can download the latest packaged release here:\n\nhttps://github.com/coddingtonbear/jira-select/releases\n\n_or_ you can build from source:\n\n```\ngit clone https://github.com/coddingtonbear/jira-select.git\ncd jira-select\npip install -e .\n```\n\n## Quickstart\n\nFirst, you need to configure `jira-select` to connect to your jira instance:\n\n```\njira-select configure\n```\n\nThen, you can open up your shell:\n\n```\njira-select shell\n```\n\nNow, you can type out your query -- the below will find issues assigned\nto you:\n\n```yaml\nselect:\n Issue Key: key\n Issue Summary: summary\nfrom: issues\nwhere:\n - assignee = \"your-email@somecompany.com\"\n - resolution is null\n```\n\nThe editor uses `vi` bindings by default; so once you're ready to submit\nyour 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.\n\n---\n\n- Documentation for Jira-select is available on [ReadTheDocs](http://jira-select.readthedocs.org/).\n- Please post issues on [Github](http://github.com/coddingtonbear/jira-select/issues).\n- Questions? Ask them on [Gitter](https://gitter.im/coddingtonbear/jira-select).\n\n\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Easily run complex SQL-like queries far beyond what Jira's standard JQL query language can provide.",
"version": "3.3.0",
"project_urls": {
"Homepage": "https://github.com/coddingtonbear/jira-select",
"Issue Tracker": "https://github.com/coddingtonbear/jira-select/issues"
},
"split_keywords": [
"jira",
" csv",
" sql"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "84868a2fd633cd8804ffd7d2f8f0b52269bb2141f9e921df97a608c52cad72de",
"md5": "32953d6dc02c4dd94a82e105366d7e03",
"sha256": "9c44538665d0d41af79cf72b231390d30de624afb8069019c58f08bca76c904d"
},
"downloads": -1,
"filename": "jira-select-3.3.0.tar.gz",
"has_sig": false,
"md5_digest": "32953d6dc02c4dd94a82e105366d7e03",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6",
"size": 72846,
"upload_time": "2024-05-14T15:39:36",
"upload_time_iso_8601": "2024-05-14T15:39:36.647698Z",
"url": "https://files.pythonhosted.org/packages/84/86/8a2fd633cd8804ffd7d2f8f0b52269bb2141f9e921df97a608c52cad72de/jira-select-3.3.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-05-14 15:39:36",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "coddingtonbear",
"github_project": "jira-select",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"requirements": [
{
"name": "rich",
"specs": [
[
"<",
"14.0"
],
[
">=",
"13.3.2"
]
]
},
{
"name": "appdirs",
"specs": [
[
">=",
"1.4.4"
],
[
"<",
"2.0.0"
]
]
},
{
"name": "keyring",
"specs": [
[
"<",
"23.0.0"
],
[
">=",
"21.2.1"
]
]
},
{
"name": "jira",
"specs": [
[
">=",
"3.2.0"
],
[
"<",
"4.0"
]
]
},
{
"name": "python-dateutil",
"specs": [
[
"<",
"3.0.0"
],
[
">=",
"2.8.1"
]
]
},
{
"name": "pyyaml",
"specs": [
[
">=",
"6.0.1"
],
[
"<",
"7.0.0"
]
]
},
{
"name": "simpleeval",
"specs": [
[
">=",
"0.9.13"
],
[
"<",
"1.0"
]
]
},
{
"name": "prompt-toolkit",
"specs": [
[
">=",
"3.0.5"
],
[
"<",
"4.0.0"
]
]
},
{
"name": "dotmap",
"specs": [
[
"<",
"2.0.0"
],
[
">=",
"1.3.17"
]
]
},
{
"name": "typing_extensions",
"specs": [
[
">=",
"4.2"
],
[
"<",
"5.0"
]
]
},
{
"name": "visidata",
"specs": [
[
">=",
"1.0.0"
]
]
},
{
"name": "pygments",
"specs": [
[
">=",
"2.6.1"
],
[
"<",
"3.0.0"
]
]
},
{
"name": "diskcache",
"specs": [
[
">=",
"4.1.0"
],
[
"<",
"5.0.0"
]
]
},
{
"name": "queryablelist",
"specs": [
[
">=",
"3.1.0"
],
[
"<",
"4.0.0"
]
]
},
{
"name": "pytz",
"specs": []
},
{
"name": "safdie",
"specs": [
[
">=",
"2.0.0"
],
[
"<",
"3.0"
]
]
},
{
"name": "pydantic",
"specs": [
[
"<",
"2.0"
],
[
">=",
"1.10.5"
]
]
},
{
"name": "portion",
"specs": [
[
">=",
"2.4.0"
],
[
"<",
"3.0"
]
]
}
],
"lcname": "jira-select"
}
JSON
