Search Activity Meta – sql
-
Hi!
I believe that my problem is in the sql query (although they work separately in my test in phpmyadmin) Im trying to filter a meta activity.`function Custom_Global_Search_Posts_sql( $sql, $args ) {
global $wpdb;$bp;
$sql = ” SELECT DISTINCT a.id FROM wp_bp_activity a INNER JOIN wp_bp_activity_meta ON (a.id = wp_bp_activity_meta.activity_id) WHERE a.is_spam = 0 AND (wp_bp_activity_meta.meta_key = ‘descr’ ) AND a.type = ‘activity_problem’ AND wp_bp_activity_meta.meta_value LIKE %s “;$query_placeholder[] = ‘%’.$wpdb->esc_like( $search_term ).’%’;
$sql = $wpdb->prepare( $sql, $query_placeholder );
return $sql;
}`Thanks!!
- You must be logged in to reply to this topic.