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.
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
Gerda // support@eazyBI.com
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.
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".
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