Easily export JIRA issues to CSV
Project description
Jira-Select: Easily export issues from Jira to CSV
Quickstart
First, you need to configure jira-csv
to connect to your jira instance:
jira-csv configure
Then, you'll need to create a yaml file describing your query and save it somewhere; example:
select:
- key
- summary
- timetracking.originalEstimate as "Hours Estimate"
- customfield_10048 as "My Important Field"
from: issues
where:
- labels = "frontend"
- assignee = "me@adamcoddington.net"
- resolution is null
Now you can run your query:
jira-csv run /path/to/query.yaml
& it'll hand you back a CSV document with the fields you've selected.
See the built-in help (--help
) for more options.
Advanced Usage
Functions
You can define and use functions for both formatting selected data and filtering rows returned from Jira.
Formatting rows
select:
- status
- summary
- customfield_10069 as "Story Points"
- array_len(customfield_10010) as "Sprint Count"
- sprint_name(array_item(customfield_10010, -1)) as "Sprint Name"
from: issues
In the above example, two of the displayed columns are processed with a function:
Sprint Count
: Will render the number of array elements in the field containing the list of sprints in which this issue was present.Sprint Name
: Will show the name of the last sprint associated with the displayed issue.
Omitting rows
select:
- status as "Status"
- summary as "Summary"
- customfield_10069 as "Story Points"
from: issues
having:
- '"Sprint #19" in coalesce(sprint_name(array_item(customfield_10010, -1)), "")'
In the above example, the issues returned from Jira will be compared against
each constraint you've entered in the having
section; in this case, all
returned issues not having the string "Sprint #19" in the name of the last
sprint associated with the displayed issue will not be written to your output.
Future Goals
- SQlite support: Instead of exporting a CSV, exporting an SQLite database.
- XLSX support: Instead of exporting a CSV, exporing an XLSX document.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for jira_select-1.0.0.0b1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 6ff81fa4b822672ca21cf141401ccb702a162479ae0c3430842f11b76860a0fd |
|
MD5 | 8f7ad2c8bd87fafe96c20302a1870a58 |
|
BLAKE2b-256 | ba0c2ec29e9a16b706b272790937c625d4858e31edaf98b5be583f8ccb0a9663 |