@Qgil, instead of having there the backlog list, what do you think about adding a new entry to the Gerrit Backlog panel at http://korma.wmflabs.org/browser/scr-backlog.html?

Perfect!

@Qgil, is there any difference in the list of "Oldest open Gerrit changesets without code review" in http://korma.wmflabs.org/browser/scr-backlog.html if compared to what you need except that affiliation is not included.

A quick change could be to add affiliation to such table.

What do you think?

That still wouldn't help finding i.e. the changeset from Digia, or the oldest from WMDE, unless these happened to be among the 100 oldest...

I'm not sure how much the proposed approach will scale if more affiliations/companies were involved. Do we really want to click through all backlog lists of, say, 50 companies? I wouldn't.

I'd rather prefer to dynamically apply search criteria (like affiliation) on "Oldest open Gerrit changesets without code review" on scr-backlog.html. But that would trigger an entirely new search on the DB (find again those 100 oldest changesets but this time for authors with a certain affiliation). Not great.

Hence wondering if that list of "oldest open changesets" could keep its 'static' results (no new DB search) but 1) display affiliation of changeset author and 2) list way more than 100 entries (if performance won't suck)? Optionally 3) allow sorting the list by affiliation via JS.

The main use cases today are:

• We want to focus on code review of oldest patches submitted by independent / unknown volunteers. Can we have a list?
• There is this changeset from OrgX open and forgotten for a long time. Which one is it?

Work in progress. I've finally added the feature to the code at https://github.com/VizGrimoire/GrimoireLib/commit/9568489b5196fd6da4ae96d5b7d2f61a64960bed

@Lcanasdiaz will work now on the JS side to have a new entry in the backlog panel.

Guys, we deployed a simple visualization. To be honest I'm not pretty sure if it is worth to create other kind of tables as we are speeding up the launch of the new platform ..

This is what you do have for "Oldest open Gerrit changesets by organization without code review" at scr-backlog.html

Just to mention that this contains the top 10 oldest changesets per organization for all of them. We can use another limit if you prefer to have a bigger list.

After the meeting we all agreed that this seemed to be a good approach. So, we're adding this into the project to daily update the dataset.

Please, be aware that the current list of changesets for this new backlog may be a bit out of date.

How can it be that " Oldest open Gerrit changesets without code review" is from 2013 but "Oldest open Gerrit changesets by organization without code review" is from 2012?

In T113719#2071554, @Qgil wrote:

How can it be that " Oldest open Gerrit changesets without code review" is from 2013 but "Oldest open Gerrit changesets by organization without code review" is from 2012?

That was due to

In T113719#2066868, @Dicortazar wrote:

be aware that the current list of changesets for this new backlog may be a bit out of date.

and is not the case anymore on http://korma.wmflabs.org/browser/scr-backlog.html .