BP_Activity_Activity::get_meta_query_sql( array $meta_query = array() )

Get the SQL for the ‘meta_query’ param in BP_Activity_Activity::get().

Description

We use WP_Meta_Query to do the heavy lifting of parsing the meta_query array and creating the necessary SQL clauses. However, since BP_Activity_Activity::get() builds its SQL differently than WP_Query, we have to alter the return value (stripping the leading AND keyword from the ‘where’ clause).

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-activity/classes/class-bp-activity-activity.php

public static function get_meta_query_sql( $meta_query = array() ) {
    global $wpdb;
 
    $sql_array = array(
        'join'  => '',
        'where' => '',
    );
 
    if ( ! empty( $meta_query ) ) {
        $activity_meta_query = new WP_Meta_Query( $meta_query );
 
        // WP_Meta_Query expects the table name at
        // $wpdb->activitymeta.
        $wpdb->activitymeta = buddypress()->activity->table_name_meta;
 
        $meta_sql = $activity_meta_query->get_sql( 'activity', 'a', 'id' );
 
        // Strip the leading AND - BP handles it in get().
        $sql_array['where'] = preg_replace( '/^\sAND/', '', $meta_sql['where'] );
        $sql_array['join']  = $meta_sql['join'];
    }
 
    return $sql_array;
}

Expand full source code Collapse full source code

Changelog

Changelog
Version	Description
BuddyPress 1.8.0	Introduced.

Uses

Uses
Uses	Description
bp-loader.php: buddypress()	The main function responsible for returning the one true BuddyBoss Instance to functions everywhere.

Used By
Used By	Description
bp-activity/classes/class-bp-activity-activity.php: BP_Activity_Activity::get()	Get activity items, as specified by parameters.

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.

Contents