Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Insight tables within Jira SQL

Sanja Vukovic
Sanja Vukovic February 22, 2018

I created object schema in Insight and now would like to acess tables that are created in SQL. I have read acess to whole Jira DB, but after careful observation, I can't find them. How can I find my tables that are created when I created my object schema and started importing objects? In which schema and what is naming convention?

Thank you

Answer
Watch
Like Be the first to like this
4654 views

1 answer

4 votes
Alexander Sundström
Alexander Sundström
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
February 26, 2018

Hi Sanja,

All tables in Insight are prefixed with AO_8542F1_IFJ, we are using more than one to store the values for the objects, but perhaps what would be most interesting is

  • AO_8542F1_IFJ_OBJ_SCHEMA
  • AO_8542F1_IFJ_OBJ
  • AO_8542F1_IFJ_OBJ_ATTR_VAL

Best Regards
Alexander

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events