Admin countries sort by name

[sorja]

Should be sorted by list name (see data export), not country iso

[minotogna]

Should be sorted by list name (see data export), not country iso

I know. but the sorting is done server side by the query. it should reflect the future csv export as well. any suggestions/ideas ?

[sorja]

Should be sorted by list name (see data export), not country iso

I know. but the sorting is done server side by the query. it should reflect the future csv export as well. any suggestions/ideas ?

if in query, i think only possibility is to translate like we did for repositoryItems
otherwise it needs to be done in controller by user language, i think

if done in db level translations, an accordion can be shown in admin page displaying country names allowing admin to edit the translations directly

not sure if there is any other way, if we fetch paginated results

thoughts @yaguzmang @minotogna

[yaguzmang]

if in query, i think only possibility is to translate like we did for repositoryItems
otherwise it needs to be done in controller by user language, i think

if done in db level translations, an accordion can be shown in admin page displaying country names allowing admin to edit the translations directly

not sure if there is any other way, if we fetch paginated results

Just looked at how repositoryItems is handled. If we will add filtering/data-export, then handling it here the same way as for repositoryItems would be the best IMO.

The quickest and simplest now would be to filter at the controller with level with JS as Miró says, and that's feasible since there are only 256 records, but it would be inconsistent with how we handle things in other endpoints. It has the advantage though that we wouldn't have the country translations in two different places.

[minotogna]

if in query, i think only possibility is to translate like we did for repositoryItems

otherwise it needs to be done in controller by user language, i think

if done in db level translations, an accordion can be shown in admin page displaying country names allowing admin to edit the translations directly

not sure if there is any other way, if we fetch paginated results

Just looked at how repositoryItems is handled. If we will add filtering/data-export, then handling it here the same way as for repositoryItems would be the best IMO.

The quickest and simplest now would be to filter at the controller with level with JS as Miró says, and that's feasible since there are only 256 records, but it would be inconsistent with how we handle things in other endpoints. It has the advantage though that we wouldn't have the country translations in two different places.

@sorja @yaguzmang we cannot filter at controller level . The query must sort results because it is paginated , and sorting must be global .
We should put translations into db .
Or any other suggestions?
But it's a long task , and we can work on this later on .