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).