back2source: Report on many d2d projects at once

[pombredanne]

I would like to report on many projects at once.

Given a bunch of "map_deploy_to_devel" projects that share a tag or name pattern, I would like to create a consolidated report across all the projects that will list the issues and problem that need attention in the d2d runs of these projects.

The exact details are exactly these:

• foremost "TODO requires review" status https://staging.scancode.io/project/test-ruby-devise-b32614ad/resources/?status=requires-review
• possibly later the "Not mapped" "To" files https://staging.scancode.io/project/test-ruby-devise-b32614ad/resources/?tag=to&relation_map_type=none

I would like to:

• Filter projects that have a given pipeline/labels
• Select these projects to run a report Add a TODOs sheet containing on REQUIRES_REVIEW resources in XLSX #1524 #1527

I would like this XLSX report would contain these columns:

• the project name
• the resource columns from a UI list filtered with resources/?status=requires-review

Later on we could refine that to look like this:
https://github.com/aboutcode-org/back2source-data/blob/main/d2d-summary.csv
but generic