Referenced object in jira insight - access from database

[Anna Lewandowska]

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. 

[Gerda Grantiņa]

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

[Anna Lewandowska]

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 😉

[Nic Brough -Adaptavist-]

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.

[Anna Lewandowska]

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. 

[Nic Brough -Adaptavist-]

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".

[Nadim Dakora]

Hello @Anna Lewandowska , 

Were you able to find any solution ? 

[Anna Lewandowska]

Hi @Nadim Dakora! Yes, I think so :) I recently needed this for slightly different purpose, but if you are looking for referenced object in Jira Insight, you can test this code: