Styjun

'spazieren' - walking in a silly and affected manner?

German equivalent to "going down the rabbit hole"

Sum and average calculator

Are there indian reservations in United States where you can't live if you aren't a tribal member?

Is this homebrew "Faerie Fire Grenade" unbalanced?

What is this "opened" cube called?

Is "prohibition against," a double negative?

What is a "hashed transaction" in SQL Server Replication terminology?

Is Borg adaptation only temporary?

Match blank lines before a word awk

Unexpected behavior after assignment of function object to function wrapper

Sort Associations by its Values (which are nested lists)

Find the logic in first 2 statements to give the answer for the third statement

Can authors email you PDFs of their textbook for free?

Create a list of snaking numbers under 50,000

Who declared the Last Alliance to be the "last" and why?

Small RAM 4 KB on the early Apple II?

Is it good practice to speed up and slow down where not written in a song?

Don't look at what I did there

Eshet Chayil in the Tunisian service

How can I improve my formal definitions

Necessity of tenure for lifetime academic research

Was it illegal to blaspheme God in Antioch in 360.-410.?

In Endgame, wouldn't Stark have remembered Hulk busting out of the stairwell?

How do I filter the eager loaded class?

Add a custom attribute to a Laravel / Eloquent model on load?Return an eager loaded object in Laravel4Convert Laravel query to Eager LoadingFiltering models by eager loaded data, at the database levelLaravel 5.4 - Eager Loading Child and Grandchild with Select BothEloquent query problem using with() function for model relationship eager loadingHow to output Eloquent Eager Loading in View (blade files) in Laravel?Override Eager Loaded Results With Filtered ResultsLaravel Get Result Ordred By For an eager Loaded RelationEager-Loading based on the first query

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

0

I have a category class and I am calling all the events inside that class with eager loading. However I only want to show the events that have been approved. I am using a show controller in Laravel.

I have been able to filter the category class using wherehas() but I can't figure out how to filter the result of the eager loaded events class.

public function show(Category $category)
 
 $cat = $category->with('events')->get();

 return $cat;

 return view('category.show', compact('cat'));
 

Like I said, I've been able to filter the category but how do I send through the category with the events that have approved = 1 instead of null?

laravel controller eager-loading

share|improve this question

asked Mar 27 at 22:54

chrischris

1255 bronze badges

add a comment | 

0

I have a category class and I am calling all the events inside that class with eager loading. However I only want to show the events that have been approved. I am using a show controller in Laravel.

I have been able to filter the category class using wherehas() but I can't figure out how to filter the result of the eager loaded events class.

public function show(Category $category)
 
 $cat = $category->with('events')->get();

 return $cat;

 return view('category.show', compact('cat'));
 

Like I said, I've been able to filter the category but how do I send through the category with the events that have approved = 1 instead of null?

laravel controller eager-loading

share|improve this question

asked Mar 27 at 22:54

chrischris

1255 bronze badges

add a comment | 

I have a category class and I am calling all the events inside that class with eager loading. However I only want to show the events that have been approved. I am using a show controller in Laravel.

I have been able to filter the category class using wherehas() but I can't figure out how to filter the result of the eager loaded events class.

public function show(Category $category)
 
 $cat = $category->with('events')->get();

 return $cat;

 return view('category.show', compact('cat'));
 

Like I said, I've been able to filter the category but how do I send through the category with the events that have approved = 1 instead of null?

laravel controller eager-loading

share|improve this question

asked Mar 27 at 22:54

chrischris

1255 bronze badges

public function show(Category $category)
 
 $cat = $category->with('events')->get();

 return $cat;

 return view('category.show', compact('cat'));
 

share|improve this question

asked Mar 27 at 22:54

chrischris

1255 bronze badges

share|improve this question

asked Mar 27 at 22:54

chrischris

1255 bronze badges

asked Mar 27 at 22:54

chrischris

1255 bronze badges

asked Mar 27 at 22:54

chrischris

1255 bronze badges

1 Answer
1

active

oldest

votes

0

You can pass a callback to the with function that filters the query.

$cat = $category->with(['events' => function ($q) 
 $q->where('approved', 1);
 ]
)->get();

share|improve this answer

answered Mar 27 at 23:01

Matt CMatt C

52133 silver badges66 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That worked to an extent except it is now listing all of my categories. I did some more playing with it and got this to work ``` $category->load(['events' => function ($query) $query->whereNotNull('approved'); ])->get(); ``` Thanks so much for pointing me in the right direction!
  
  – chris
  Mar 27 at 23:27
  
  

  
  
  
  

add a comment | 

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%2f55387698%2fhow-do-i-filter-the-eager-loaded-class%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

You can pass a callback to the with function that filters the query.

$cat = $category->with(['events' => function ($q) 
 $q->where('approved', 1);
 ]
)->get();

share|improve this answer

answered Mar 27 at 23:01

Matt CMatt C

52133 silver badges66 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That worked to an extent except it is now listing all of my categories. I did some more playing with it and got this to work ``` $category->load(['events' => function ($query) $query->whereNotNull('approved'); ])->get(); ``` Thanks so much for pointing me in the right direction!
  
  – chris
  Mar 27 at 23:27
  
  

  
  
  
  

add a comment | 

0

You can pass a callback to the with function that filters the query.

$cat = $category->with(['events' => function ($q) 
 $q->where('approved', 1);
 ]
)->get();

share|improve this answer

answered Mar 27 at 23:01

Matt CMatt C

52133 silver badges66 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  That worked to an extent except it is now listing all of my categories. I did some more playing with it and got this to work ``` $category->load(['events' => function ($query) $query->whereNotNull('approved'); ])->get(); ``` Thanks so much for pointing me in the right direction!
  
  – chris
  Mar 27 at 23:27
  
  

  
  
  
  

add a comment | 

You can pass a callback to the with function that filters the query.

$cat = $category->with(['events' => function ($q) 
 $q->where('approved', 1);
 ]
)->get();

share|improve this answer

answered Mar 27 at 23:01

Matt CMatt C

52133 silver badges66 bronze badges

$cat = $category->with(['events' => function ($q) 
 $q->where('approved', 1);
 ]
)->get();

share|improve this answer

answered Mar 27 at 23:01

Matt CMatt C

52133 silver badges66 bronze badges

answered Mar 27 at 23:01

Matt CMatt C

52133 silver badges66 bronze badges

answered Mar 27 at 23:01

Matt CMatt C

52133 silver badges66 bronze badges