How to remove the generated where clause in a relations

I'm customizing the hasMany relations

public function answers()
{
    $relation = $this->hasMany(Answer::class);
    dd($relation->getBaseQuery()->toSql());
}

I want to remove completely the where clause.

"select * from `answer` where `answer`.`post_id` = ? and `answer`.`post_id` is not null"

I already tried to set the wheres array of its builder but there's no success.

$relation->getQuery()->joins = [];
$relation->getQuery()->wheres = [];

Snapey

6 years ago

Level 122

Why?

Why would you want a relationship that is not related?

quinnwynn

6 years ago

Level 1

I'm not allowed to modify the structure of the database although the foreign key did not set up properly; so that I have to modify the relations.

To be more specific, the post_id instead of stays on the child table, means the answers table, it stays on the parent table, which is the posts table. The foreign key column has to concate string like that 8578|58757|7855.

quinnwynn

6 years ago

Best Answer

Level 1

Found it. You have to use getBaseQuery, not getQuery. Don't forget to remove binding parameters also.

$relation->getBaseQuery()->wheres = [];
$relation->getBaseQuery()->bindings['where'] = [];

dwiser

8 months ago

Level 5

Thanks @quinnwynn

This worked perfectly for me even 5 years later on Laravel 12.

Context: I have a Legislator model with a relationship to a state model but when the state_id is 52, it actually returns "United States" instead of the state since they are a federal legislator. This is how the data comes from the datasource.

In those cases, I still wanted to return the state relationship but needed to overwrite the default where query in the relationship and add a new one using the state abbreviation.

Here's my code:

/**
 * Get the state where the legislator resides.
 *
 * @return Eloquent\Relations\BelongsTo
 */
public function state(): Eloquent\Relations\BelongsTo
{
    if ($this->state_id === 52 && $this->district) {
        // For federal legislators, we need to match
        // the last two characters of district to get the state abbreviation

        // Store the belongsTo relation
        $relation = $this->belongsTo(State::class);

        // Reset the default state_id query
        $relation->getBaseQuery()->wheres = [];
        $relation->getBaseQuery()->bindings['where'] = [];

		// Pull off the last two characters to get the state abbreviation
        $stateAbbr = Str::of($this->district)->substr(3, 2)->lower();

		// Add the actual where query to find the state.
        return $relation->where('abbreviation', $stateAbbr);
    }

	// The normal relationship for every other case.
    return $this->belongsTo(State::class);
}

Please or to participate in this conversation.