Hello

Im trying to sort using Date asc, but changing the sort criteria for the page view does not change or update the query. I have it working fine as a block, but for some reason the page display is still sorting using Node Title
with sort criteria showing "none defined" i am still getting the following query:

SELECT node.nid AS nid,
   node.title AS node_title,
   node.type AS node_type,
   node_revisions.body AS node_revisions_body,
   node_revisions.format AS node_revisions_format
 FROM node node 
 LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
 WHERE (node.type in ('live_streams')) AND (node.status <> 0)
   ORDER BY node_title DESC

view has been saved, changed , re-saved, the default has been changed, overriding default, using default, changing sort criteria altogether, clearing Views' cache, nothing seems to get alter the query being produced. I can change the block sort criteria, and the query updates correctly, but the page sort criteria seems to be stuck on node_title DESC

Does anyone have any ideas on how i can fix this?

thanks
Mary

Comments

esmerel’s picture

Can you export and attach a copy of the view? Maybe something obvious will stick out, or it's something we can import and see in the UI that's acting up.

esmerel’s picture

Also, is this a table style? Because there's a checkbox for table sorting to override normal sorting.

marynz’s picture

Status: Active » Fixed

thanks so much @esmerel, it was that checkbox. :)

I thought it must be something terribly simple but just couldnt figure it out. hae spent the last 3 hrs trying to though!

For anyone else - the check box is in the settings of the Table style

gweiner’s picture

Thanks this helped a lot with the views module default sorting error in Drupal 6. (Needed to add some keywords to this).

esmerel’s picture

There's no reason to add tags for things that are already part of the issue submission criteria.

Status: Fixed » Closed (fixed)
Issue tags: -page display, -sort criteria

Automatically closed -- issue fixed for 2 weeks with no activity.