How do I create a custom relationship in laravel?

Question

Is it possible to create custom relationships in Laravel like this,

SELECT tasks.* 
FROM tasks
LEFT JOIN priorities ON tasks.priority_identifier LIKE CONCAT('%', priorities.identifier)
WHERE priority.id = 10

I could use query builder to create this join but how can i return this as a laravel relationship ?

Edit

I'm trying to do this without using existing relationship methods(hasMany, hasOne etc)

Jerodev Jerodev · Accepted Answer · 2019-12-13T08:02:21

Yes, you can add conditions to Laravel relations just like any other query builder. I don't know what your relation will look like, but you could do this for example:

public function tasks()
{
    return $this->hasMany(Task::class)
        ->where('priority', 10);
}

How do I create a custom relationship in laravel?

2 Answers