Using builtin SQL navigator

Owned by Piotr Bojko
Last updated: Jan 10, 2019

After installing Smart QL you can go to Smart QL menu and choose New search. You will be presented the buitlin SQL navigator with an example query.

Navigator pane contains few sections:

  1. Menu Smart QL - here you will be able to launch navigator, view manager and other features.
  2. Editor panel - here you are able to write some queries.
  3. Result panel - a table contains results of your query. Be aware that Smart QL app presents you only data filtered by Jira permissions system.
  4. Navigator tree - tree which shows  available to you objects to make your queries. The complete list of objects may vary depending what addons you have installed or what is shared yo you.

When your query is complete - you can either hit Search button or use [crtl+enter] keyboard shortcut

If you craft invalid query - don't worry to much. Smart QL will tell you about that and point the invalid query part.

For knowing what tables, views and functions are available to build your query see Schema CORE