Query Builder

Website Rareloop Timber Documentation Twig Documentation
Search…
Query Builder
Lumberjack has a built-in query builder which provides an expressive, fluent and explicit way of querying data in WordPress. It can be used instead of WP_Query to query posts (of any type) and means you do not have to worry about "the loop".
There are 2 ways in which you can use the query builder. Either on a Post Type:
1
use App\PostTypes\Project;
2
​
3
$projects = Project::builder()
4
    ->orderBy('date', 'asc')
5
    ->get();
Copied!
Or by using the query builder directly:
1
use App\PostTypes\Project;
2
use App\PostTypes\CaseStudy;
3
use Rareloop\Lumberjack\QueryBuilder;
4
​
5
$posts = (new QueryBuilder)->wherePostType([
6
    Project::getPostType(),
7
    CaseStudy::getPostType(),
8
])
9
->orderBy('date', 'asc')
10
->get();
Copied!
Using the query builder on a Post Type
This is the most common way to use the query builder. You can start querying posts simply by using the Rareloop\Lumberjack\Post class. To start a query, use the builder() method.
1
Post::builder();
Copied!
This creates an instance of Rareloop\Lumberjack\ScopedQueryBuilder. This class does a couple of important things:
Returns the correct post objects
When querying a post type, you will always get the same post object back in your results rather than WP_Post objects.
For example, if you have a custom post type called Employee, when you query employees you will always get Employee objects back as results. Lets see what this looks like:
1
use App\PostTypes\Employee;
2
​
3
$employees = Employee::builder()->get();
4
​
5
dump($employees);
6
​
7
/*
8
    Collection {
9
        #items: array:2 [
10
            0 => App\PostTypes\Employee,
11
            1 => App\PostTypes\Employee,
12
        ]
13
    }
14
*/
Copied!
The collection contains instances of the Employee class. This is extremely powerful as you now have access to all the behaviours that come with employees, as defined in your post type class. In this case, you may have a photoUrl() method on an Employee that knows (encapsulates) how to get the correct size image from the featured image:
1
class Employee extends Post
2
{
3
    ...
4
​
5
    public function photoUrl() : string
6
    {
7
        $thumbnail = $this->thumbnail();
8
​
9
        if (empty($thumbnail)) {
10
            return null;
11
        }
12
​
13
        return $thumbnail->src('large');
14
    }
15
}
Copied!
And when iterating through your results, you can safely use this photoUrl() method:
1
use App\PostTypes\Employee;
2
​
3
$employees = Employee::builder()->get();
4
​
5
$employee = $employees->first();
6
​
7
// This will echo out the featured image url if there is one
8
echo $employee->photoUrl();
Copied!
All post types extend Timber's Post object, so you get access to all of their behaviour out of the box.
The example above is making use of Timber's thumbnail() method on a Post, and src() method on an Image.
If collections are new to you, be sure the check out the documentation on them:
Collections
Query scopes
Sometimes you will need to perform the same filter on a query in multiple places within your theme.
1
// Get all featured posts, newest first
2
$featuredPostIds = [1, 2];
3
​
4
$posts = Post::whereIdIn($featuredPostIds)
5
    ->orderBy('date', 'desc')
6
    ->get();
7
​
8
...
9
​
10
// Get the latest 3 featured posts
11
$featuredPostIds = [1, 2];
12
​
13
$posts = Post::whereIdIn($featuredPostIds)
14
    ->orderBy('date', 'desc')
15
    ->limit(3)
16
    ->get();
Copied!
In this example, we are scoping the query to only show featured images. However there's 2 issues with this:
1.We doing it twice, without reusing any code
2.It can be unclear as to what you are doing
Instead, We can encapsulate the knowledge about how to find featured posts by creating a query scope on our post type:
1
namespace App\PostTypes;
2
​
3
use Rareloop\Lumberjack\Post as LumberjackPost;
4
​
5
class Post extends LumberjackPost
6
{
7
    ...
8
​
9
    public function scopeFeatured($query)
10
    {
11
        $featuredPostIds = [1, 2];
12
​
13
        return $query->whereIdIn($featuredPostIds);    
14
    }
15
}
Copied!
Now we have a query scope, we can refactor our previous queries, making them more declarative and easier to change:
1
// Get all featured posts, newest first
2
$posts = Post::featured()
3
    ->orderBy('date', 'desc')
4
    ->get();
5
​
6
...
7
​
8
// Get the latest 3 featured posts
9
$posts = Post::featured()
10
    ->orderBy('date', 'desc')
11
    ->limit(3)
12
    ->get();
Copied!
Query scopes must start with the word scope, and must follow with the name of the method you want available to the builder. The method should also be defined in CamelCase. For example:
scopeFoo() will allow you to call foo() on a query.
scopeFooBar() will allow you to call fooBar() on a query.
You can also pass through parameters into the query scope:
1
namespace App\PostTypes;
2
​
3
use Rareloop\Lumberjack\Post as LumberjackPost;
4
​
5
class Post extends LumberjackPost
6
{
7
    ...
8
​
9
    public function scopeExclude($query, $postId)
10
    {        
11
        return $query->whereIdNotIn([$postId]);    
12
    }
13
}
14
​
15
...
16
​
17
// Get all featured posts, newest first, excluding post id 1
18
$posts = Post::exclude(1)
19
    ->orderBy('date', 'desc')
20
    ->get();
Copied!
Available methods
All the available methods can be chained, with the exclusion of getParameters and get.
​getParameters​
​wherePostType​
​whereIdIn​
​whereIdNotIn​
​whereStatus​
​whereMeta​
​whereMetaRelationshipIs​
​limit​
​offset​
​orderBy​
​get​
​first​
​as​
​clone​
getParameters
returns: array
Get the current state of the query builder, as an array. These parameters can be directly fed into WP_Query as arguments.
For example:
1
$parameters = Post::builder()
2
    ->limit(3)
3
    ->orderBy('date', 'desc')
4
    ->getParameters();
5
​
6
// $parameters would look like this:
7
// [
8
//   "post_type" => "post"
9
//   "posts_per_page" => 3
10
//   "orderby" => "date"
11
//   "order" => "DESC"
12
// ]
Copied!
This can be useful if you need to add your own arguments that the query builder does not support.
1
$parameters = Post::builder()
2
    ->limit(3)
3
    ->orderBy('date', 'desc')
4
    ->getParameters();
5
​
6
$parameters['author_name'] = 'Adam';
7
​
8
$query = new WP_Query($parameters);
Copied!
Alternatively, you can add your own methods to the query builder using macros. See Extending the Query Builder.
wherePostType($postType)
Parameter
Type
Description
$postType
string | array
e.g. 'post', 'page'
Scope the query to a particular post type, or post types.
Populates post_type in WP_Query.
1
// Single
2
$query->wherePostType('page');
3
​
4
// Multiple
5
$query->wherePostType (['page', 'jobs']):
Copied!
When using the query builder from a post type, the query is automatically scoped to the correct post type.
1
// This automatically sets the post type on the query to the Job post type
2
$jobs = Job::builder()->get();
Copied!
Reference: WP_Query - Type Parameters​
whereIdIn(array $ids)
Parameters
Type
Description
$ids
array
An array of post IDs
Scope the query to only look for specific post IDs.
Sets the post__in argument in WP_Query.
Reference: WP_Query - Post & Page Parameters​
whereIdNotIn(array $ids)
Parameters
Type
Description
$ids
array
An array of post IDs
Scope the query to exclude specific post IDs.
Sets the post__not_in argument in WP_Query.
Reference: WP_Query - Post & Page Parameters​
whereStatus()
This method can either take an array of statuses, or multiple parameters for each status:
Array of statuses:
Parameters
Type
Description
$statuses
array
An array of statuses. e.g. publish or draft
1
$query->whereStatus(['publish', 'draft']);
Copied!
Multiple parameters:
Parameters
Type
Description
$status
string
A status. e.g. publish or draft
$status
string
A status. e.g. publish or draft
...
...
...
1
$query->whereStatus('publish', 'draft');
Copied!
Scope the query to only include posts with the given status. By default WordPress will only look for published posts, so you only need to use this method if you need to get posts with other statuses.
Sets the post_status argument in WP_Query.
Reference: WP_Query - Status Parameters​
whereMeta($key, $value, $compare = '=', $type = null)
Parameters
Type
Description
$key
string
The meta key
$value
string
The meta value
$compare
string
Optional. Defaults to =
$type
string | null
Optional. Defaults to null. Pass in a value here to define the custom field type. e.g. numeric.
Scope posts that have the specified custom meta fields.
Adds an array of meta query arguments to the array of meta_query  arguments on WP_Query.
1
'meta_query' => [
2
    [
3
        'key' => 'lead',
4
        'value' => 'Lorem ipsum %',
5
        'compare' = 'LIKE',
6
    ]
7
]
Copied!
Note: meta_query takes an array of meta query arguments arrays (it takes an array of arrays) 
The above example can be written like so:
1
$query->whereMeta('lead', 'Lorem ipsum %', 'LIKE');
Copied!
You can also add multiple meta queries.
1
$query->whereMeta('lead', 'Lorem ipsum %', 'LIKE')
2
    ->whereMeta('price', [20, 100], 'BETWEEN', 'numeric');
Copied!
This will yield the following parameters:
1
'meta_query' => [
2
    [
3
        'key' => 'lead',
4
        'value' => 'Lorem ipsum %',
5
        'compare' = 'LIKE',
6
    ],
7
    [
8
        'key' => 'price',
9
        'value' => [20, 100],
10
        'compare' = 'BETWEEN',
11
        'type' => 'numeric',
12
    ]
13
]
Copied!
Reference: WP_Query - Custom Field Parameters​
whereMetaRelationshipIs(string $relation)
Parameters
Type
Description
$relation
string
The type of relationship between meta queries.
​
Accepts and & or
Sets the relation field for your meta queries, for WP_Query.
1
$query->whereMeta('lead', 'Lorem ipsum %', 'LIKE')
2
    ->whereMeta('price', [20, 100], 'BETWEEN', 'numeric')
3
    ->whereMetaRelationshipIs('or');
Copied!
This will yield the following parameters, adding the 'relation' => 'or' to the meta query.
1
'meta_query' => [
2
    'relation' => 'or',
3
    [
4
        'key' => 'lead',
5
        'value' => 'Lorem ipsum %',
6
        'compare' = 'LIKE',
7
    ],
8
    [
9
        'key' => 'price',
10
        'value' => [20, 100],
11
        'compare' = 'BETWEEN',
12
        'type' => 'numeric',
13
    ]
14
]
Copied!
Reference: WP_Query - Custom Field Parameters​
limit($limit)
Parameter
Type
Description
$limit
int
e.g. 25
Set the number of results to get back from the query.
Sets the posts_per_page argument in WP_Query.
Reference: WP_Query - Pagination Parameters​
offset($offset)
Parameter
Type
Description
$offset
int
e.g. 50
Set the number of results to displace or pass over.
Sets the offset argument in WP_Query.
Reference: WP_Query - Pagination Parameters​
orderBy($orderBy, $order = 'asc')
Parameter
Type
Description
$orderBy
string
e.g. 'menu_order'
$order
string
Optional. Defaults to 'asc' (ascending)
Sort retrieved posts by parameter, e.g. date, title, menu_order.
Sets the orderby and order arguments in WP_Query.
1
$query->orderBy('title', 'asc');
Copied!
Reference: WP_Query - Order & Orderby Parameters​
orderByMeta($metaKey, $order = 'asc', $type = null)
Parameter
Type
Description
$metaKey
string
The meta key to order by
$order
string
Optional. Defaults to 'asc' (ascending)
$type
string
Optional. Defaults to null.
​
Sorting will be alphabetical for strings. When dealing with numbers, you can get some unexpected results (e.g. 1, 3, 34, 4, 56, 6, etc, rather than 1, 3, 4, 6, 34, 56 as you might naturally expect).
​
Pass in 'numeric' here if you plan on sorting numbers.
Sets the orderby argument for WP_Query to meta_value when ordering strings, and meta_value_num when ordering numbers.
Reference: WP_Query - Order & Orderby Parameters​
as($postClass)
Parameters
Type
Description
$postClass
string
The name of the post class that you want the results transformed to
When using WP_Query, you get an array of WP_Post objects back. The query builder will instead return an array of Rareloop\Lumberjack\Post objects back.
You can use this method to change what object is returned from the query builder.
1
use App\PostTypes\Event;
2
​
3
// Get an array of Event objects back
4
$query->wherePostType('event')
5
    ->as(Event::class)
6
    ->get();
Copied!
Note: When using the query builder on a post type, this conversion is done automatically. For example:
1
// Get an array of Event object
2
$events = Event::get();
Copied!
Reference: Timber - get_posts()​
get()
Execute the query and return a Collection of post objects.
1
$posts = $query->whereMeta('price', 100, '>', 'numeric')
2
    ->get();
Copied!
first()
Execute the query and return the first post object. Returns null if there are no results.
1
$post = $query->whereMeta('price', 100, '>', 'numeric')
2
    ->first();
Copied!
clone()
Duplicates a new instance of the query builder with all the current parameters. You can modify this query builder instance separately to the original.
This can be useful if you have similar queries with subtle differences, as it saves you duplicating the commonalities between them.
1
$baseQuery = (new QueryBuilder)
2
    ->wherePostType(Announcement::getPostType())
3
    ->forCurrentUser(); // Some custom Query Scope, for example
4
​
5
$counts = [
6
    'all' => $baseQuery->clone()->whereStatus('publish', 'draft', 'pending')->get()->count(),
7
    'publish' => $baseQuery->clone()->whereStatus('publish')->get()->count(),
8
    'draft' => $baseQuery->clone()->whereStatus('draft')->get()->count(),
9
    'pending' => $baseQuery->clone()->whereStatus('pending')->get()->count(),
10
];
Copied!
Extending the query builder
The Lumberjack QueryBuilder class can be extended with custom functionality at runtime (the class is "macroable"). The following example adds a search method to the QueryBuilder class that can be used to filter results based on a keyword search:
1
use Rareloop\Lumberjack\QueryBuilder;
2
​
3
// Add custom function
4
QueryBuilder::macro('search', function ($term) {
5
    $this->params['s'] = $term;
6
    
7
    return $this;
8
});
9
​
10
QueryBuilder::macro('writtenByCurrentUser', function () {
11
    $this->params['author'] = get_current_user_id();
12
    
13
    return $this;
14
});
15
​
16
// Use the functionality
17
$posts = (new QueryBuilder())
18
    ->search('Elephant');
19
    ->writtenByCurrentUser()
20
    ->get();
21
    
22
// Or on a post type
23
$posts = Post::builder()
24
    ->search('Elephant')
25
    ->writtenByCurrentUser()
26
    ->get();
Copied!
The Basics - Previous
Post Types
Next - The Basics
View Models
Last modified 2yr ago