Export Table

[Julien NATAF]

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 ?

[Aron Gombas _Midori_]

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.

[Nic Brough -Adaptavist-]

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?

[Julien NATAF]

I have to export tables this information:

- table name

- table type

- Administrators

- creation date

- update date

[Nic Brough -Adaptavist-]

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.

[Julien NATAF]

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 ?

[Nic Brough -Adaptavist-]

The easiest one is for the users to read the screen for themselves.  They don't have to be admins to see it.

If you have to export it, you're going to find scraping the list from the page you've got is the most simple option.

[Julien NATAF]

I am Jira administrator and work on Jira support within my company, this information I need to recover in an excel file, they do not concern users.

I need to follow the advanced tables.

If i can have it without creation date and update date, it's ok.

Thank you !

[Julien NATAF]

please, I need to export informations in red in an excel file.

Thank you

[Nic Brough -Adaptavist-]

Again, your best option is to scrape that screen.  Or get the the people asking for this to look at "manage boards" for themselves.

[Julien NATAF]

What do you mean by to scrape that screen ?

[Nic Brough -Adaptavist-]

While on the screen, press ctrl-s to save the html, or select the table with the cursor and copy and paste it somewhere.