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.

Uses

Uses
Uses	Description
bp-xprofile/classes/class-bp-xprofile-query.php: BP_XProfile_Query::get_sql_for_query()	Generate SQL clauses for a single query array.

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.

Contents