Contents

Code Reference Classes BP_XProfile_Query BP_XProfile_Query::get_sql_clauses()

BP_XProfile_Query::get_sql_clauses()

Generate SQL clauses to be appended to a main query.

Description

Called by the public BP_XProfile_Query::get_sql(), this method is abstracted out to maintain parity with WP’s Query classes.

Return

(array) Array containing JOIN and WHERE SQL clauses to append to the main query.

  • 'join'
    (string) SQL fragment to append to the main JOIN clause.
  • 'where'
    (string) SQL fragment to append to the main WHERE clause.

Source

File: bp-xprofile/classes/class-bp-xprofile-query.php 

	protected function get_sql_clauses() {
		/*
		 * $queries are passed by reference to get_sql_for_query() for recursion.
		 * To keep $this->queries unaltered, pass a copy.
		 */
		$queries = $this->queries;
		$sql = $this->get_sql_for_query( $queries );

		if ( ! empty( $sql['where'] ) ) {
			$sql['where'] = ' AND ' . $sql['where'];
		}

		return $sql;
	}

Expand full source code Collapse full source code

Changelog

Changelog
Version Description
BuddyPress 2.2.0 Introduced.
Used By
Used By Description
bp-xprofile/classes/class-bp-xprofile-query.php: BP_XProfile_Query::get_sql()

Generates SQL clauses to be appended to a main query.

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.