Left switch on gang light pair not getting power

How should an administrative assistant reply to student addressing them as "Professor" or "Doctor"?

Should RL rewards diminish over time?

During the Space Shuttle Columbia Disaster of 2003, Why Did The Flight Director Say, "Lock the doors."?

Infeasibility in mathematical optimization models

What does "sardine box" mean?

Write an interpreter for *

Why should we care about syntactic proofs if we can show semantically that statements are true?

Why did Gandalf use a sword against the Balrog?

First amendment and employment: Can a police department terminate an officer for speech?

Help evaluating integral (anything simple that I am missing?)

What does "目的化して久しい" mean in this dialogue?

Team goes to lunch frequently, I do intermittent fasting but still want to socialize

How does this kind of structure made?

Simple Stop watch which i want to extend

A tool to replace all words with antonyms

Is TA-ing worth the opportunity cost?

What is the maximum number of PC-controlled undead?

Euler products in positive characteristic? [reference request]

Trying to write a shell script that keeps testing a server remotely, but it keeps falling in else statement when I logout

Why is transplanting a specific intact brain impossible if it is generally possible?

Why does Intel's Haswell chip allow FP multiplication to be twice as fast as addition?

Is it okay for a ticket seller to grab a tip in the USA?

Replace value with variable length between double quotes

Laravel nested whereIn from multiple tables

Nested 'AND OR' Query in EloquentIn Laravel Eloquent, select “whereIn” from parent tableLaravel whereIn with a where clause on each array itemQuery multiple, nested Relationships in Laravel/EloquentHandling repeating rows fetched through join in laravelHow to join with three rows from table one with second table in laravelLaravel Nested QueryUsing whereIn() method with laravel Eloquent ModelLaravel - Using multi connection in single queryLaravel Eloquent Inner Join on Self Referencing Table

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

0

I'm using Laravel 5.7. How do i rewrite below code as a single nested query?

I'm currently fetching the result using 2 database queries. I go through some of the answers in stackoverflow, but i still have doubts in nesting multiple tables

 $connectedParts = DB::table('part_connections as c')
 ->join('parts_master as p', 'p.id', '=', 'c.part_number_id')
 ->where('c.part_number_id', $partId)
 ->where('p.id', $partId)
 ->pluck('connected_to');

 $connectedComponents = DB::table('part_connections as pc')
 ->join('parts_master as pm', 'pm.id', '=', 'pc.connected_to')
 ->where('part_number_id',$partId)
 ->where('pm.part_type','1')
 ->whereIn('connected_to', $connectedParts)
 ->pluck('connected_to');

Any help would be greatly appreciated.

laravel nested-query

share|improve this question

asked Mar 27 at 8:23

NadiyaNadiya

1777 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What is the advantage of your solution?
  
  – SiZE
  Mar 27 at 8:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I just wanted to know how to nest this query, may be it'll be of some help in the future
  
  – Nadiya
  Mar 27 at 8:34
  

  
  
  
  

add a comment | 

0

0

I'm using Laravel 5.7. How do i rewrite below code as a single nested query?

I'm currently fetching the result using 2 database queries. I go through some of the answers in stackoverflow, but i still have doubts in nesting multiple tables

 $connectedParts = DB::table('part_connections as c')
 ->join('parts_master as p', 'p.id', '=', 'c.part_number_id')
 ->where('c.part_number_id', $partId)
 ->where('p.id', $partId)
 ->pluck('connected_to');

 $connectedComponents = DB::table('part_connections as pc')
 ->join('parts_master as pm', 'pm.id', '=', 'pc.connected_to')
 ->where('part_number_id',$partId)
 ->where('pm.part_type','1')
 ->whereIn('connected_to', $connectedParts)
 ->pluck('connected_to');

Any help would be greatly appreciated.

laravel nested-query

share|improve this question

asked Mar 27 at 8:23

NadiyaNadiya

1777 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What is the advantage of your solution?
  
  – SiZE
  Mar 27 at 8:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I just wanted to know how to nest this query, may be it'll be of some help in the future
  
  – Nadiya
  Mar 27 at 8:34
  

  
  
  
  

add a comment | 

I'm using Laravel 5.7. How do i rewrite below code as a single nested query?

I'm currently fetching the result using 2 database queries. I go through some of the answers in stackoverflow, but i still have doubts in nesting multiple tables

 $connectedParts = DB::table('part_connections as c')
 ->join('parts_master as p', 'p.id', '=', 'c.part_number_id')
 ->where('c.part_number_id', $partId)
 ->where('p.id', $partId)
 ->pluck('connected_to');

 $connectedComponents = DB::table('part_connections as pc')
 ->join('parts_master as pm', 'pm.id', '=', 'pc.connected_to')
 ->where('part_number_id',$partId)
 ->where('pm.part_type','1')
 ->whereIn('connected_to', $connectedParts)
 ->pluck('connected_to');

Any help would be greatly appreciated.

laravel nested-query

share|improve this question

asked Mar 27 at 8:23

NadiyaNadiya

1777 bronze badges

 $connectedParts = DB::table('part_connections as c')
 ->join('parts_master as p', 'p.id', '=', 'c.part_number_id')
 ->where('c.part_number_id', $partId)
 ->where('p.id', $partId)
 ->pluck('connected_to');

 $connectedComponents = DB::table('part_connections as pc')
 ->join('parts_master as pm', 'pm.id', '=', 'pc.connected_to')
 ->where('part_number_id',$partId)
 ->where('pm.part_type','1')
 ->whereIn('connected_to', $connectedParts)
 ->pluck('connected_to');

share|improve this question

asked Mar 27 at 8:23

NadiyaNadiya

1777 bronze badges

share|improve this question

asked Mar 27 at 8:23

NadiyaNadiya

1777 bronze badges

asked Mar 27 at 8:23

NadiyaNadiya

1777 bronze badges

asked Mar 27 at 8:23

NadiyaNadiya

1777 bronze badges

1 Answer
1

active

oldest

votes

0

Set your relationship properly in your model first then try this query:

//PartConnection model - add for eager loading
public function master() 
 return $this->belongsTo('PartMaster::class', 'connected_to', 'id');


$query = PartConnection::whereHas(‘master’, function($qry)) use ($partId) 
 $qry->where(‘parts_master.id’, $partId);
 $qry->where(‘parts_master.part_type’, 1);
);

$query->where(‘part_number_id’, $partId);

$connectedComponents = $query->get();

update

Try this then:

$connectedComponents = DB::table('part_connections as pc')
 ->join('parts_master as pm', function($join) 
 $join->on('pc.connected_to', '=', 'pm.id');
 $join->on('pc.part_number_id', '=', 'pm.id');
 ) //updated this - removed ;
 ->where('part_number_id',$partId)
 ->where('pm.part_type','1')
 ->get();

share|improve this answer

edited Mar 27 at 12:11

answered Mar 27 at 10:11

rfpdlrfpdl

61811 gold badge1010 silver badges2424 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  table 'part_connection' is really a big table, so i didn't create columns 'created_at' and 'updated_at'. I want to use Query builder instead
  
  – Nadiya
  Mar 27 at 10:34
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  updated @Nadiya
  
  – rfpdl
  Mar 27 at 10:55
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It didn't work.Got empty array.
  
  – Nadiya
  Mar 27 at 11:21
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  sorry got it wrong, try it again, look at the comment
  
  – rfpdl
  Mar 27 at 11:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Still same error
  
  – Nadiya
  Mar 27 at 12:00
  

  
  
  
  

 | 
show 4 more comments

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55372635%2flaravel-nested-wherein-from-multiple-tables%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Set your relationship properly in your model first then try this query:

//PartConnection model - add for eager loading
public function master() 
 return $this->belongsTo('PartMaster::class', 'connected_to', 'id');


$query = PartConnection::whereHas(‘master’, function($qry)) use ($partId) 
 $qry->where(‘parts_master.id’, $partId);
 $qry->where(‘parts_master.part_type’, 1);
);

$query->where(‘part_number_id’, $partId);

$connectedComponents = $query->get();

update

Try this then:

$connectedComponents = DB::table('part_connections as pc')
 ->join('parts_master as pm', function($join) 
 $join->on('pc.connected_to', '=', 'pm.id');
 $join->on('pc.part_number_id', '=', 'pm.id');
 ) //updated this - removed ;
 ->where('part_number_id',$partId)
 ->where('pm.part_type','1')
 ->get();

share|improve this answer

edited Mar 27 at 12:11

answered Mar 27 at 10:11

rfpdlrfpdl

61811 gold badge1010 silver badges2424 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  table 'part_connection' is really a big table, so i didn't create columns 'created_at' and 'updated_at'. I want to use Query builder instead
  
  – Nadiya
  Mar 27 at 10:34
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  updated @Nadiya
  
  – rfpdl
  Mar 27 at 10:55
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It didn't work.Got empty array.
  
  – Nadiya
  Mar 27 at 11:21
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  sorry got it wrong, try it again, look at the comment
  
  – rfpdl
  Mar 27 at 11:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Still same error
  
  – Nadiya
  Mar 27 at 12:00
  

  
  
  
  

 | 
show 4 more comments

0

Set your relationship properly in your model first then try this query:

//PartConnection model - add for eager loading
public function master() 
 return $this->belongsTo('PartMaster::class', 'connected_to', 'id');


$query = PartConnection::whereHas(‘master’, function($qry)) use ($partId) 
 $qry->where(‘parts_master.id’, $partId);
 $qry->where(‘parts_master.part_type’, 1);
);

$query->where(‘part_number_id’, $partId);

$connectedComponents = $query->get();

update

Try this then:

$connectedComponents = DB::table('part_connections as pc')
 ->join('parts_master as pm', function($join) 
 $join->on('pc.connected_to', '=', 'pm.id');
 $join->on('pc.part_number_id', '=', 'pm.id');
 ) //updated this - removed ;
 ->where('part_number_id',$partId)
 ->where('pm.part_type','1')
 ->get();

share|improve this answer

edited Mar 27 at 12:11

answered Mar 27 at 10:11

rfpdlrfpdl

61811 gold badge1010 silver badges2424 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  table 'part_connection' is really a big table, so i didn't create columns 'created_at' and 'updated_at'. I want to use Query builder instead
  
  – Nadiya
  Mar 27 at 10:34
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  updated @Nadiya
  
  – rfpdl
  Mar 27 at 10:55
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It didn't work.Got empty array.
  
  – Nadiya
  Mar 27 at 11:21
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  sorry got it wrong, try it again, look at the comment
  
  – rfpdl
  Mar 27 at 11:25
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Still same error
  
  – Nadiya
  Mar 27 at 12:00
  

  
  
  
  

 | 
show 4 more comments

Set your relationship properly in your model first then try this query:

//PartConnection model - add for eager loading
public function master() 
 return $this->belongsTo('PartMaster::class', 'connected_to', 'id');


$query = PartConnection::whereHas(‘master’, function($qry)) use ($partId) 
 $qry->where(‘parts_master.id’, $partId);
 $qry->where(‘parts_master.part_type’, 1);
);

$query->where(‘part_number_id’, $partId);

$connectedComponents = $query->get();

update

Try this then:

$connectedComponents = DB::table('part_connections as pc')
 ->join('parts_master as pm', function($join) 
 $join->on('pc.connected_to', '=', 'pm.id');
 $join->on('pc.part_number_id', '=', 'pm.id');
 ) //updated this - removed ;
 ->where('part_number_id',$partId)
 ->where('pm.part_type','1')
 ->get();

share|improve this answer

edited Mar 27 at 12:11

answered Mar 27 at 10:11

rfpdlrfpdl

61811 gold badge1010 silver badges2424 bronze badges

//PartConnection model - add for eager loading
public function master() 
 return $this->belongsTo('PartMaster::class', 'connected_to', 'id');


$query = PartConnection::whereHas(‘master’, function($qry)) use ($partId) 
 $qry->where(‘parts_master.id’, $partId);
 $qry->where(‘parts_master.part_type’, 1);
);

$query->where(‘part_number_id’, $partId);

$connectedComponents = $query->get();

$connectedComponents = DB::table('part_connections as pc')
 ->join('parts_master as pm', function($join) 
 $join->on('pc.connected_to', '=', 'pm.id');
 $join->on('pc.part_number_id', '=', 'pm.id');
 ) //updated this - removed ;
 ->where('part_number_id',$partId)
 ->where('pm.part_type','1')
 ->get();

share|improve this answer

edited Mar 27 at 12:11

answered Mar 27 at 10:11

rfpdlrfpdl

61811 gold badge1010 silver badges2424 bronze badges

answered Mar 27 at 10:11

rfpdlrfpdl

61811 gold badge1010 silver badges2424 bronze badges

answered Mar 27 at 10:11

rfpdlrfpdl

61811 gold badge1010 silver badges2424 bronze badges