Utilizzando wp_query è possibile ordinare per tassonomia?

No,non èpossibile ordinarepertassonomia,perché da un certotipo dipunto di vista,in realtànon hamolto senso.

Letassonomie sonomodiper raggruppare le coseinsieme. Quindiilpunto di avere unatassonomia suipost sarebbe davvero avereterminiin quellatassonomia condivisitrai post. Se unatassonomia avessetermini che sono stati usati solo su unpost ciascuno,allora latassonomia sarebbeinutile. E sei terminifossero condivisi come dovrebberoessere,ordinarliin base a questinonprodurrebbenulla diparticolarmente utile.

Quello che dovresti usarein una situazione delgenere èilmetapost. Puoi ordinarepermetaposted è unicoper ognipost.

Modifica: Detto questo,puoi ordinarein base allatassonomia creando una query SQLpersonalizzata utilizzando unfiltro,semplicementenonpuoifarlo da un WP_Querynonmodificato: http://scribu.net/wordpress/sortable-taxonomy-columns.html

Tuttavia,se devi ricorrere a questogenere di cose,la struttura diprogettazione dei dati è sbagliatain primo luogo. I "termini"nellatassonomianon sono "dati"effettivi. Itermini stessinon hanno alcun significatointrinseco,sono soloetichetteperilparticolare raggruppamento che stanno descrivendo. Se litratti come dati significativi,allora hai un difetto diprogettazione sottostante.

Letassonomie raggruppano le cose assegnando loro deitermini. Quel raggruppamento èilpunto centrale delletassonomie,i termini sono solo deibei voltinel raggruppamento. Se haimetadati significativi da assegnare a unpost,dovrestiinvece utilizzareilmetapost. E che puoi ordinare,perchépostmeta utilizza sia chiavi che valoripermemorizzare leinformazioni. Con unatassonomia,in realtàmemorizzi solo le chiavi,i cui valori sonoi post raggruppatiin base a queltermine.

Le cose sonopiùfacili a lungotermine se usi l'approccio correttoper questo. Anche senon sto dicendo chenonpuoifare qualcosa di strano con latassonomia,stai solo rendendo le cosepiù difficiliperte stesso a lungotermine usandolain modo sbagliato.

No, it is not possible to order by taxonomy, because from a certain type of standpoint, that doesn't actually make much sense.

Taxonomies are ways to group things together. So the point of having a taxonomy on posts would really be to have terms in that taxonomy that are shared between posts. If a taxonomy had terms that were only used on one post each, then that would make the taxonomy kind of pointless. And if the terms were shared like they should be, then ordering by it wouldn't produce anything particularly useful.

What you should be using in such a situation is the post meta. You can order by post meta, and it's unique to each post.

Edit: That said, you can order by taxonomy by making a custom SQL query using a filter, you just can't do it from a unmodified WP_Query: http://scribu.net/wordpress/sortable-taxonomy-columns.html

However, if you're having to resort to doing this sort of thing, then your data design structure is wrong in the first place. "Terms" in the taxonomy are not actual "data". The terms themselves have no inherent meaning, they're just labels for the particular grouping that they're describing. If you're treating them as meaningful data, then you have an underlying design flaw.

Taxonomies group things by assigning terms to them. That grouping is the whole point of taxonomies, the terms are just pretty faces on the grouping. If you have meaningful metadata to assign to a post, then you should be using the post meta for it instead. And that you can order by, because post meta uses both keys and values to store information. With a taxonomy, you're really only storing keys, with their values being the posts grouped together by that term.

Things are easier in the long run if you use the correct approach for it. While I'm not saying that you can't do something strange with taxonomy, you're just making things harder for yourself in the long run by using it wrong.

La risposta accettataper questa domanda èinaccettabile. Èillogicopresumere che l'ordinamentofiscale "non abbia senso". La risposta che ha datonon ha senso.

Considera l'idea di avere untipo dimessaggio dimenu. Quindi hai unatassa doganale di "FoodCategories". Latassa FoodCategoriesprevedetermini "Colazione","Pranzo"e "Cena". Seinvii una query utilizzandoilparametrotax_query,ora hai un set di risultati contuttii termini,tuttavia sono ordinatiper data dipubblicazione.

Per ottenere l'ordine corretto da questi,in relazione ai lorotermini,e quindi visualizzare sulfront-endin modo appropriato separandoi postnelle loro varie categorie,devi scorrereil set di risultati,quindiinterrogare ogniindividuopubblicare all'interno del set di risultatipertrovarei terminie confrontarli coniltermine corrente,filtrarein un arraye continuarepertutto. Quindi devi dinuovo scorrereilnuovo arrayper la visualizzazione. Questonon èproduttivo.

Sarebbebello se WP avesse un'opzione orderby "tax__in" comefa una "post__in",mapoichénon lofa,devieseguireil ridicoloprocesso di cui sopra;personalizzatu stesso la querytramiteilfiltro "posts_orderby"e "posts_join"permodificareilmetodo orderbye aggiungereiltermine al set di risultati,rispettivamente; oppure devifare unanuova queryper ognitermine che staifiltrando all'interno delle sezioni html relative a queitermini.

La soluzionepiùefficiente sarebbemodificare la stringa di querytramitefiltri. Ilmodopiù semplice sarebbeeseguiretre query separate. L'API WP dovrebbegestiregli ordiniin base alletasse o qualsiasiparametro di query restrittivo. Se stai limitando una queryin base a determinate condizioni,c'è un'altaprobabilità chemolti avrannobisogno di ordinarein base a quelle stesse condizioni.

The accepted answer for this question is unacceptable. It is illogical to assume that ordering by tax "doesn't make sense". The answer he gave doesn't make sense.

Consider having a menu post type. Then you have a custom tax of "FoodCategories". The FoodCategories tax has "Breakfast", "Lunch" and "Dinner" terms. If you submit a query utilizing the tax_query param, you now have a result set with all of the terms, however they are ordered by post date.

In order to get the correct order out of these, relative to their terms, and then to display on the front end appropriately by separating the posts into their various categories, you have to loop through the result set, then query each individual post within the result set to find it's terms and compare to the current term, filter into an array and continue throughout. Then you have to again loop through the new array for display. This is not productive.

It would be nice if WP had a "tax__in" orderby option as it does a "post__in" one, but since it does not, you either have to do the above ridiculous process; customize the query yourself by way of 'posts_orderby' filter and 'posts_join' filter in order to adjust the orderby method and add the term to the result set, respectively; or you have to make a new query for each term you are filtering for within the html sections relative to those terms.

The most efficient would be to change the query string by way of filters. The easiest would be to do three separate queries. The WP API should be handling ordering by tax, or any restrictive query parameters. If you are restricting a query based on certain conditions, there is a high probability that many will have need to order by those same conditions.

Sì,ma èpiuttosto complicato ...

Aggiungi afunctions.phpneltuotema:

 function orderby_tax_clauses( $clauses, $wp_query ) {
    global $wpdb;
    $taxonomies = get_taxonomies();
    foreach ($taxonomies as $taxonomy) {
        if ( isset( $wp_query->query['orderby'] ) && $taxonomy == $wp_query->query['orderby'] ) {
            $clauses['join'] .=<<<SQL
LEFT OUTER JOIN {$wpdb->term_relationships} ON {$wpdb->posts}.ID={$wpdb->term_relationships}.object_id
LEFT OUTER JOIN {$wpdb->term_taxonomy} USING (term_taxonomy_id)
LEFT OUTER JOIN {$wpdb->terms} USING (term_id)
SQL;
            $clauses['where'] .= " AND (taxonomy = '{$taxonomy}' OR taxonomy IS NULL)";
            $clauses['groupby'] = "object_id";
            $clauses['orderby'] = "GROUP_CONCAT({$wpdb->terms}.name ORDER BY name ASC) ";
            $clauses['orderby'] .= ( 'ASC' == strtoupper( $wp_query->get('order') ) ) ? 'ASC' : 'DESC';
        }
    }
    return $clauses;
}

    add_filter('posts_clauses', 'orderby_tax_clauses', 10, 2 );
 

Questo èfranco da alcune cosetrovatee da cose che hofattoio stesso. Spiegare èpiuttosto difficile,ma la conclusione è che con questofunzionamento,puoimettere? Orderby=(query ditassonomia var) & amp; order=ASC (o DESC)e lei sene andrà subito!

Yes, but it is pretty involved...

Add to functions.php in your theme:

function orderby_tax_clauses( $clauses, $wp_query ) {
    global $wpdb;
    $taxonomies = get_taxonomies();
    foreach ($taxonomies as $taxonomy) {
        if ( isset( $wp_query->query['orderby'] ) && $taxonomy == $wp_query->query['orderby'] ) {
            $clauses['join'] .=<<<SQL
LEFT OUTER JOIN {$wpdb->term_relationships} ON {$wpdb->posts}.ID={$wpdb->term_relationships}.object_id
LEFT OUTER JOIN {$wpdb->term_taxonomy} USING (term_taxonomy_id)
LEFT OUTER JOIN {$wpdb->terms} USING (term_id)
SQL;
            $clauses['where'] .= " AND (taxonomy = '{$taxonomy}' OR taxonomy IS NULL)";
            $clauses['groupby'] = "object_id";
            $clauses['orderby'] = "GROUP_CONCAT({$wpdb->terms}.name ORDER BY name ASC) ";
            $clauses['orderby'] .= ( 'ASC' == strtoupper( $wp_query->get('order') ) ) ? 'ASC' : 'DESC';
        }
    }
    return $clauses;
}

    add_filter('posts_clauses', 'orderby_tax_clauses', 10, 2 );

This is frankensteined from some found stuff and some stuff I did myself. Explaining is pretty tough, but the bottom line is with this running, you may put ?orderby=(taxonomy query var)&order=ASC (or DESC) and she'll take right off!

Arrivotardi algioco qui,maesiste unmodopiù semplicee WordPressyperfarlo.

Crea latua queryfiscale come al solito.

 $tax_query = array();
$tax_query['relation']="OR";
$tax_query[] = array(
    'taxonomy' => 'product_cat',
    'field'    => 'slug',
    'terms'    => $cat_terms,
);
$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
 

Impostai tuoi argomentiper query_posts o WP_Query

 $args = array(
    'post_type'=>'post',
    'posts_per_page'=>12,
    'paged'=>$paged,
    'tax_query' => $tax_query,
);
 

Prima dieffettuare la chiamata query_posts/WP_Query,agganciati alfiltro orderbye sovrascriverlo

 add_filter('posts_orderby', 'edit_posts_orderby');
function edit_posts_orderby($orderby_statement) {
    $orderby_statement = " term_taxonomy_id ASC ";
    return $orderby_statement;
}
query_posts($args);
remove_filter('posts_orderby', 'edit_posts_orderby');
 

non dimenticare di rimuovereilfiltroin seguito ...

questofunzionab/ctax_query creai joinecc.perte,devi solo ordinarein base a uno dei campi daljoin.

I'm coming late to the game here, but there is a simpler more WordPressy way of doing this.

Build out your tax query like normal.

$tax_query = array();
$tax_query['relation']="OR";
$tax_query[] = array(
    'taxonomy' => 'product_cat',
    'field'    => 'slug',
    'terms'    => $cat_terms,
);
$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;

Set up your args for query_posts or WP_Query

$args = array(
    'post_type'=>'post',
    'posts_per_page'=>12,
    'paged'=>$paged,
    'tax_query' => $tax_query,
);

Before you make your query_posts / WP_Query call, hook into the orderby filter and override it

add_filter('posts_orderby', 'edit_posts_orderby');
function edit_posts_orderby($orderby_statement) {
    $orderby_statement = " term_taxonomy_id ASC ";
    return $orderby_statement;
}
query_posts($args);
remove_filter('posts_orderby', 'edit_posts_orderby');

don't forget to remove filter afterwards...

this works b/c the tax_query creates the joins etc for you, you just need to order by one of the fields from the join.

Non sono sicuro delmotivoper cuitutte le soluzioni qui lo stianoesagerando.OK,èmezzo decenniofa,ma attualmente sto soloeseguendoil seguente codicee funziona:

    <?php // Default
    $wheels_args = array(
        'post_type' => 'wheels',
        'posts_per_page' => '96',
        'orderby' => 'taxonomy, name', // Just enter 2 parameters here, seprated by comma
        'order'=>'ASC'
    );
    $loop = new WP_Query($wheels_args);
    ?>
 

Questo ordinerà letassonomie deltuo CPTprimain base alla suatassonomiain ordine alfabeticoe all'interno di questigruppi ditassonomia anchein ordine alfabetico.

I'm not sure why all solutions here are pretty much overkilling it. OK, it's half a decade ago, but I'm just running the following code currently and it works:

   <?php // Default
    $wheels_args = array(
        'post_type' => 'wheels',
        'posts_per_page' => '96',
        'orderby' => 'taxonomy, name', // Just enter 2 parameters here, seprated by comma
        'order'=>'ASC'
    );
    $loop = new WP_Query($wheels_args);
    ?>

This will sort the taxonomies of your CPT first by it's taxonomy in alphabetical order and within these taxonomy groups als by alphabetical order.

Bene,vorreiesporre lamiaesperienzanell'ordinamento ditipi dipostpersonalizzatiper categoria/tassonomia.

IL WEB

1. Sito web di un'agenzia di viaggiin esecuzione su WordPress
2. Contenutoprincipale sultipo dipostpersonalizzato chiamato "ruta"
3. Tassonomia con questa struttura Tipo di viaggio> continente>paese

IL CASO

Nellepagine dell'elenco delle categorie di archivio,il cliente desiderava ordinarei postin base a

1. Il continente,ordinatopernumero di rotte su ciascuna diesse.
2. Ilpaese,in ordine alfabetico.

I PASSAGGI

Innanzitutto ,prendo la richiesta dalla query dellapagina di archiviononmodificata che è risultataessere così:

 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID 
FROM wp_posts 
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) 
WHERE 1=1 
AND ( wp_term_relationships.term_taxonomy_id IN (5,6,7,8,9,10,11,12,13,15,16,17,18,19,20,21,22,23,25,26,28,29,31,32,33,35,38,95,101,102,193) )
AND wp_posts.post_type IN ('ruta', 'nav_menu_item') 
AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 45 
AND wp_posts.post_status = 'private') 
GROUP BY wp_posts.ID 
ORDER BY wp_posts.post_date DESC LIMIT 0, 20
 

Secondo ,homodificatoil codice sqlin Sequel Pro rispetto al databaseper soddisfare lemie esigenze. Esco con questo (sì,probabilmentepuòesseremigliorato:ilmio conoscenza su MySQLnon èeccezionale):

 SELECT SQL_CALC_FOUND_ROWS wp_posts.ID, tt1.parent AS pare,
    (
    SELECT COUNT(*) 
    FROM  wp_posts
    INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
    INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id =      wp_term_relationships.term_taxonomy_id )
    INNER JOIN wp_term_taxonomy AS tt2 ON ( tt2.term_taxonomy_id =  tt1.term_taxonomy_id )
    WHERE 1=1  
    AND tt1.parent = pare
    ) AS Total
FROM  wp_posts
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id =      wp_term_relationships.term_taxonomy_id )
INNER JOIN wp_terms ON ( tt1.term_id = wp_terms.term_id )
WHERE 1=1  
AND ( wp_term_relationships.term_taxonomy_id IN (5,6,7,8,9,10,11,12,13,15,16,17,18,19,20,21,22,23,25,26,28,29,31,32,33,35,38,95,101,102,193) ) 
AND wp_posts.post_type IN ('ruta', 'nav_menu_item') 
AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 45 
AND wp_posts.post_status = 'private') 
GROUP BY wp_posts.ID 
ORDER BY
total DESC,
wp_terms.name  
 

Terzo ,ho agganciato la query alfilefunctions.php contrefiltri:posts_fields,posts_joine posts_orderby

Il codicein functions.php:

 function xc_query_fields( $fields ) {

   $fields = "wp_posts.ID, wp_posts.post_title, wp_terms.name, tt1.parent AS pare,
    (
    SELECT COUNT(*) 
    FROM  wp_posts
    INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
    INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id = wp_term_relationships.term_taxonomy_id )
    INNER JOIN wp_term_taxonomy AS tt2 ON ( tt2.term_taxonomy_id = tt1.term_taxonomy_id )
    WHERE 1=1  
    AND tt1.parent = pare
    )
    AS Total";
     return $fields;
}


function xc_query_joins( $join ) {
$join .= "INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
   INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id = wp_term_relationships.term_taxonomy_id )
   INNER JOIN wp_terms ON ( tt1.term_id = wp_terms.term_id )";
 return $join;
}


function xc_query_orderby( $join ) {
    $join = "total DESC, wp_terms.name ";
    return $join;
 }
 

Infine ho attivatoi filtri dall'hookpre_get_postin base ad alcune condizioni

 function filtra_queries( $query )
{

  if (  is_archive()  && $query->is_main_query() && !is_admin()  ) {

$rutes = array('viajes-privados', 'asia', 'africa', 'oceania', 'america', 'oriente-proximo');

if  ( in_array( $query->get('category_name'), $rutes ) ) 
  {
  add_filter( 'posts_fields', 'xc_query_fields' );
  add_filter( 'posts_join', 'xc_query_joins' );
  add_filter( 'posts_orderby', 'xc_query_orderby' );
}// end if in_array

  }// end if is_archive

}
 add_filter('pre_get_posts', 'filtra_queries');
 

Spero che questopossa aiutare qualcuno

Well, I’d like to expose my experience in sorting custom post types by category/taxonomy.

THE WEB

1. A travel agency web site running on WordPress
2. Main content on custom post type called ‘ruta’
3. Taxonomy with this structure Type-of-travel > continent >country

THE CASE

In archive category list pages, the client wanted the posts to be sorted by

1. The continent, ordered by number of routes on each one.
2. The country, ordered alphabetically.

THE STEPS

First, I catch the request from the unmodified archive page query which happened to be like this:

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID 
FROM wp_posts 
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) 
WHERE 1=1 
AND ( wp_term_relationships.term_taxonomy_id IN (5,6,7,8,9,10,11,12,13,15,16,17,18,19,20,21,22,23,25,26,28,29,31,32,33,35,38,95,101,102,193) )
AND wp_posts.post_type IN ('ruta', 'nav_menu_item') 
AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 45 
AND wp_posts.post_status = 'private') 
GROUP BY wp_posts.ID 
ORDER BY wp_posts.post_date DESC LIMIT 0, 20

Second, I edited the sql code in Sequel Pro against the database to conform my needs. I come out with this (yes, probably it can be improved: my knowledge on MySQL is not outstanding):

SELECT SQL_CALC_FOUND_ROWS wp_posts.ID, tt1.parent AS pare,
    (
    SELECT COUNT(*) 
    FROM  wp_posts
    INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
    INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id =      wp_term_relationships.term_taxonomy_id )
    INNER JOIN wp_term_taxonomy AS tt2 ON ( tt2.term_taxonomy_id =  tt1.term_taxonomy_id )
    WHERE 1=1  
    AND tt1.parent = pare
    ) AS Total
FROM  wp_posts
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id =      wp_term_relationships.term_taxonomy_id )
INNER JOIN wp_terms ON ( tt1.term_id = wp_terms.term_id )
WHERE 1=1  
AND ( wp_term_relationships.term_taxonomy_id IN (5,6,7,8,9,10,11,12,13,15,16,17,18,19,20,21,22,23,25,26,28,29,31,32,33,35,38,95,101,102,193) ) 
AND wp_posts.post_type IN ('ruta', 'nav_menu_item') 
AND (wp_posts.post_status = 'publish' OR wp_posts.post_author = 45 
AND wp_posts.post_status = 'private') 
GROUP BY wp_posts.ID 
ORDER BY
total DESC,
wp_terms.name  

Third, I hooked the query on the functions.php file with three filters: posts_fields, posts_join and posts_orderby

The code in functions.php:

function xc_query_fields( $fields ) {

   $fields = "wp_posts.ID, wp_posts.post_title, wp_terms.name, tt1.parent AS pare,
    (
    SELECT COUNT(*) 
    FROM  wp_posts
    INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
    INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id = wp_term_relationships.term_taxonomy_id )
    INNER JOIN wp_term_taxonomy AS tt2 ON ( tt2.term_taxonomy_id = tt1.term_taxonomy_id )
    WHERE 1=1  
    AND tt1.parent = pare
    )
    AS Total";
     return $fields;
}


function xc_query_joins( $join ) {
$join .= "INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
   INNER JOIN wp_term_taxonomy AS tt1 ON ( tt1.term_taxonomy_id = wp_term_relationships.term_taxonomy_id )
   INNER JOIN wp_terms ON ( tt1.term_id = wp_terms.term_id )";
 return $join;
}


function xc_query_orderby( $join ) {
    $join = "total DESC, wp_terms.name ";
    return $join;
 }

Finally I triggered the filters from the pre_get_post hook according to some conditions

function filtra_queries( $query )
{

  if (  is_archive()  && $query->is_main_query() && !is_admin()  ) {

$rutes = array('viajes-privados', 'asia', 'africa', 'oceania', 'america', 'oriente-proximo');

if  ( in_array( $query->get('category_name'), $rutes ) ) 
  {
  add_filter( 'posts_fields', 'xc_query_fields' );
  add_filter( 'posts_join', 'xc_query_joins' );
  add_filter( 'posts_orderby', 'xc_query_orderby' );
}// end if in_array

  }// end if is_archive

}
 add_filter('pre_get_posts', 'filtra_queries');

Hope this can help somebody

Ho avuto unproblemamolto simile che ho affrontato: voglio ordinare un archivio dipost-typepersonalizzato (articoli di riviste)in base a unatassonomiapersonalizzata (problemi). Noneseguomai query SQL dirette sulmio sitoe di solito se sei come queste altre risposte devi ripensare altuo approccio.

PROBLEMI:

1) Wordpressnon consente di ordinaretassonomiein modointelligente.

2) Wordpress semplicementenon consente a orderby di utilizzaretassonomie su WP_Query ditipopost (come spiegato da Otto).

SOLUZIONI:

1) L'ordinamento delletassonomie si ottiene almeglio con Plug-in Custom Taxonomy Order NE almomento. Tipermette di ordinare latassonomiatramite WYSIWYGin wp-admin chenon è come lofareiiomanon hotrovatoniente dimeglio.

Quando configuriilplugin,otterrai qualcosa di simile a quello che hofatto qui. Prendinota dell'opzione Auto-sort Queries of this Taxonomy -impostala su Custom Order as Defined Above; questoti dà l'ordine di cui haibisogno. Screenshot:

2) Con unatassonomia ordinatain atto,è orapossibile creare una serie di chiamate WP_Query che attraversano ognitermine,creandoeffettivamente un archivio ordinato dallatassonomia. Utilizza get_terms()per creare un array dituttii terminifiscali,quindiesegui un foreach su ciascuntermine. Questo crea un WP_Queryper ognielemento deltermine che restituiràtuttii postper un datotermine,creandoeffettivamente un archivio ordinatopertermine dellatassonomia. Codiceperfarlo accadere:

   // Get your terms and put them into an array
  $issue_terms = get_terms([
    'taxonomy' => 'issues',
    'hide_empty' => false,
  ]);

  // Run foreach over each term to setup query and display for posts
  foreach ($issue_terms as $issue_term) {
    $the_query = new WP_Query( array(
      'post_type' => 'post',
      'tax_query' => array(
        array(
          'taxonomy' => 'issues',
          'field' => 'slug',
          'terms' => array( $issue_term->slug ),
          'operator' => 'IN'
        )
      )
    ) );

    // Run loop over each query
    while($the_query->have_posts()) :
      $the_query->the_post();

      // YOUR TEMPLATE OUTPUT FOR EACH POST

    endwhile;
  }
 

Letture correlate su questo sito: Visualizzatuttii postin untipo dipostpersonalizzato,raggruppatoin base a unatassonomiapersonalizzata

I had a very similar problem that I dealt with: I want to order a custom post-type archive (magazine articles) by a custom taxonomy (issues). I never do direct SQL queries on my site - and usually if you are like these other answers - you need to rethink your approach.

PROBLEMS:

1) Wordpress doesn't allow you to order taxonomies in any intelligent way.

2) Wordpress just doesn't allow orderby to be use taxonomies on post-type WP_Query (as spelled out by Otto).

SOLUTIONS:

1) Sorting taxonomies is best accomplished by the Custom Taxonomy Order NE plugin at the moment. It allows you to order the taxonomy via WYSIWYG in wp-admin which isn't how I would do it but I haven't found anything better.

When you setup the plugin, you'll get something similar to what I've done here. Make note of the option Auto-sort Queries of this Taxonomy - set this to Custom Order as Defined Above; this gets you the ordering you need. Screenshot:

2) With a sorted taxonomy in place, you can now create a series of WP_Query calls that run through each term, effectively creating an archive ordered by the taxonomy. Use get_terms() to create an array of all tax terms, then run a foreach over each term. This creates a WP_Query for each term item that will return all posts for a given term, effectively creating an archive ordered by taxonomy term. Code to make this happen:

  // Get your terms and put them into an array
  $issue_terms = get_terms([
    'taxonomy' => 'issues',
    'hide_empty' => false,
  ]);

  // Run foreach over each term to setup query and display for posts
  foreach ($issue_terms as $issue_term) {
    $the_query = new WP_Query( array(
      'post_type' => 'post',
      'tax_query' => array(
        array(
          'taxonomy' => 'issues',
          'field' => 'slug',
          'terms' => array( $issue_term->slug ),
          'operator' => 'IN'
        )
      )
    ) );

    // Run loop over each query
    while($the_query->have_posts()) :
      $the_query->the_post();

      // YOUR TEMPLATE OUTPUT FOR EACH POST

    endwhile;
  }

Related reading on this site: Display all posts in a custom post type, grouped by a custom taxonomy

Ecco la soluzione che ho usatoper questoparticolareproblema. Questa soluzione èper casiestremiin cuinon èpossibile utilizzare unfiltro pre_get_postsed èpresente unapaginazioneesistente sulla query (adesempio: WooCommerce):

 global $wpdb;

$taxonomies = array('my-tax-1', 'my-tax-2', 'my-tax-3');

$orderby = "'".implode("', '", array_keys($taxonomies))."'";
$id_sql = $GLOBALS['wp_query']->request;

$id_sql = preg_replace('/LIMIT\s+\d+\s?,?\s\d*/', '', $id_sql);
$id_sql = str_replace('SQL_CALC_FOUND_ROWS', '', $id_sql);

$term_sql = "SELECT
  tt.taxonomy AS `taxonomy`,
  t.name AS `term_name`,
  t.slug AS `term_slug`,
  count(*) AS `term_count`
FROM ({$id_sql}) p 
JOIN wp_term_relationships tr
  ON p.ID = tr.object_id
JOIN wp_term_taxonomy tt
  ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN wp_terms t
  ON tt.term_id = t.term_id
WHERE tt.taxonomy IN ({$orderby})
GROUP BY t.slug
ORDER BY
  FIELD(tt.taxonomy, {$orderby})"; // Add further specific ordering here

$results = $wpdb->get_results($term_sql, ARRAY_A);
 

L'ho usatoper creare unmenu dinavigazione ordinatopertassonomia,terminee conteggio deipostpertermine.

Se desideri semplicementei post,modifica la queryin SELECT p.*e GROUP BY p.ID

Here's the solution I've used for this particular problem. This solution is for extreme cases where it is both not possible to use a pre_get_posts filter and there is existing pagination on the query (ie: WooCommerce):

global $wpdb;

$taxonomies = array('my-tax-1', 'my-tax-2', 'my-tax-3');

$orderby = "'".implode("', '", array_keys($taxonomies))."'";
$id_sql = $GLOBALS['wp_query']->request;

$id_sql = preg_replace('/LIMIT\s+\d+\s?,?\s\d*/', '', $id_sql);
$id_sql = str_replace('SQL_CALC_FOUND_ROWS', '', $id_sql);

$term_sql = "SELECT
  tt.taxonomy AS `taxonomy`,
  t.name AS `term_name`,
  t.slug AS `term_slug`,
  count(*) AS `term_count`
FROM ({$id_sql}) p 
JOIN wp_term_relationships tr
  ON p.ID = tr.object_id
JOIN wp_term_taxonomy tt
  ON tr.term_taxonomy_id = tt.term_taxonomy_id
JOIN wp_terms t
  ON tt.term_id = t.term_id
WHERE tt.taxonomy IN ({$orderby})
GROUP BY t.slug
ORDER BY
  FIELD(tt.taxonomy, {$orderby})"; // Add further specific ordering here

$results = $wpdb->get_results($term_sql, ARRAY_A);

I've used this to create a nav menu ordered by taxonomy, term, and count of posts-per-term.

If you simply want the posts then change the query to SELECT p.* and GROUP BY p.ID

È come una queryprima della query,manon sipreoccuperà senon stiamointerrogandotroppipost ... L'idea è dimodificare la queryprincipalein modo danon dovernemmeno andare aimodellie generarenuove querye cicli ...

 function grouped_by_taxonomy_main_query( $query ) {

    if ( $query->is_home() && $query->is_main_query() ) { // Run only on the homepage

        $post_ids = array();

        $terms = get_terms('my_custom_taxonomy');

        foreach ( $terms as $term ) {
            $post_ids = array_merge( $post_ids, get_posts( array( 
                'posts_per_page' => 4, // as you wish...
                'post_type' => 'my_custom_post_type', // If needed... Default is posts
                'fields' => 'ids', // we only want the ids to use later in 'post__in'
                'tax_query' => array( array( 'taxonomy' => $term->taxonomy, 'field' => 'term_id', 'terms' => $term->term_id, )))) // getting posts in the current term
            );
        }

        $query->query_vars['post_type'] = 'my_custom_post_type'; // Again, if needed... Default is posts
        $query->query_vars['posts_per_page'] = 16; // If needed...
        $query->query_vars['post__in'] = $post_ids; // Filtering with the post ids we've obtained above
        $query->query_vars['orderby'] = 'post__in'; // Here we keep the order we generated in the terms loop
        $query->query_vars['ignore_sticky_posts'] = 1; // If you dont want your sticky posts to change the order

    }
}

// Hook my above function to the pre_get_posts action
add_action( 'pre_get_posts', 'grouped_by_taxonomy_main_query' );
 

It's like a query before the query, but won't bother if we're not not querying too many posts... The idea is to modify the main query so we don't even need to go to templates and generate new queries and loops...

function grouped_by_taxonomy_main_query( $query ) {

    if ( $query->is_home() && $query->is_main_query() ) { // Run only on the homepage

        $post_ids = array();

        $terms = get_terms('my_custom_taxonomy');

        foreach ( $terms as $term ) {
            $post_ids = array_merge( $post_ids, get_posts( array( 
                'posts_per_page' => 4, // as you wish...
                'post_type' => 'my_custom_post_type', // If needed... Default is posts
                'fields' => 'ids', // we only want the ids to use later in 'post__in'
                'tax_query' => array( array( 'taxonomy' => $term->taxonomy, 'field' => 'term_id', 'terms' => $term->term_id, )))) // getting posts in the current term
            );
        }

        $query->query_vars['post_type'] = 'my_custom_post_type'; // Again, if needed... Default is posts
        $query->query_vars['posts_per_page'] = 16; // If needed...
        $query->query_vars['post__in'] = $post_ids; // Filtering with the post ids we've obtained above
        $query->query_vars['orderby'] = 'post__in'; // Here we keep the order we generated in the terms loop
        $query->query_vars['ignore_sticky_posts'] = 1; // If you dont want your sticky posts to change the order

    }
}

// Hook my above function to the pre_get_posts action
add_action( 'pre_get_posts', 'grouped_by_taxonomy_main_query' );

mi piace ordinarei mieiterminimanualmente,quindi uso unpluginperfarlo.e sono unfan delfiltro pre_get_posts,quindi hopreso l'esempio di lavoro corretto di Drew Gourleye l'hofattofunzionare con quello. quindi questo è un caso speciale,ma lo sto comunquepubblicando,nel casoin cui aiuti qualcuno.il codice seguente vain functions.php oin unpluginpersonalizzato.

perprima cosainiziamo conilfiltro. ordiniamoiltipo di articolopersonalizzato musicin base allatassonomiapersonalizzata style

 function so14306_pre_get_posts($query)
{
    if (is_admin()) :
        return;
    endif;

    if ($query->is_main_query()) :
        if (is_post_type_archive('music')) :
            $query->set('orderby', 'style');

        endif;
    endif;
}

add_action('pre_get_posts', 'so14306_pre_get_posts');
 

quindi chiamiamoilfiltropost_clauses:

 function so14306_posts_clauses($clauses, $wp_query)
{
    global $wpdb;

    if (isset($wp_query->query_vars['orderby']) && $wp_query->query_vars['orderby'] === 'style') {
        $orderby = $wp_query->query_vars['orderby'];
        $clauses['join'] .= <<<SQL
LEFT OUTER JOIN {$wpdb->term_relationships} ON {$wpdb->posts}.ID={$wpdb->term_relationships}.object_id
LEFT OUTER JOIN {$wpdb->term_taxonomy} USING (term_taxonomy_id)
LEFT OUTER JOIN {$wpdb->terms} USING (term_id)
SQL;
        $clauses['where'] .= " AND (taxonomy = '{$orderby}' OR taxonomy IS NULL)";
        $clauses['groupby'] = "object_id";
        $clauses['orderby'] = "GROUP_CONCAT({$wpdb->terms}.term_order ORDER BY {$wpdb->terms}.term_order ASC) ASC";
        $clauses['orderby'] .= ", {$wpdb->posts}.post_name ASC";
    }

    return $clauses;
}

add_filter('posts_clauses', 'so14306_posts_clauses', 10, 2);
 

oratutto quello che devifare è ordinare letuetassonomie conil seguenteplugin: Ordinepostalepersonalizzato semplice . Questo plugin è obbligatorio per questa soluzione,poiché aggiunge la colonna term_order al database!

e questa riga qui: $clauses['orderby'] .= ", {$wpdb->posts}.post_name ASC" ordinai postpertitolo,quindi l'ordinamento completo della soluzioneprecedente è:taxonomyterm=>titolo delpost.

i like to sort my terms manually, so i use a plugin to do so. and i'm a fan of the pre_get_posts filter, so i took the proper working example of Drew Gourley and made it work with that. so this is some kinda special case, but i'm posting this anyhow, in case it helps someone. following code goes into functions.php or a custom plugin.

first lets start of with the filter. we order the custom post type music by custom taxonomy style

function so14306_pre_get_posts($query)
{
    if (is_admin()) :
        return;
    endif;

    if ($query->is_main_query()) :
        if (is_post_type_archive('music')) :
            $query->set('orderby', 'style');

        endif;
    endif;
}

add_action('pre_get_posts', 'so14306_pre_get_posts');

then we call the post_clauses filter:

function so14306_posts_clauses($clauses, $wp_query)
{
    global $wpdb;

    if (isset($wp_query->query_vars['orderby']) && $wp_query->query_vars['orderby'] === 'style') {
        $orderby = $wp_query->query_vars['orderby'];
        $clauses['join'] .= <<<SQL
LEFT OUTER JOIN {$wpdb->term_relationships} ON {$wpdb->posts}.ID={$wpdb->term_relationships}.object_id
LEFT OUTER JOIN {$wpdb->term_taxonomy} USING (term_taxonomy_id)
LEFT OUTER JOIN {$wpdb->terms} USING (term_id)
SQL;
        $clauses['where'] .= " AND (taxonomy = '{$orderby}' OR taxonomy IS NULL)";
        $clauses['groupby'] = "object_id";
        $clauses['orderby'] = "GROUP_CONCAT({$wpdb->terms}.term_order ORDER BY {$wpdb->terms}.term_order ASC) ASC";
        $clauses['orderby'] .= ", {$wpdb->posts}.post_name ASC";
    }

    return $clauses;
}

add_filter('posts_clauses', 'so14306_posts_clauses', 10, 2);

now all you need to do, is sort your taxonomies with the following plugin: Simple Custom Post Order. This plugin is mandatory for this solution, since it adds the column term_order to the database!

and this line here: $clauses['orderby'] .= ", {$wpdb->posts}.post_name ASC" orders the posts by title, so the full sorting of the above solution is: taxonomy term => post title.