woocommerce_orders_table_query_clauses │ filter-hook │ WC 7.9.0

Filters all query clauses at once. Covers the fields (SELECT), JOIN, WHERE, GROUP BY, ORDER BY, and LIMIT clauses.

Usage

add_filter( 'woocommerce_orders_table_query_clauses', 'wp_kama_woocommerce_orders_table_query_clauses_filter' );

/**
 * Function for `woocommerce_orders_table_query_clauses` filter-hook.
 * 
 * @param string[] $clauses Associative array of the clauses for the query.
 *
 * @return string[]
 */
function wp_kama_woocommerce_orders_table_query_clauses_filter( $clauses ){

	// filter...
	return $clauses;
}

$clauses(string[])

Associative array of the clauses for the query.

• fields(string)
  The SELECT clause of the query.

• join(string)
  The JOIN clause of the query.

• where(string)
  The WHERE clause of the query.

• groupby(string)
  The GROUP BY clause of the query.

• orderby(string)
  The ORDER BY clause of the query.

• limits(string)
  The LIMIT clause of the query.

Changelog

Where the hook is called

$clauses = (array) apply_filters_ref_array( 'woocommerce_orders_table_query_clauses', array( $pieces, &$this, $this->args ) );

Where the hook is used in WooCommerce