Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Referenced object in jira insight - access from database

Hi! Could you please help me to access  the referenced object from jira insight, using sql query to the jira database?  I have checked list of object attribute values and didn’t find the answer. I need to find the objects that are referenced to the parent object but not display in the jira issue. 

2 answers

Hi @Anna Lewandowska 

If you want to create reporting for Insight data then app eazyBI for Jira might be something for you to explore without writing your own SQL queries. 

In eazyBI, Insight Asset Management data can be imported into eazyBI in two ways: Insight data structure as a separate data source or part of the Jira data source as Insight custom fields, you can read more here: https://docs.eazybi.com/eazybi/data-import/data-from-jira-apps/insight-asset-management

 

best,
Gerda // support@eazyBI.com

Hi! Thanks for the info. I still hope to find the table in the database where the referenced object is stored, without using other tools 😉

Like Gerda Zandersone likes this
0 votes

Welcome to the Community!

You should step away from the database, it's the single worst possible way to ask Jira to report anything.  It is complex, convoluted, unintuitive, and you can even cripple your performance when running a "simple" question.

The data you are looking for are smeared across a few tables with AO starting their names.  It will take a lot longer to explain, test and prove what you can get than if you were to look in the UI or read Insight's REST API docs to get it in a way that might change on every release.

Thanks for the info. I know that it is not recommended to use the database, although if you know what table the data is in, could you please tell me? I found object attributes in AO_8542F1_IFJ_OBJ_ATTR_VAL but the referenced object ID didn’t return expected value. 

I have no idea what table it might be in, or even tables.  I have never bothered to learn the structure of the insight tables, because I would never try to use the database for reporting.  The fact you're not getting the expected value screams "don't read the database, you don't know what it is doing".

Like Anna Lewandowska likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you