nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Export filter output to CSV file automatically using JQL.

Haran Kumar

Hi ,

I have a filter which schedules output once in a day. I have subscribed to this filter and get notified by mail. My question is can, I get the csv file of the filter output exported directly (automatically) to my mail , by using JQL. (without using plugin)
I use Jira software cloud.

Thanks in Advance.

Accepted answers

Tom Lister_fo1j4e

there is a rest api to search for issues

https://developer.atlassian.com/server/jira/platform/jira-rest-api-examples/#searching-for-issues-examples

It returns json

maybe with a bit of scripting and a Json-formatter you could get it to work

All comments

Jack Brickey

There is t a way to do this at least OOTB. You can check for an addon in the Marketplace. For example, maybe EasyBI could do this but not sure.

Tom Lister_fo1j4e

there is a rest api to search for issues

https://developer.atlassian.com/server/jira/platform/jira-rest-api-examples/#searching-for-issues-examples

It returns json

maybe with a bit of scripting and a Json-formatter you could get it to work

Jack Brickey

yes for sure you could code something up for this.

Haran Kumar

Hi Tom,
Though I'm not a programmer , I shall look up & try to find some scripting to solve this issue. Thank you Tom , as well as Jack.

Zane eazyBI Support

Thank you @Jack Brickey for the suggestion! However, I believe, some other tool or solution would be more suitable to get JQL results on mail as CSV fail.

eazyBI is a tool for data analyzes and oriented on data usage and publishing in the application, not for data preparation for downloadable files.

On regular bases, users can receive eazyBI reports in their emails as well, but those reports are prepared in PDF format. More information on email subscription you will find in eazyBI documentation: https://docs.eazybi.com/eazybijira/publish-reports/create-dashboards#CreateDashboards-Dashboardemailsubscription

Best,
Zane / support@eazyBI.com

Aron Gombas _Midori_

You can export Jira issues from a JQL search to Excel using the Better Excel Automation for Jira app. It is super flexible, as it relies on standard Jira Cloud Automation rules to implement this automation.

As result you will receive the exported file attached to a customizable email:

(Exporting to Excel, XLSX files to be precise, is much better than the plain-text CSV format which suffers from well known problems like encoding, data has no types, and so on.)

Your automation rule:

should use the Scheduled trigger and run the CQL
should use generate the Excel spreadsheet and email that to the recipient (To, Cc, Bcc supported!)

Follow the precise step-by-step guide to implement this rule. (Video version will be published in the next few days!)

(Discl. this app is developed and supported by our team.)

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud