Sort Criteria not used in Drupal View

I was having trouble with the Drupal Views module. I have a view of a CCK Node, and I wanted to sort the view by one of the CCK data fields. The view was sorting on node id by default.

Adding the CCK content field to the “Sort Criteria” gave no change in the SQL query. I struggled with this for a good hour before deciding to create my view from scratch.

Once I recreated the view, I found that sorting by columns is handled in the table style settings. The not correctly sorted view was using the table style; I went back to my original view’s table settings and was able to sort by other columns by default.

This entry was posted in Computing and tagged , , . Bookmark the permalink.

7 Responses to Sort Criteria not used in Drupal View

  1. Rob says:

    I could kiss you. Seriously. Been pulling my hair out for too long.

  2. Well, I won’t kiss you, but thanks for posting this, solved a vexing problem (constantly changing the sort criteria and seeing no change in the ORDER BY clause).

  3. Paolo says:

    I definitely want kiss you. Thanks!!!

  4. jimethn says:

    This was exactly the problem, thank you!

  5. jimethn says:

    *smooch*

  6. Thanks yaar, for the solution. By views we can control everything but some time we forgot about the setting part.

  7. Christoph says:

    Thank you, thank you, thank you.
    This was driving me crazy and I would never have thought of looking in the table settings…

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>