Custom field issue on orderby in wordpress

Question

I make a custom field "term_order" in wp_terms and i make a functionality to re-order the custom taxonomy. When i drag and drop the terms it save the re-order in "term_order" field successfully, but when i write and execute the "orderby => term_order" query it does not work.

Here is my code:

<?php
     $foo_parent_ID = 0;

     $foo_args = array(
                'orderby' => 'term_order',
                'order' => 'ASC',
                'hide_empty' => false,
                'parent' => $foo_parent_ID
     );

     $foo_terms = get_terms('foo_cat', $foo_args);

     if($foo_terms){
?>
       <ul id="foo_order_sortable" class="foo_admin_order">
       <?php
            foreach($foo_terms as $foo_term) :
       ?>
            <li id="foo_parent_id_<?php echo $foo_term->term_id; ?>" class="lineitem <?php echo ($i % 2 == 0 ? 'alternate ' : ''); ?>ui-state-default">
                <?php echo $foo_term->name.' _ id='.$foo_term->term_id.' ==> order-'.$foo_term->term_order; ?>
            </li>
       <?php
             endforeach;
       ?>
       </ul>

It shows me orderby Id, where is the mistake i dont understand.

I saved it with update query.....it save successfully, but result not shown with "orderby" — deemi-D-nadeem, Jul 01 '14 at 03:40
i also try "orderby => name" its work but "orderby => term_order" not working — deemi-D-nadeem, Jul 01 '14 at 03:43
You can't use a custom field on a post as the orderby for terms. The valid values for orderby can be found here in the [codex](http://codex.wordpress.org/Function_Reference/get_terms#Possible_Arguments). — doublesharp, Jul 01 '14 at 05:15

score 0 · Accepted Answer · answered Jul 02 '14 at 11:12

Ok after many searches i found the solution.

When you make custom field in any table of the wordpress database, you just add this filter:

add_filter('get_terms_orderby', 'function name', 10, 2);

Here is my Solution:

function foo_tax_order($orderby, $args){

    $kbe_tax = "foo_cat";

    if($args['orderby'] == 'term_order'){
        return 't.term_order';
    }elseif($kbe_tax == 1 && !isset($_GET['orderby'])){
        return 't.term_order';
    }else{
        return $orderby;
    }
}
add_filter('get_terms_orderby', 'foo_tax_order', 10, 2);

Custom field issue on orderby in wordpress

1 Answers1