how to see all the tasks, more than 40 for report page, from multiple pages with a label

Question

how to see all the tasks, more than 40 for report page, from multiple pages with a label, This to have a complete report to export in excel

Kitefold · Answer

Hi Nicola, I’m afraid 40 is as high as the task report goes. The setting only offers 10, 20 or 40 per page, and the request to raise it (CONFCLOUD-41565) is still waiting for votes. If you need everything in Excel, the API Tomislav mentioned is the way to go, and you can still filter by label. First, search for the pages with your label using CQL, something like label = “your-label” and type = page, and note down their page IDs. Then ask the tasks API for the open tasks on those pages (GET /wiki/api/v2/tasks with status=incomplete and a page-id for each page). Each task comes back with its page, due date, status and assignee, ready to go into a spreadsheet. One catch is that the assignee comes back as an account ID rather than a name, so you’ll need to look each person up once.

Tomislav Tobijas · Answer

Hey @Nicola Nardone ,

I'm guessing you're referring to task report macro here. The macro supports filtering by labels , so I guess you could use that.

As for 'pagination' it does have that limit of 40 per page (max) and you cannot extend that.

Maybe for true Excel export of all site tasks, you could try using REST API. 🤔
The GET /wiki/rest/api/inlinetasks/search (v1) or GET /wiki/rest/v2/tasks (v2) endpoints allow you to programmatically retrieve all tasks, which can then be converted into a CSV or Excel file.

Cheers,
Tobi

Jean Horn · Answer

👋Hi, @Nicola Nardone !

Welcome to Atlassian Community!

Could you provide more details about what you would like to export?