Atlassian Query Tool
πππAtlassian Query Tool is a NodeJS application for fetching data from JIRA to excel
Installation
Use the package manager npm to get started with a Slack Slash Command.
npm install atlassianQueryTool
Usage
We set up our application by adding the below code:
var searchString="project='okrs' and ((createdDate<='2025/11/1' and createdDate>='2025/3/1') or (updatedDate <='2025/11/1' and updatedDate >='2025/3/1')) "
jira.searchJira(searchString).then(function(issue) {
var fields = ['ISSUE_Number', 'TITLE', 'STATUS'];
var myISSUE=[];
for(let i=0; i<issue.total ;i++ ) {
myISSUE.push(
{
"ISSUE_Number":issue.issues[i].key,
"TITLE": issue.issues[i].fields.status.name,
"STATUS": issue.issues[i].fields.summary,
}
)
};
var csv = json2csv({ data: myISSUE});
fs.writeFile('file.csv', csv, function(err) {
if (err) throw err;
console.log('file saved');
});
})
.catch(function(err) {
console.error(err);
}
);
Built With π οΈ
- NodeJS - a JavaScript runtime built on Chrome's V8 JavaScript engine. Version 12.16.1 LTS
- Express - Dependency Management. Default package manager for the JS runtime environment Node.js
- NPM - Dependency Management. Default package manager for the JS runtime environment Node.js
- Atlassian API - a proprietary issue tracking product developed by Atlassian that allows bug tracking and agile project management API
- fs - module provides a lot of very useful functionality to access and interact with the file system.
- Node-Cron - A simple cron-like job scheduler for Node.js
- Jasmine - A behavior-driven development framework for testing JavaScript code.
- Nodemon - A utility that will monitor for any changes in your source and automatically restart your server. Perfect for development. Install it using npm.[devDependency]
- [ES6/ES7](http://es6-features.org/#Constants | https://developer.mozilla.org/en-US/docs/Archive/Web/JavaScript/ECMAScript_Next_support_in_Mozilla#ECMAScript_2017) - ECMAScript Next refers to new features of the ECMA-262 standard (commonly referred to as JavaScript) introduced after ECMAScript 2015. New versions of ECMAScript specifications are released yearly.
Contributing π
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
Please make sure to update tests as appropriate.
Authors π
- Jake Westerfield - Primary Work