Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt
hiddentrue

As soon as have completed the plugin installation and adapt 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 ...

Image Added

Apps


Section
Column

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.

Image Added

Image Added

Column

Image Added

Section

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

Column

Image Added

Expand

Image Added

Column

Image Added

Expand

Image Added


Image Added


Image Added


Section
Column


Column