Step by Step Guide: DataBase Explorer (Data Center)
Accessing the Database Terminal Screen:
To query the Jira database using Database Explorer, follow these steps:
Navigate to the Jira Administration screen.
Click on the settings wheel icon located at the top right corner.
From the drop-down menu, select "Manage apps."
In the "Manage apps" screen, locate the "Menu DATABASE BROWSER" section in the left-hand column.
Click on the "Database Terminal" option to access the Database Terminal screen.
Â
New Full Screen Functionality:
Maximize space by clicking arrows next to the "Database Terminal" title and main action buttons. Arrows hide the left column and table filtering/listing, leaving a clean query view.
Â
Performing a Search:
In the Database Terminal screen:
Filter and view your database table by keyword.
Click on a result to view its main data (such as ID, PKEY, ISSUENUM, PROJECT, and more) in a convenient drop-down.
Use the button options in the main menu for different actions:
Execute Query: Execute SQL and view paginated results.
Recent Queries: Access the 10 latest executed queries.
Copy Result: Copy data table to your clipboard.
Export to CSV: Export filtered table to CSV format.
Save Query: Save queries for future use.
Â
Importing Data from a CSV File:
For instructions on importing data from a CSV file into your Jira Data Center instance, visit the Atlassian Support page: Import Data from a CSV File.
This resource provides detailed guidance on seamlessly integrating external data into your Jira environment.
Saving Queries:
After executing a query:
Save queries using the "Save query" feature.
Provide a query name and optional description.
Save definitively by clicking "Confirm."
Navigating to Saved Query List:
Navigate to "Saved Query List" below the Database Terminal option in the "Menu DATABASE BROWSER" section.
Use powerful search and filtering engine to find the list you need.
Sharing Queries:
In the "Saved Query List" section, go to the "Actions" column.
Click on the users' icon (called "Share with" option) to share queries with users and groups.
Specify the groups and/or users and click "Share" to finalize sharing.
This functionality enables Administrators to query databases and share results with non-Administrator users.
Enhancing Collaboration with Shared Queries:
Accessing Shared Queries Overview:
Navigate to the Jira main menu.
Click on the "DBTerminal" option.
Then, click on the "Shared queries" dropdown.
Viewing Shared Queries:
Non-admin Jira users can access the "Shared Queries" screen if queries are shared with them.
They can filter shared queries by Name and Description.
Shared Queries List:
Below the filter tab, you'll find the SHARED QUERIES LIST.
This section displays information such as Name, Description and Shared by.
Each shared query includes a "Run" option for execution.
Note: Results from executed queries are displayed on a separate screen with pagination. Additionally, users have options to Copy Result and Export to CSV.
Â
Â
Â