Query scopes in Laravel - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ component_behavior

intermediate

What is the output of this Laravel query scope usage?

Given the following Laravel model and query, what will be the SQL query generated and executed?

Laravel

class Post extends Model {
    public function scopePublished($query) {
        return $query->where('published', true);
    }
}

$posts = Post::published()->toSql();

A "select * from `posts` where `published` = 1"

B "select * from `posts` where `published` = true"

C "select * from `posts` where `published` = 'true'"

D "select * from `posts` where `published` = '1'"

💡 Hint

Remember how Laravel converts boolean values in queries.

Laravel converts boolean true to integer 1 in SQL queries. So the where clause becomes `published = 1`.

❓ state_output

intermediate

What is the value of $users after applying this scope?

Consider this Laravel model and query. What users will be included in $users?

Laravel

class User extends Model {
    public function scopeActive($query) {
        return $query->where('active', 1);
    }
}

$users = User::active()->get();

A No users, because scope is not applied correctly

B All users with 'active' column set to true (boolean)

C All users regardless of 'active' status

D All users with 'active' column set to 1

💡 Hint

Think about how Laravel treats integer 1 in queries.

The scope adds a where clause filtering users where 'active' equals 1. This returns all users with active = 1.

📝 Syntax

advanced

Which option correctly defines a local query scope in Laravel?

Choose the correct syntax for defining a local query scope named 'recent' in a Laravel model.

A public static function scopeRecent($query) { return $query->orderBy('created_at', 'desc'); }

B public function recent($query) { return $query->orderBy('created_at', 'desc'); }

C public function scopeRecent($query) { return $query->orderBy('created_at', 'desc'); }

D public function recentScope($query) { return $query->orderBy('created_at', 'desc'); }

💡 Hint

Local scopes must start with 'scope' and be instance methods.

Local query scopes must be instance methods prefixed with 'scope'. Option C follows this pattern correctly.

🔧 Debug

advanced

Why does this query scope not filter results as expected?

Given this scope and usage, why does the query return all records instead of filtered ones?

Laravel

class Product extends Model {
    public function scopeInStock($query) {
        $query->where('stock', '>', 0);
    }
}

$products = Product::inStock()->get();

A The query builder does not support where clauses in scopes.

B The scope method does not return the query, so the filter is not applied.

C The scope method should be static to work properly.

D The where clause is incorrect; it should be 'stock' >= 1.

💡 Hint

Check if the scope method returns the query builder.

In Laravel, query scopes must return the query builder instance. Without returning, the filter is ignored.

🧠 Conceptual

expert

How do global query scopes differ from local query scopes in Laravel?

Select the statement that correctly describes the difference between global and local query scopes.

A Global scopes automatically apply to all queries on the model, while local scopes must be explicitly called.

B Local scopes apply to all queries automatically, but global scopes require manual invocation.

C Global scopes can only filter by one column, local scopes can filter by multiple columns.

D Local scopes are defined in service providers, global scopes inside models.

💡 Hint

Think about when each scope type is applied during querying.

Global scopes are automatically applied to every query on the model. Local scopes need to be called explicitly.