I use this in one of my templates to sort by expiration:
<?php
$the_query = new WP_Query(array(
'orderby' => 'meta_value',
'meta_key' => '_expiration-date',
'posts_per_page' => -10,
'order' => 'ASC'
));
?>
<?php if ( $the_query->have_posts() ) : ?>
<?php while ( $the_query->have_posts() ) : $the_query->the_post(); ?>
<!-- Do Something -->
<?php endwhile; wp_reset_postdata(); ?>
<?php else : ?>
<!-- Do Something -->
<?php endif; ?>
You may be able to use the is_admin() in a function to work in the admin.
Thread Starter
Martín
(@caparros07)
Thank you. But where i should paste that code?
I was able to get the following to work. Try inserting the code in your theme’s functions.php file:
/* Sort posts by expiration */
function sort_query_order( $query ) {
if ( is_admin() && $query->is_main_query() ) {
$query->set( 'meta_key','_expiration-date' );
$query->set( 'orderby','meta_value_num' );
$query->set( 'order', 'ASC' );
}
return $query;
}
add_action( 'pre_get_posts', 'sort_query_order' );
Thread Starter
Martín
(@caparros07)
It worked!! Thank you very much!
This is for plugin´s developers. If there was a pro version to allow sort by expire date, i´d be a customer. This solution works perfect, but hide the products without an expire date and blocks other ways to be ordered. Anywise, Semrocc thank you forever, i don´t have to check every single product any more before they expire.
Regards
Hi semrocc,
I put your code in functions.php in my child theme and it has no effect. The plugin is great but I still haven’t found a way to reliably sort by the expiration date.
/* Sort posts by expiration */
function sort_query_order( $query ) {
if ( is_admin() && $query->is_main_query() ) {
$query->set( ‘meta_key’,’_expiration-date’ );
$query->set( ‘orderby’,’meta_value_num’ );
$query->set( ‘order’, ‘ASC’ );
}
return $query;
}
add_action( ‘pre_get_posts’, ‘sort_query_order’ );
Thats strange…
Delete the code from your functions file and do the following:
1. Create a plugin by inserting the following code into an empty php file (save it as “sort-posts-by-expiration.php”).
2. Upload the file to your plugins folder, activate it and see what happens.
<?php
/*
Plugin Name: Sort Posts by Expiration
Description: Sort admin posts by expiration date.
Author: Tom Herod
Version: 1.0
Author URI: http://savvyjock.com/
*/
function sort_query_order( $query ) {
if ( is_admin() && $query->is_main_query() ) {
$query->set( 'meta_key','_expiration-date' );
$query->set( 'orderby','meta_value_num' );
$query->set( 'order', 'ASC' );
}
return $query;
}
add_action( 'pre_get_posts', 'sort_query_order' );
-
This reply was modified 9 years, 6 months ago by
semrocc.
-
This reply was modified 9 years, 6 months ago by semrocc.
Works great for the admin panel. Sorted like a champ.
I’m trying to get it to sort my blog posts by expiration date.
http://countdown.center
I’ll play around with it.
Sounds great 🙂
If you want the results to sort the same way on both the front and back-end of your site, try changing the following code from the plugin:
if ( is_admin() && $query->is_main_query() ) {
To:
if ( $query->is_main_query() ) {
If you want to create an archive of sorts on your front-end, see my original post..it may point you in the right direction 🙂
That did the trick! I appreciate your help semrocc. You are the man. 🙂
Hi there,
This method seems to work like a charm for my website back end.
The front end does not work when i replace (it creates an error with none of the posts appearing on the front page):
if ( is_admin() && $query->is_main_query() ) {
To:
if ( $query->is_main_query() ) {
Can you please help me out?
Also i noticed the in the images i cannot view the images in the list viewing but i can in the grid viewing. Why is this happening?
