Styjun

Can I use my laptop, which says 240V, in the USA?

Why is it so slow when assigning a concatenated string to a variable in python?

Make all the squares explode

Why does TypeScript pack a Class in an IIFE?

How to make a language evolve quickly?

What is the significance of 4200 BCE in context of farming replacing foraging in Europe?

Understanding basic photoresistor circuit

Can I do brevets (long distance rides) on my hybrid bike? If yes, how to start?

How could we transfer large amounts of energy sourced in space to Earth?

Is Simic Ascendancy triggered by Awakening of Vitu-Ghazi?

Can the sorting of a list be verified without comparing neighbors?

What is the best way for a skeleton to impersonate human without using magic?

What can cause a never-frozen indoor copper drain pipe to crack?

Why was this sacrifice sufficient?

How do I tell my supervisor that he is choosing poor replacements for me while I am on maternity leave?

Is a diamond sword feasible?

International Code of Ethics for order of co-authors in research papers

Is a vertical stabiliser needed for straight line flight in a glider?

When do you stop "pushing" a book?

How can a Lich look like a human without magic?

How to slow yourself down (for playing nice with others)

Would an 8% reduction in drag outweigh the weight addition from this custom CFD-tested winglet?

Why in a Ethernet LAN, a packet sniffer can obtain all packets sent over the LAN?

As programers say: Strive to be lazy

How to write correct query to get not deleted rows?

Detecting request type in PHP (GET, POST, PUT or DELETE)Convert HTML + CSS to PDF with PHP?Secure hash and salt for PHP passwordsHow do I get PHP errors to display?How do I get a YouTube video thumbnail from the YouTube API?Reference — What does this symbol mean in PHP?How does PHP 'foreach' actually work?How to cascade on softdeletes in Laravel4?Migration: Cannot add foreign key constraint in laravelHow can I use soft deleted with relation

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have users table and I use softDeletes() in my table. Also I have candidates table where have foreign key (user_id) to users table.

Generaly how I can get candidates which users is not deleted?

Here my code for get candidates with not deleted users:

$candidates = Candidate::all();
$activeCandidates = [];
foreach ($candidates as $candidate) 
 if($candidate->user) 
 $activeCandidates[] = $candidate;
 

Can be solved my problem without looping with subquery?

php laravel eloquent

share|improve this question

edited Mar 23 at 12:51

Jignesh Joisar

3,19021327

asked Mar 23 at 11:15

Andreas HunterAndreas Hunter

783519

add a comment | 

0

I have users table and I use softDeletes() in my table. Also I have candidates table where have foreign key (user_id) to users table.

Generaly how I can get candidates which users is not deleted?

Here my code for get candidates with not deleted users:

$candidates = Candidate::all();
$activeCandidates = [];
foreach ($candidates as $candidate) 
 if($candidate->user) 
 $activeCandidates[] = $candidate;
 

Can be solved my problem without looping with subquery?

php laravel eloquent

share|improve this question

edited Mar 23 at 12:51

Jignesh Joisar

3,19021327

asked Mar 23 at 11:15

Andreas HunterAndreas Hunter

783519

add a comment | 

I have users table and I use softDeletes() in my table. Also I have candidates table where have foreign key (user_id) to users table.

Generaly how I can get candidates which users is not deleted?

Here my code for get candidates with not deleted users:

$candidates = Candidate::all();
$activeCandidates = [];
foreach ($candidates as $candidate) 
 if($candidate->user) 
 $activeCandidates[] = $candidate;
 

Can be solved my problem without looping with subquery?

php laravel eloquent

share|improve this question

edited Mar 23 at 12:51

Jignesh Joisar

3,19021327

asked Mar 23 at 11:15

Andreas HunterAndreas Hunter

783519

$candidates = Candidate::all();
$activeCandidates = [];
foreach ($candidates as $candidate) 
 if($candidate->user) 
 $activeCandidates[] = $candidate;
 

share|improve this question

edited Mar 23 at 12:51

Jignesh Joisar

3,19021327

asked Mar 23 at 11:15

Andreas HunterAndreas Hunter

783519

share|improve this question

edited Mar 23 at 12:51

Jignesh Joisar

3,19021327

asked Mar 23 at 11:15

Andreas HunterAndreas Hunter

783519

edited Mar 23 at 12:51

Jignesh Joisar

3,19021327

edited Mar 23 at 12:51

Jignesh Joisar

3,19021327

asked Mar 23 at 11:15

Andreas HunterAndreas Hunter

783519

asked Mar 23 at 11:15

Andreas HunterAndreas Hunter

783519

1 Answer
1

active

oldest

votes

2

has() is to filter the selecting model based on a relationship. So, it acts very similarly to a normal WHERE condition. If you just use has('relation') that means you only want to get the models that have at least one related model in this relation.

$candidates = Candidate::has('user')->get();

share|improve this answer

edited Mar 23 at 16:33

Md.Sukel Ali

1,74621221

answered Mar 23 at 11:31

venkatachalapathyvenkatachalapathy

364

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%2f55313121%2fhow-to-write-correct-query-to-get-not-deleted-rows%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

2

has() is to filter the selecting model based on a relationship. So, it acts very similarly to a normal WHERE condition. If you just use has('relation') that means you only want to get the models that have at least one related model in this relation.

$candidates = Candidate::has('user')->get();

share|improve this answer

edited Mar 23 at 16:33

Md.Sukel Ali

1,74621221

answered Mar 23 at 11:31

venkatachalapathyvenkatachalapathy

364

add a comment | 

2

has() is to filter the selecting model based on a relationship. So, it acts very similarly to a normal WHERE condition. If you just use has('relation') that means you only want to get the models that have at least one related model in this relation.

$candidates = Candidate::has('user')->get();

share|improve this answer

edited Mar 23 at 16:33

Md.Sukel Ali

1,74621221

answered Mar 23 at 11:31

venkatachalapathyvenkatachalapathy

364

add a comment | 

has() is to filter the selecting model based on a relationship. So, it acts very similarly to a normal WHERE condition. If you just use has('relation') that means you only want to get the models that have at least one related model in this relation.

$candidates = Candidate::has('user')->get();

share|improve this answer

edited Mar 23 at 16:33

Md.Sukel Ali

1,74621221

answered Mar 23 at 11:31

venkatachalapathyvenkatachalapathy

364

$candidates = Candidate::has('user')->get();

share|improve this answer

edited Mar 23 at 16:33

Md.Sukel Ali

1,74621221

answered Mar 23 at 11:31

venkatachalapathyvenkatachalapathy

364

edited Mar 23 at 16:33

Md.Sukel Ali

1,74621221

edited Mar 23 at 16:33

Md.Sukel Ali

1,74621221

answered Mar 23 at 11:31

venkatachalapathyvenkatachalapathy

364

answered Mar 23 at 11:31

venkatachalapathyvenkatachalapathy

364