How would I go about setting the order of entries in a "products" channel based on the value in a price within a matrix field? So for each product, there is a matrix field with columns of regular price, sale price, sale start date, sale end date, color (an option that rarely affects price anyway). But regular price and ale price are pretty well always the same regardless of how many color options there are for the given product. What I'm looking to do is basically this:
{exp:channel:entries orderby="{matrix_field:reg_price}" sort="asc" dynamic="no"}
Any way to do something like this? Do I need to first perform a query to determine what the active price is for the items in order to sort them by this field?