After upgrading today from 6.x-2.6 to 6.x-2.7 I saw that some of my views (actually the ones I created first with Views 2 and Drupal 6 - some time during this last summer) wasn't sorted as specified by "Sort criteria" (and in the shown "Query" text box there was no ORDER BY clause). The sorting is done on one CCK field. I am not 100% sure that it just happened after this upgrade, I have also upgraded CCK today or it can have happened some time before. Emptying the cache didn't help. I am using Drupal 6.14.

Anyway, I "solved" the issue by just changing "Basic settings > Style" from "Table" to "HTML List" and then directly back to "Table" again: the view's "Sort criteria" was now respected (with an ORDER BY clause in "Query" as expected). Is this a bug or just a "thing" that can happen under certain circumstances?

Comments

xqbzzr’s picture

xqbzzr commented

I am having a similar issue. I use a view on "fields" which does not respect the "grouping" by taxonomy term. This only occurs in "unformated" or "html-list"-style. When changing the style to "table" the grouping and sorting works fine.

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Closed (duplicate)

Please search first: http://drupal.org/node/622602