woogc/network_orders/get_orders/mysql_query/JOIN
Name: woogc/network_orders/get_orders/mysql_query/JOIN
Type: Filter
Arguments: $mysql_query, $blog_id
The filter can be used to modify the MySQL query used by the Network Orders interface, which outputs the orders from all shops.
The following code example shows only the orders for shop_manager roles, from shops where the user have access :
add_filter ( 'woogc/network_orders/get_orders/mysql_query/JOIN', '_custom_network_orders_mysql_query_JOIN', 10, 2 );
function _custom_network_orders_mysql_query_JOIN ( $mysql_query, $blog_id )
{
//custom changes to the query
return $mysql_query;
}
The code should be placed inside a php file on wp-content/mu-plugins folder.