Some fields not present in JIRA Database

[Deleted user]

Hi 

I imported my JIRA Database into our BI tool. It showed the JIRA tables (Issues & Projects) and a lot of fields including several custom fields created. But others such as (Organization, Security Level and Clients) were missing.

Please advise on

1. What in the way the fields are created/their properties stops it from being the database.

2. How do I construct/modify an existing field so it appears in the database and consequently on my BI tool. In this case i'm using AWS Quicksight.

Thank you

John

[Nic Brough -Adaptavist- · Accepted solution]

What do you mean by "Imported database"?

If, by that, you mean yo took a copy of the database, then what export and transform did you use?  You've said you are on Cloud Jira, where you have no access to the database, so we'll need to know what you actually did.

However, whatever the answer to that is, you have run straight into one of the reasons I will always tell people to not read a Jira database for reporting - it's not built for it, you really need to know exactly what it is doing (so you can find stuff like the things you're looking for) and there are some things that are not in the database so you won't be able to get them anyway.

I would stop trying to read the database and use the REST API instead, or get one of the apps that can expose the data for you.