Laravel Query Builder and "not unique table/alias" error

Question

I have conditional code that joins a table depending on input params

    $content = Content::select('content.*');

    if (isset($filters['ruleNumber'])) {
        $content->join('violation', 'violation.content_id', '=', 'content.id')
                ->where('violation.rule_number', $filters['ruleNumber']);
    }

    if (isset($filters['unprocessed'])) {
        $content->join('violation', 'violation.content_id', '=', 'content.id')
                ->where('violation.status', 'pending');
    }

If both $filters['ruleNumber'] and $filters['unprocessed'] are due, it will result in a duplicate join query (i.e. "violation" is joined twice). I could keep track of my joins prior to calling join(), but I'd need to implement this logic wherever I use the query builder.

It seems odd that the framework doesn't support this out of the box, or am I missing something?

Gopal · Accepted Answer · 2017-10-05 07:08:28Z

2

minor change i made.. try this it might be work

$content = Content::select('content.*');
if (isset($filters['ruleNumber']) || isset($filters['unprocessed'])){
    $content->join('violation', 'violation.content_id', '=', 'content.id')
}

if (isset($filters['ruleNumber'])) {
    $content->where('violation.rule_number', $filters['ruleNumber']);
}

if (isset($filters['unprocessed'])) {
    $content->where('violation.status', 'pending');
}

answered Oct 5, 2017 at 7:08

Gopal

1118 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel Query Builder and "not unique table/alias" error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related