BP_Messages_Message::get_meta_query_sql( array $meta_query = array() )
Get the SQL for the ‘meta_query’ param in BP_Messages_Message::get()
Description
We use WP_Meta_Query to do the heavy lifting of parsing the meta_query array and creating the necessary SQL clauses.
Parameters
- $meta_query
-
(Optional) An array of meta_query filters. See the documentation for WP_Meta_Query for details.
Default value: array()
Return
(array) $sql_array 'join' and 'where' clauses.
Source
File: bp-messages/classes/class-bp-messages-message.php
protected static function get_meta_query_sql( $meta_query = array() ) {
global $wpdb;
$sql_array = array(
'join' => '',
'where' => '',
);
if ( ! empty( $meta_query ) ) {
$message_meta_query = new WP_Meta_Query( $meta_query );
// WP_Meta_Query expects the table name at
$wpdb->messagemeta = buddypress()->messages->table_name_meta;
$meta_sql = $message_meta_query->get_sql( 'message', 'm', 'id' );
$sql_array['join'] = $meta_sql['join'];
$sql_array['where'] = self::strip_leading_and( $meta_sql['where'] );
}
return $sql_array;
}
Changelog
| Version | Description |
|---|---|
| BuddyPress 1.8.0 | Introduced. |
Questions?
We're always happy to help with code or other questions you might have! Search our developer docs, contact support, or connect with our sales team.