Like ira42‘s post above says, I too would like to sort the results on the template by one of the columns. I can think of two ways this could be done (totally riffing here, so I might be crazy):
1. In the entry in the control panel by dragging the rows up and down (yay asynchronous Javascript) which I’m sure would be a significant rewrite.
2. On the template level - maybe with the query module, or adding a new output parameter like:
<ul>
{members col_1="available" sortcol="col_2" sortorder="desc"}
<li><strong>{col_1}</strong>: {col_2}</li>
{/members}
</ul>
I’d then assume that the above would grab every line where {col_1} equals “available” and then sort them by {col_2}, descending.
I guess a significant problem would arise if one was trying to sort by numbers (in my real-life working-on-it-right-now case that would be square footage). I’m not sure how these fields are stored in the database but it’s some form of text I would guess.
I’d almost prefer the “drag to sort” method in the Control Panel, myself.
Any tips or tricks welcome, and I’ll post something here if I figure out anything interesting!