Data Retrieving App
Description
Table grid is a custom field App for Jira, which allows using database data in a tabular fashion. This Atlassian verified App lets you track milestones, releases, quotes & offers, expenses, checklists and more.
Goal
We had to create Apps for data retrieving. The necessity to attach multi-dimensional (tabular) data to an issue. The target was to make this table configurable and interactive, data to be queryable and easily summarised. This App allows you to view and edit tabular data, stored in local or external database, from within your Jira issues. You can easily manage your data from multiple systems into your custom add-on dashboard. Users can update their data directly in the external database.
Solution
It was created a custom field, which would store its data into the table in a database (rather than storing it’s value in one cell in the custom field values table in Jira database). We decided to create/update the table schema dynamically via Hibernate dynamic-map entity mode. It was added JQL functions for table value lookups to integrate with the Jira issue search. Also, it’s using robust, feature-packed JS UI (currently jqGrid).
Technology
Atlassian SDK, Javascript libraries (jQuery, jqGrid), Velocity, Hibernate, OSGi, TDD (JUnit, Mockito, Jmock).
Related apps
The app adds an estimation range to issues
The app for Confluence builds a graph of requirements’ clarity
Trello boards as sources to view, comment and track Trello cards from your Jira instance.