You can’t use a linked table column for sorting.
If you are completely consuming the iterator, that is if you are using all the rows returned by the search, then you can sort them in memory with the sorted
python function.
Using the sorted
function with the standard tables could be slow, because it will trigger a round trip to the database server per linked row, while with the accelerated tables it should be very fast, because you can cache all the linked fields during the search
.