Might be possible. I vaguely remember that the Provider supports sorting for related entities based on the field names on SQLAlchemy (but not non Mongo). The root of the feature is implemented at https://github.com/TurboGears/sprox/blob/master/sprox/sa/provider.py#L536-L560
If you are willing to experiment with what happens when that check is removed I'm open to merging any pull request that might be required to get rid of that limitation. On Tue, Oct 30, 2018 at 9:28 PM Dax Mitchell <dax.j.mitch...@gmail.com> wrote: > We are using CrudRestControllerConfig and EasyCrudRestController to do our > UI, including tabular representation of the underlying SQLite tables (via > SQLAlchemy). > > We have a table with a foreign key relationship, e.g., Movies table with > Genre column pointing at the Genres table. > > Is there a way to enable sorting of the foreign key column (e.g., sort on > 'Genre' on the Movies data grid)? > > It looks like these get skipped at the following point in the code > <https://github.com/TurboGears/tgext.crud/blob/master/tgext/crud/utils.py#L76>. > Perhaps there's a way to override this behavior? > > I would be grateful for any suggestions on how to enable sorting on such > columns in the TurboGears or Sprox frameworks. > > -- > You received this message because you are subscribed to the Google Groups > "TurboGears" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to turbogears+unsubscr...@googlegroups.com. > To post to this group, send email to turbogears@googlegroups.com. > Visit this group at https://groups.google.com/group/turbogears. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "TurboGears" group. To unsubscribe from this group and stop receiving emails from it, send an email to turbogears+unsubscr...@googlegroups.com. To post to this group, send email to turbogears@googlegroups.com. Visit this group at https://groups.google.com/group/turbogears. For more options, visit https://groups.google.com/d/optout.