Skip to content

Instantly share code, notes, and snippets.

@scribu
Created April 7, 2011 01:21
Show Gist options
  • Save scribu/906872 to your computer and use it in GitHub Desktop.
Save scribu/906872 to your computer and use it in GitHub Desktop.
'price' sortable column example
<?php
// Register the column
function price_column_register( $columns ) {
$columns['price'] = __( 'Price', 'my-plugin' );
return $columns;
}
add_filter( 'manage_edit-post_columns', 'price_column_register' );
// Display the column content
function price_column_display( $column_name, $post_id ) {
if ( 'price' != $column_name )
return;
$price = get_post_meta($post_id, 'price', true);
if ( !$price )
$price = '<em>' . __( 'undefined', 'my-plugin' ) . '</em>';
echo $price;
}
add_action( 'manage_posts_custom_column', 'price_column_display', 10, 2 );
// Register the column as sortable
function price_column_register_sortable( $columns ) {
$columns['price'] = 'price';
return $columns;
}
add_filter( 'manage_edit-post_sortable_columns', 'price_column_register_sortable' );
function price_column_orderby( $vars ) {
if ( isset( $vars['orderby'] ) && 'price' == $vars['orderby'] ) {
$vars = array_merge( $vars, array(
'meta_key' => 'price',
'orderby' => 'meta_value_num'
) );
}
return $vars;
}
add_filter( 'request', 'price_column_orderby' );
@scribu
Copy link
Author

scribu commented Apr 7, 2011

@mfields
Copy link

mfields commented Apr 7, 2011

This is pretty awesome! I'll have to give it a try with my taxonomy short description plugin. You've just invalidated my argument here: http://core.trac.wordpress.org/ticket/13650 Thanks for posting :)

@Rarst
Copy link

Rarst commented Apr 18, 2012

By default first click on column name will sort ascending. I needed it to be descending first and after some poking in core that can be set by changing $columns['price'] = 'price'; to $columns['price'] = array( 'price', true );

@milanmk
Copy link

milanmk commented Jul 31, 2012

@Rarst: Thank you so much for sharing that tweak.

The request filter is applied globally so its a good practice to apply it where required:-

global $pagenow, $post_type;

if (is_admin() && $pagenow == 'edit.php' && $post_type == 'product' && isset($_GET['orderby']) && $_GET['orderby'] == 'sponsor')
{
$Request = array_merge($Request, array(
'meta_key' => 'fh_sponsor_level',
'orderby' => 'meta_value_num'
));
}

@daslicht
Copy link

daslicht commented Sep 8, 2015

Works here even without the _price_column_orderby_ function?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment