DF_Model Ordering
Done:
- Removed "order" as a default column to sort on, as it’s not a standard column we have in all tables
- Added a get_published_order method to add table name on each order column so queries don't result in an ambiguous error when a fetch includes a join
- Improved the order_by method to handle "COALESCE" orders
- Removed duplicate order code within the get_where method in favour for the order_by method
Testing:
- Login as an admin and navigate to the accounts screen
- Confirm the sort and search works correctly