Query Reference

How To Query Records

Using the query helper function

You can use the wp_stream_query() helper function to query a custom set of records.

This function accepts one argument, an array of query parameters.

Using the WP-CLI command

Since version 2.0.3 there is a custom WP-CLI command available for querying records via the command line.

The query subcommand can accept any available query parameter as an argument.

Examples

$ wp stream query
$ wp stream query --author=1
$ wp stream query --author_role__not_in=administrator --date_after=2015-01-01T12:00:00
$ wp stream query --author=1 --action=login --records_per_page=50 --fields=created --order=asc

Available Query Parameters

Author

Get records associated with certain authors.

• author (int) - A user ID.
• author__in (array) - An array of user IDs.
• author__not_in (array) - An array of user IDs.
• author_role (string) - A user role name (not the label).
• author_role__in (array) - An array of user role names.
• author_role__not_in (array) - An array of user role names.

Get records for one author

$records = wp_stream_query( array( 'author' => 1 ) );

Get records for multiple authors

$records = wp_stream_query( array( 'author__in' => array( 1, 2, 3 ) ) );

Get records excluding certain authors

$records = wp_stream_query( array( 'author__not_in' => array( 4, 5, 6 ) ) );

Get records from authors belonging to a certain role

$records = wp_stream_query( array( 'author_role' => 'editor' ) );

Get records from authors belonging to certain roles

$records = wp_stream_query( array( 'author_role__in' => array( 'administrator', 'editor' ) ) );

Get records from authors not belonging to certain roles

$records = wp_stream_query( array( 'author_role__not_in' => array( 'contributor', 'subscriber' ) ) );

Date

• date (string) - A datetime string in Y-m-d format.
• date_from (string) - A datetime string in Y-m-d format.
• date_to (string) - A datetime string in Y-m-d format.
• date_after (string) - A datetime string in Y-m-d or c formats.
• date_before (string) - A datetime string in Y-m-d or c formats.

Read more about Date Formatting in the PHP docs.

Get records from a specific date

$records = wp_stream_query( array( 'date' => '2015-01-22' ) );

Get records from a specific date range

$records = wp_stream_query( array( 'date_from' => '2015-01-01', 'date_to' => '2015-01-31' ) );

Get records after a specific datetime

$records = wp_stream_query( array( 'date_after' => '2015-01-01T19:30:00+00:00' ) );

Get records before a specific date

$records = wp_stream_query( array( 'date_before' => '2015-01-31' ) );

IP Address

Get records associated with certain IP addresses.

• ip (string) - An IP address.
• ip__in (array) - An array of IP addresses.
• ip__not_in (array) - An array of IP addresses.

Get records that came from an IP address

$records = wp_stream_query( array( 'ip' => '192.168.0.1' ) );

Get records that came from certain IP addresses

$records = wp_stream_query( array( 'ip__in' => array( '192.168.0.1', '127.0.0.1' ) ) );

Get records that did not come from certain IP addresses

$records = wp_stream_query( array( 'ip__not_in' => array( '192.168.0.2', '127.0.0.2' ) ) );

Connector

Get records associated with certain connectors.

• connector (string) - A connectors name.
• connector__in (array) - An array of connector names.
• connector__not_in (array) - An array of connector names.

Get records of a specific connector

$records = wp_stream_query( array( 'connector' => 'widgets' ) );

Context

Get records associated with certain contexts.

• context (string) - A context name.
• context__in (array) - An array of context names.
• context__not_in (array) - An array of context names.

Get records of a specific context

$records = wp_stream_query( array( 'context' => 'sidebar-1' ) );

Action

Get records associated with certain actions.

• action (string) - An action name.
• action__in (array) - An array of action names.
• action__not_in (array) - An array of action names.

Get records of a specific action

$records = wp_stream_query( array( 'action' => 'updated' ) );

Search

• search (string) - A search word or phrase.
• search_field (string) - Which field should be searched. Defaults to summary.

Get records that have these words in the summary

$records = wp_stream_query( array( 'search' => 'plugin deactivated' ) );

Records

• record (string) - A record UUID.
• record__in (array) - An array or record UUIDs.
• record__not_in (array) - An array or record UUIDs.

Pagination

• records_per_page (int) - The number of records to display on each page. Defaults to the posts_per_page setting in WordPress.
• paged (int) - Which page number to show results for. Defaults to 1.

Order

• order (string) - The direction in which to order the records. Defaults to desc.
• order_by (string) - What field to order the records by. Defaults to date.