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
Comment #1
esmerel commentedCan 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.
Comment #2
esmerel commentedAlso, is this a table style? Because there's a checkbox for table sorting to override normal sorting.
Comment #3
marynz commentedthanks 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
Comment #4
gweiner commentedThanks this helped a lot with the views module default sorting error in Drupal 6. (Needed to add some keywords to this).
Comment #5
esmerel commentedThere's no reason to add tags for things that are already part of the issue submission criteria.