I would like to export all the information of the SCRUM or KANBAN tables, such as the name of the table, the type, the last update ...
How should I do it ?
Your use of the word "table" suggests you are thinking in terms of database access, which is the worst possible way to get any data out of Jira. The Scrum and Kanban board data is scattered through the AO tables for the application, and most of it is further located in Jira's Core issue and field tables.
A database query to "export all the information in a Scrum board" would be hundreds of painful joins.
So, rather than try to give you a terrible way to get part of what you've asked and leave you to struggle through the rest, I'd ask you to take a step back.
What are you actually trying to achieve here? Forget "export" or "tables" - what is the question the users are asking?
I have to export tables this information:
- table name
- table type
- Administrators
- creation date
- update date
That's not really an explanation of "why" you want this. Plus, your users can simply log in and see the list you are seeing which contains most of the data you are asking for already.
It's missing creation date because that is not logged. I'm not sure by "update date" you mean "config change" (also, not logged) or "last change to an issue the board includes", which is something you'd have to extract quite painfully (read board filter, parse it and then look for the most recently updated issue returned) The REST API is likely to be an easier way to get that.
i need this information like an administrator, this informations is not about users and i need to export in excel.
Do you have a solution ?
You can get the list of the boards via the Jira REST API, see this topic.
And you can execute REST API calls and transform the resulted JSON to Excel using the Better Excel Plugin. It requires very little programming, see the REST API recipes.
It looks like you're new here. Sign in or register to get started.
