Schema CUSTOM

This schema contains as views all custom queries saved by You. Only you have access to your own saved queries as view. Each user has separate, unique schema CUSTOM.

Your saved query are accessible either from menu of Smart QL in Jira or via this schema.

Only valid queries are visible as views in CUSTOM schema. If for some reason you query won't be valid anymore - it won't show up in CUSTOM schema as a view.

Please note, that under CUSTOM schema your views are available to call in SQL not by their names but through their names SLUG.

Examples

ActionEffect
Write a query.

Save under a name "My Last Changes".

Navigate to your custom saved views and use it by clicking to its name.

Use it in SQL