Forum OpenACS Q&A: Re: How can i order the list by alphabetical order?

Posted by Enrique Catalan on
If I'm not wrong you should do:

1. In the ad_page_contract header add the variable orderby, something like this (orderby:optional)

2. Then add the switch -orderby to your list::create like:
-orderby {
title {n.title asc}

3. Finally, in your 'select' query, after 'where n.revision_id = ci.live_revision' add this: [template::list::orderby_clause -name notes -orderby]

At least, something to start with =).

You might find useful to take a look of some examples in .../packages/acs-templating/www/doc/list*