Creating a list of posts ordered by the values present in a custom field

  • rpOliveira

    (@rpoliveira)


    14 years, 4 months ago

    Hello, good community!

    I have spent some time reading and searching but I still didn’t find a way to solve this problem.

    For each post I have custom-fields with numeric values. I would like a way to create a page with a list of posts ordered (in ascending or descending order) by the value of that custom-field.

    I found this plugin http://www.christianschenk.org/projects/wordpress-list-posts-custom-field-plugin/ that makes the list but doesn’t have (yet) the ability to order the posts by the value in the custom-field (just by date, title,..)

    There must be a way to do this because I find it very useful to present a list of the posts of a blog ordered by rating, for instance.

    In my blog (it’s a movie quiz – http://www.iknowthatmovie.com) I have three numeric values for each post:

    1) classification of the quiz’s difficulty as voted by users
    2) number of users who have seen that film
    3) time to solve the quiz (in minutes)

    I would like to create pages with a list of posts oredered by these numeric values.

    Can anyone help me?

Viewing 11 replies - 1 through 11 (of 11 total)
  • gerbilk

    (@gerbilk)

    14 years, 4 months ago

    how about doing it client side with jquery? then you could change between the 3 ranking options.

    Thread Starter rpOliveira

    (@rpoliveira)

    14 years, 4 months ago

    I don’t have programming skills to do that and I don’t understand what you mean.

    I was hoping someone knew some plugin or piece of code that could do this. I think it’s useful and must be a common problem (to make a list of the posts ordered by ratings, for instance).

    gerbilk

    (@gerbilk)

    14 years, 4 months ago

    something like this
    query_posts('meta_key=$yourkey&orderby=meta_value_number&order=DESC');

    look here http://codex.wordpress.org/Template_Tags/query_posts

    and here http://wordpress.org/support/topic/277454?replies=6

    Thread Starter rpOliveira

    (@rpoliveira)

    14 years, 4 months ago

    Hi! Thanks for your answer. I didn’t know query_posts and tested it and it will be useful, for sure.

    However, that’s not what I intended. I wanted a page with a list of the posts ordered by a numeric value (a text list with the titles of the posts). I want to create a new page that contains the post list, like this one: list made with the plugin.

    That plugin seems great but can’t order the posts by a numeric value in a custom-field.

    I’m finding odd that nobody hasn’t made this before 🙂 It must be there somewhere.

    gerbilk

    (@gerbilk)

    14 years, 4 months ago

    the orderby=meta_value_number should order the posts by their numeric custom field value, or did you mean something different?

    Thread Starter rpOliveira

    (@rpoliveira)

    14 years, 4 months ago

    I meant a page that has a text list of all my posts.

    Example:

    Ordered posts by ratings;

    1. Post Title 37 – 5.0
    2. Post Title 32 – 4.8
    3. Post Title whatever – 4.6
    4. Post Title hello – 4.5
    5. Post Title title – 4.1
    …

    I don’t want to alter the loop to display my posts by any kind of order. I want a page that is a list of links to my posts (ordered by some value). Each link has the text of the post title and points to it.

    gerbilk

    (@gerbilk)

    14 years, 4 months ago

    the idea is to use the loop (which you can have on any page using a custom page template and query_posts), use the query_posts I posted earlier with the key for your ratings, ordered by the value of the key, then inside the loop use something like

    <h2><a href="<?php the_permalink(); ?>"><?php the_title(); ?></a> - <?php $key="mykey"; echo get_post_meta($post->ID, $key, true); ?></h2>

    Thread Starter rpOliveira

    (@rpoliveira)

    14 years, 2 months ago

    So I can have another page with the loop and order the posts with query_post. But how can I create that page properly?

    Here is what I did: I went to my theme folder. I copied the index.php and created another file called order.php. The only difference in order.php is that I use query-posts to sort them in a different way. Now I have the order.php file in my theme folder. How to access it? How can I make a link in other pages to that file in order to present the sorted posts?

    I’m not seeing the whole picture here.

    Thanks.

    gerbilk

    (@gerbilk)

    14 years, 2 months ago

    cool, one tiny step left

    http://www.wordpressmax.com/customize-wordpress/custom-page

    Thread Starter rpOliveira

    (@rpoliveira)

    14 years, 1 month ago

    Well, finally I got some time to take a look at this.

    Thanks a lot for your tips. I was able to do exactly what I wanted with your help – two lists of posts ordered by a numerical value.

    Here is the one ordered by the classification of the posts:

    http://www.iknowthatmovie.com/quizzes-list-by-difficulty/

    Here is the one ordered by the number of views of each post:

    http://www.iknowthatmovie.com/quizzes-list-by-views/

    I also used thumbnails in the lists.

    Thanks for your help.

    gerbilk

    (@gerbilk)

    14 years, 1 month ago

    no worries! site looks good.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Creating a list of posts ordered by the values present in a custom field’ is closed to new replies.