Order custom posts by custom field value, exclude by date

  • Ray Gulick

    (@raygulick)


    12 years, 10 months ago

    I’ve done some research and found separate solutions for ordering custom posts by custom field value and excluding posts by date. But I cannot figure out how to do both: have tried various ways of stringing different solutions together.

    I’m trying to show events that are ordered by a custom field (order-date) that is in Y-m-d format. That part works until I add the code meant to filter out past dates (‘meta_value’ >= $today). Once that’s added, it displays unfiltered blog posts, rather than “performance” custom posts.

    Here is the code I’m currently using:

    <?php
$today = date('Y-m-d');
$paged = ( get_query_var('paged') ) ? get_query_var('paged') : 1;
query_posts((array('post_type' => 'performance',
'posts_per_page' => 5,
'caller_get_posts' => 5,
'paged' => $paged,
'meta_key' => 'order-date',
'orderby' => 'meta_value',
'order' => 'ASC'
)) && ('meta_value' >= $today));
 if (have_posts()) :
while (have_posts()) : the_post();
?>

    Obviously, the code meant to filter out past events is not working. How can I filter past events using the “order-date” custom field?

Viewing 11 replies - 1 through 11 (of 11 total)
  • Peter Hardy-vanDoorn

    (@petervandoorn)

    12 years, 10 months ago

    A quick look suggests that it might be that your 'meta_value' >= $today is actually saying “greater than or equal to today”. Try < $today (less than) or != $today (not equal to)

    Thread Starter Ray Gulick

    (@raygulick)

    12 years, 10 months ago

    Thanks, Peter. Tried your suggestion. Doesn’t matter what I use, it breaks it and shows blog posts rather than custom posts (and greater than or equal to today is what I want: displaying posts for future events).

    Here is the code I’m currently using to order the custom posts. Have tried various things to filter out past events, but not found anything that doesn’t break things in one way or another:

    <?php
	$paged = ( get_query_var('paged') ) ? get_query_var('paged') : 1;
	query_posts(array(
 		'post_type' => 'performance',
		'posts_per_page' => 5,
		'caller_get_posts' => 5,
		'paged' => $paged,
		'meta_key' => 'order-date',
		'orderby' => 'meta_value',
		'order' => 'ASC'
		));
	if (have_posts()) :
	while (have_posts()) : the_post();
?>
    Thread Starter Ray Gulick

    (@raygulick)

    12 years, 10 months ago

    Here’s the code I got on another forum. Sorts the way I need it to, but still does not filter out past performance events. Anyone see the problem?

    <?php
$paged = ( get_query_var('paged') ) ? get_query_var('paged') : 1;
query_posts(array(
'post_type' => 'performance',
'posts_per_page' => 5,
'caller_get_posts' => 5,
'paged' => $paged,
'meta_key' => 'order-date',
'orderby' => 'meta_value',
'order' => 'ASC',
'meta_query' => array(
	array(
	'key' => 'order-date',
	'value' => $value,
	'compare' => '>=',
	'type' => 'CHAR'
	)
	)
));
if (have_posts()) :
while (have_posts()) : the_post();
?>
    Thread Starter Ray Gulick

    (@raygulick)

    12 years, 10 months ago

    The above code was really close. Here’s what finally worked:

    <?php
$paged = ( get_query_var('paged') ) ? get_query_var('paged') : 1;
$today = date('Y-m-d');
query_posts(array(
	'post_type' => 'performance',
	'posts_per_page' => 5,
	'caller_get_posts' => 5,
	'paged' => $paged,
	'meta_key' => 'order-date',
	'orderby' => 'meta_value',
	'order' => 'ASC',
	     'meta_query' => array(
		array(
		'key' => 'order-date',
		'meta-value' => $value,
		'value' => $today,
		'compare' => '>=',
		'type' => 'CHAR'
		)
	)
));
if (have_posts()) :
while (have_posts()) : the_post();
?>

    Note that $today was defined, then added as a value for comparison to the meta-value from the custom field “order-date”, which was also in Y-m-d format.

    DarioDN

    (@dariodn)

    12 years, 10 months ago

    Basing on your script, how can I do to load 12 posts and paginate them in three column?

    Thread Starter Ray Gulick

    (@raygulick)

    12 years, 10 months ago

    For 12 posts per page, change these numbers to 12:
    ‘posts_per_page’ => 5,
    ‘caller_get_posts’ => 5,

    For placing the info in 3 columns, you’re going to need to dig into your CSS.

    DarioDN

    (@dariodn)

    12 years, 10 months ago

    mmm, I cannot use CSS (because the column property is supported only by recent browserd). I think can be useful use some kind of “foreach” or “for” cycle… any suggest?
    tnx

    Thread Starter Ray Gulick

    (@raygulick)

    12 years, 10 months ago

    You could create 3 separate queries with offsets that show, in turn, most recent 4, next 4, and next 4 after that (not sure how to implement that; beyond my expertise).

    DarioDN

    (@dariodn)

    12 years, 10 months ago

    I did it but it show an empty value when the post is <=$today.
    Ie:

    1 COL | 2 COL | 3 COL
    POST POST EMPTY
    POST POST POST

    I need that the last post go to the top of third column (or, if is empty is in second, the first post of 3rd goes to second post of 2nd)

    Thread Starter Ray Gulick

    (@raygulick)

    12 years, 10 months ago

    Can you provide a link to the page?

    melissaaggie98@gmail.com

    (@melissaaggie98gmailcom)

    12 years ago

    In a related topic, I was hoping that someone could lend a hand in helping me to solve a problem with a widget I’m using. I simply want to sort the posts that show up in this widget by a custom field “enddate”. But for the life of me, I can’t figure out what I need to add and where. Can someone please help?

    This is the widget’s code:

    [ Please only paste up to ten lines of code. Otherwise use pastebin ]

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Order custom posts by custom field value, exclude by date’ is closed to new replies.