Changeset 29896 for trunk/src/wp-includes/taxonomy.php

Timestamp:

10/15/2014 12:53:22 AM (10 years ago)

Author:

boonebgorges

Message:

Support 'EXISTS' and 'NOT EXISTS' in WP_Tax_Query.

These new values for the 'operator' parameter make it possible to filter items
that have no term from a given taxonomy, or any term from a given taxonomy.

Includes unit tests.

Fixes #29181.

File:

• trunk/src/wp-includes/taxonomy.php (modified) (3 diffs)

trunk/src/wp-includes/taxonomy.php

@@ -692 +692 @@
      *
      * @since 3.1.0
+     * @since 4.1.0 Added support for $operator 'NOT EXISTS' and 'EXISTS'.
      * @access public
      *
      * @param array $tax_query {
-     *     Array of taxonoy query clauses.
+     *     Array of taxonomy query clauses.
      *
      *     @type string $relation Optional. The MySQL keyword used to join
@@ -707 +708 @@
      *                                                 'name', or 'term_taxonomy_id'. Default: 'term_id'.
      *         @type string           $operator         MySQL operator to be used with $terms in the WHERE clause.
-     *                                                  Accepts 'AND', 'IN', or 'OR. Default: 'IN'.
+     *                                                  Accepts 'AND', 'IN', 'NOT IN', 'EXISTS', 'NOT EXISTS'.
+     *                                                  Default: 'IN'.
      *         @type bool             $include_children Optional. Whether to include child terms.
      *                                                  Requires a $taxonomy. Default: true.
@@ -1027 +1029 @@
                 AND object_id = $this->primary_table.$this->primary_id_column
             ) = $num_terms";
+
+        } elseif ( 'NOT EXISTS' === $operator || 'EXISTS' === $operator ) {
+
+            $where = $wpdb->prepare( "$operator (
+                SELECT 1
+                FROM $wpdb->term_relationships
+                INNER JOIN $wpdb->term_taxonomy
+                ON $wpdb->term_taxonomy.term_taxonomy_id = $wpdb->term_relationships.term_taxonomy_id
+                WHERE $wpdb->term_taxonomy.taxonomy = %s
+                AND $wpdb->term_relationships.object_id = $this->primary_table.$this->primary_id_column
+            )", $clause['taxonomy'] );
+
         }