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

License 🔬

MIT