As soon as have completed the plugin installation and adapted some of its settings (if needed), you can write and execute your first SQL Statements.

To help you in these activity,  Alkaes Database Client for Jira has implemented :

  • A Table Segmentation per Apps,
  • Some filtering capacity (Autocomplete) on tables list,
  • Two column selectors : one for SELECT Clause, the second for WHERE Clause
  • and a SQL History

Overview of DB Client

When accessing the DB Client page, you will see 3 fields ...

Apps


In Apps Select Box will help you to filter Tables per Apps ...

You see listed different entries :

  • Core (Core) will filter all Tables issued from Jira Core
  • AO Plugins (AO_) will filter all Tables issued from all plugins with Active Objects
  • One entries for each plugin with Active Objects : Plugin Name (AO_123456_)  .


You will also able to perform some filtering by entering a part of plugin name.

Depending on the retained filtering on Apps Select Box, you will see in Tables Select Box only Tables of selected Apps.