I have a plugin which contains a Record. My record contains a foreign key of the related element ID. The only other column in my custom table is the value I'd like to sort by.
In Twig syntax, how can I expand on a normal Craft query to sort by a column in my custom table?
Ordinary query which sorts by my custom data:
I've done something similar to this once before... But in that case, I used the
modifyElementsQuery method in my Field Type. Since this new plugin doesn't require a field type, I'm not exactly sure of the best way to modify a standard query.