SEO Search URLs and OrderBy

Hi,

You can use the orderBy variable in the URL to sort by any field that is in the table you are returning. So for example:

listViewer.php?orderBy=title

This will order them automatically doesn't support adding ASC or DESC however. If you need further control, you can add orderBy directly to your query:
example:
list($productRecords,$productMetaData)=getRecords(array(
'tableName'=>'products',
'orderBy' => mysql_escape(@$_REQUEST['orderBy']),
'allowSearch'=>0,
));

In this example, you could add ASC or DESC to the orderBy variable.

There isn't any automatic functionality that would support the: listViewer.php/orderBy-title ASC format.

Hope this helps.

So just to be crystal clear, there isn't a way to sort records Ascending or Descending in CMSBuilder via URL.

That means I can do the following URL Query string: ?orderBy=title&direction=DESC or ?orderBy=title&direction=ASC

If we wanted to do that we'd have to code a page for each?

But we CAN sort simply by ?orderBy=title where title is the name of the field we wish to sort by.

Hi Rusty,

That post I made was actually wrong (I was young and didn't know any better).

You can set sorting direction in the url. So, in your example using title, if you wanted it ascending:
page.php?orderBy=title

For descending
page.php?orderBy=title DESC

It's important that DESC be in capitals.

Hope this helps