Querying

Introduction

Querying builds upon knowledge of streams, fields, and entries. Using the querying techniques below you can retreive, insert, and update stream configured entry data.

Getting Started

To initialize a new query use the Streams::entries() method.

use Streams\Core\Support\Facades\Streams;

$query = Streams::entries('contacts');

The Basics

You can chain the below methods together to build query logic and return a collection of results.

use Streams\Core\Support\Facades\Streams;

$results = Streams::entries('contacts')
    ->where('email', 'like', '%@gmail.com')
    ->orderBy('name', 'asc')
    ->get();

Filtering

Basic Where Clauses

You may use the where method on a query instance to add where clauses to the query. The most basic call to where requires three arguments. The first argument is the handle of the field. The second argument is an operator, which can be any of the database's supported operators including IN and NOT IN. Finally, the third argument is the value to evaluate against the field value.

For example, here is a query that verifies the value of the "votes" column is equal to 100:

$users = Streams::entries('users')->where('votes', '=', 100)->get();

For convenience, if you want to verify that a field is equal to a given value, you may pass the value directly as the second argument to the where method:

$users = Streams::entries('users')->where('votes', 100)->get();

You may use a variety of other operators when writing a where clause:

$users = Streams::entries('users')
    ->where('votes', '>=', 100)
    ->get();

$users = Streams::entries('users')
    ->where('votes', '<>', 100)
    ->get();

$users = Streams::entries('users')
    ->where('name', 'like', 'T%')
    ->get();

Or Statements

You may chain where constraints together as well as add or clauses to the query. The orWhere method accepts the same arguments as the where method:

$users = Streams::entries('users')
    ->where('votes', '>', 100)
    ->orWhere('name', 'John')
    ->get();

Sorting/Ordering

The orderBy method allows you to sort the result of the query by a given field. The first argument to the orderBy method should be the field you wish to sort by, while the second argument controls the direction of the sort and may be either asc or desc:

$users = Streams::entries('users')
    ->orderBy('name', 'desc')
    ->get();

If you need to sort by multiple fields, you may invoke orderBy as many times as needed:

$users = Streams::entries('users')
    ->orderBy('name', 'desc')
    ->orderBy('email', 'asc')
    ->get();

Limit/Offset

The limit method allows you to limit the number of result returned by the query and an offset value. The first argument to the limit method should be the number of entries you wish to return, while the second argument controls the offset of the query, if any:

// The first 10
$users = Streams::entries('users')
    ->limit(10)
    ->get();

// The next 10
$users = Streams::entries('users')
    ->limit(10, 10)
    ->get();

Pagination

The paginate method allows you to generate a paginated result. A Laravel paginator instance is returned.

$users = Streams::entries('users')->paginate(15);

echo $users->links(); // Render pagination
echo $users->items(); // Return all items
echo $users->total(); // Return total items

Extending Queries

There are numerous techniques you can use to extend querying logic.

Extending Basics

The query object is macroable.

Query Criteria

The criteria interface serves as the wrapper for various query building logic.