I feel like I mentioned this before, but I couldn't find it in "My Posts", so maybe not. In the Studies List (maybe elsewhere, but that's the only view I'm using) the dropdown selectbox for the order always has two copies of whichever order is currently selected - so the list of options will be either "Ascending / Ascending / Descending" or "Ascending / Descending / Descending". I'm surprised no one else has mentioned this - am I the only one seeing it this way?

I fixed this in the new version under development. It's only a partial fix - as the list won't "keep" the setting in the display, though it works functionally. It's probably an error in how I formed the html of the list - one of the things to check before we release the next version.

I just noticed that even if I change that selectbox to "- Select an Order -", it is still ordered descending by date. That got me thinking... Is that ordering always based on the date, and never any other field (like title, or teacher, or whatever)? In my layout I'm not showing the headers - maybe if I was I would be able to answer my own question about how it works. But anyway, if it's always sorted by date, then I may just drop the selectbox from my layout (once I figure out how I can change my layout now that I've messed myself up - see my other current thread - I can't change any parameters at the moment ), because the chance of someone wishing they could sort by ascending date is low compared to the improvement in simplicity of having less selectboxes to intimidate non-techy users.

Yes - the Descending/Ascending is by studydate. The idea was to filter according to whatever criteria the user wanted, then sort by date.

The query ends up: ORDER BY studydate ASC (or DESC)

Okay, thanks.