HughCraig / GHAP

1 stars 0 forks source link

Change Sort Order #252

Open BillPascoe opened 1 year ago

BillPascoe commented 1 year ago

Enable user to change order of records in a layer. This is important for corrections and updates to Journey Route data. A bug was recently fixed so that edits do not break the order, however there is no way for user to modify the order if they want to. The user must be able to do this through spreadsheet edits. This is important for people carefully curating records that may exist in different systems, and where there may be thousands of records, such that they can't do them one by on in UI, but could wrangle data and sort cells offline quickly. Ideally the user should also be able to do this through the user interface, for those cases where there is a small data set and this is simple and easy. But since they can do it by download and re upload spreadsheet this is optional. Don't let it hold up work if it is hard to achieve this one. The means by which a user can modify order in a downloaded and reuploaded spreadsheet could either be: a) what ever order they are in the spreadsheet that is the order they will be put in the database. b) there is a special 'sortorder' column with integers indicating the sort order. This should be forgiving, and allow gaps, but should not allow overlap. IE: a column with these integers is ok: 1,2,3,7,8,9 but this is not: 1,2,3,2,3,7,8,9 Developer can choose whichever would be most effective and manageable.

MufengNiu commented 11 months ago

To change the order of places on a layer at the layer page. Click on the 'change order' button, drag the table row to switch orders, then click on the 'Save order' button to save.