[Idea] Display columns in column-order as they are sorted in the source data.frame

[shahronak47]

Using the same example as available in the README (file.show(app)) . The app looks like this

Notice that the column in the dropdown has the order height, is_droid, mass but the order that we pass in choices is choices = c("height", "mass", "is_droid"). The column in the dropdown sorts the name and follows an alphabetical order ignoring the order that is passed in choices.

Can this be fixed to make the columns in the dropdown and choices consistent? Similarly, when no value of choices is passed meaning all the columns are part of filter I would expect the column order in dropdown same as that present in table.

[dgkf]

Thanks for the suggestion @shahronak47. I think the sorting happens automatically because they match free text (handled by the selectize dropdown). For tied matches, it defaults to alphabetical.

Although I can why it might be preferred to handle sorting yourself (especially when there's no text yet entered into the free-text search), I think this might be unintuitive when you start to enter search text and you might expect results to be sorted somehow.

I'm not confident that this is always best, so I think I'd prefer to leave it as-is for now. I'll leave this open to collect other input to learn whether this is broadly seen as a preferred UI.