How to implement nested MySQL query in Laravel Eloquent using Laravel 5.6

Question

This is my MySQL query:

SELECT * FROM cc_calenders 
WHERE 
   cc_calenders.user_id = 1 
OR 
   cc_calenders.id = (
           SELECT cc_calender_shares.calender_id 
           FROM cc_calender_shares 
           WHERE 
                cc_calender_shares.shared_with = '[email protected]')

I tried to write the Laravel eloquent code like this:

$records    = Calender::where('user_id', $user_id)
                        ->orWhere('id', function($query) use ($user_email) {
                                $query->table('calender_shares')
                                      ->select('calender_shares.calender_id')
                                      ->where('calender_shares.shared_with', $user_email);
                        })->get();

I am getting this error:

Call to undefined method Illuminate\Database\Query\Builder::table()

What am I doing wrong?

Possible duplicate of How to do this in Laravel, subquery where in — Rwd
– Rwd, Commented Mar 5, 2019 at 7:37

Xavier Au · Accepted Answer · 2019-03-05 08:00:00Z

1

You can try

$records    = Calender::where('user_id', $user_id)
                        ->orWhere('id', function($query) use ($user_email) {
                                $query->select('calender_id')
                                      ->from('calender_shares')
                                      ->where('shared_with', $user_email);
                        })->get();

How to do this in Laravel, subquery where in

answered Mar 5, 2019 at 8:00

Xavier Au

212 bronze badges

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

Comments

Saswat · Accepted Answer · 2019-03-05 08:00:50Z

Since nobody could answer me before I get my own answer, I am putting the code down here for people who might stumble on same problem.

The main issue was, I was using table() function in the subquery. The better solution was to use from() function.

The code snippet from(with(new CalenderShare)->getTable()) would provide me a the table name of model CalenderShare.

Calender::where('user_id', $user_id)
          ->orWhereIn('id', function($query) use ($user_email) {
                               $query->from(with(new CalenderShare)->getTable())
                                       ->select('calender_shares.calender_id')
                                       ->where('calender_shares.shared_with', $user_email);
                            })->get();

Collectives™ on Stack Overflow

How to implement nested MySQL query in Laravel Eloquent using Laravel 5.6

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related