BP_Activity_Activity::get_date_query_sql( array $date_query = array() )

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

Description Description

We use BP_Date_Query, which extends WP_Date_Query, to do the heavy lifting of parsing the date_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 query).

Top ↑

Parameters Parameters


(array) (Optional) An array of date_query parameters. See the documentation for the first parameter of WP_Date_Query.

Default value: array()

Top ↑

Return Return


Source Source

File: bp-activity/classes/class-bp-activity-activity.php

	public static function get_date_query_sql( $date_query = array() ) {
		$sql = '';

		// Date query.
		if ( ! empty( $date_query ) && is_array( $date_query ) ) {
			$date_query = new BP_Date_Query( $date_query, 'date_recorded' );
			$sql = preg_replace( '/^\sAND/', '', $date_query->get_sql() );

		return $sql;

Top ↑

Changelog Changelog

Version Description
2.1.0 Introduced.

Top ↑

User Contributed Notes User Contributed Notes

You must log in before being able to contribute a note or feedback.