Enhancing the sector sync table to display sectors with their last sync attempt state != finished

[gdower]

Prior to doing a release, it is important to know if any sector in the project has their last sync in any other state than finished. The current sector sync view shows all sector sync statuses and it is difficult to determine which sectors ended in an unsuccessful state without searching for each GSD in the interface to see the full history of sector sync statuses.

Filtering on cancelled or failed doesn't really tell you if the last sector sync state was successful:

https://www.checklistbank.org/catalogue/3/sector/sync?limit=25&offset=0&state=canceled&state=failed

And adding the state finished shows too much irrelevant info for the use case of needing to know which sectors did not sync successfully:

https://www.checklistbank.org/catalogue/3/sector/sync?limit=25&offset=0&state=finished&state=canceled&state=failed

Perhaps this could be done with a "Needs review" checkbox that would configure the sector sync view to show only the last sector sync status for each sector and filter to sector sync statuses that are any other value than finished. This might need a backend API parameter (something like onlyLastSyncAttempt=true) on the /dataset/{key}/sector endpoint.

Here's a mock-up of the proposed view:

Ultimately, I think it might also be useful to have a release page that shows the bare minimum of information on things to be aware of before releasing. It shouldn't block a release but it would be useful to know number of broken sectors, number of broken decisions, number of sectors with syncs that ended in a non-finished state with links to the tools to fix those issues.