function wp_admin_meta_dropdown() { global $wpdb; $meta_dropdown = ''; $meta_keys = $wpdb->get_col("SELECT DISTINCT meta_key FROM $wpdb->postmeta WHERE SUBSTRING(meta_key,1,1) != '_'" ); if( !empty($meta_keys) ) { $sortkey = ( isset($_GET['meta_key']) ) ? attribute_escape($_GET['meta_key']) : ''; $meta_dropdown .= ''; } echo $meta_dropdown; return; } function admin_pre_filter($query) { global $pagenow; if( $query->is_admin && ('edit.php' == $pagenow) ) { $metakey = (isset($_GET['meta_key']) && $_GET['meta_key'] !== 'All') ? attribute_escape($_GET['meta_key']) : ''; if('' != $metakey) { $query->set('orderby','meta_value'); $query->set('order','ASC'); $query->set('meta_key',$metakey); } } return $query; } add_filter('pre_get_posts', 'admin_pre_filter'); add_action('restrict_manage_posts', 'wp_admin_meta_dropdown',2);