nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

All comments

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

Gerda Grantiņa _ eazyBI

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 😉

Nadim Dakora

Hello @Anna Lewandowska ,

Were you able to find any solution ?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

insight

database