sort in hasMany relationship

0

I have 2 model POST and Member , I want order by lastname from member

but its return with default sort

$post= POST::where('type','<>',0)

       ->with(['member'=>function($query){

        $query->orderBy('lastname','desc');

       }])->paginate(10);

Thank you in advance.

laravel laravel-5.6

share|improve this question

asked Nov 20 '18 at 11:40

Aa AaaAa Aaa

153

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  members must have been sorted based on what you have written, but not posts.
  
  – ako
  Nov 20 '18 at 11:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Aa Aaa i think your code is working perfect (i tried)
  
  – Jignesh Joisar
  Nov 20 '18 at 12:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @JigneshJoisar its not work for me
  
  – Aa Aaa
  Nov 20 '18 at 12:47
  

  
  
  
  

add a comment | 

0

I have 2 model POST and Member , I want order by lastname from member

but its return with default sort

$post= POST::where('type','<>',0)

       ->with(['member'=>function($query){

        $query->orderBy('lastname','desc');

       }])->paginate(10);

Thank you in advance.

laravel laravel-5.6

share|improve this question

asked Nov 20 '18 at 11:40

Aa AaaAa Aaa

153

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  members must have been sorted based on what you have written, but not posts.
  
  – ako
  Nov 20 '18 at 11:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Aa Aaa i think your code is working perfect (i tried)
  
  – Jignesh Joisar
  Nov 20 '18 at 12:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @JigneshJoisar its not work for me
  
  – Aa Aaa
  Nov 20 '18 at 12:47
  

  
  
  
  

add a comment | 

0

0

0

I have 2 model POST and Member , I want order by lastname from member

but its return with default sort

$post= POST::where('type','<>',0)

       ->with(['member'=>function($query){

        $query->orderBy('lastname','desc');

       }])->paginate(10);

Thank you in advance.

laravel laravel-5.6

share|improve this question

asked Nov 20 '18 at 11:40

Aa AaaAa Aaa

153

I have 2 model POST and Member , I want order by lastname from member

but its return with default sort

$post= POST::where('type','<>',0)

       ->with(['member'=>function($query){

        $query->orderBy('lastname','desc');

       }])->paginate(10);

Thank you in advance.

laravel laravel-5.6

laravel laravel-5.6

share|improve this question

asked Nov 20 '18 at 11:40

Aa AaaAa Aaa

153

share|improve this question

asked Nov 20 '18 at 11:40

Aa AaaAa Aaa

153

share|improve this question

share|improve this question

asked Nov 20 '18 at 11:40

Aa AaaAa Aaa

153

asked Nov 20 '18 at 11:40

Aa AaaAa Aaa

153

asked Nov 20 '18 at 11:40

Aa AaaAa Aaa

153

153

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  members must have been sorted based on what you have written, but not posts.
  
  – ako
  Nov 20 '18 at 11:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Aa Aaa i think your code is working perfect (i tried)
  
  – Jignesh Joisar
  Nov 20 '18 at 12:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @JigneshJoisar its not work for me
  
  – Aa Aaa
  Nov 20 '18 at 12:47
  

  
  
  
  

add a comment | 

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  members must have been sorted based on what you have written, but not posts.
  
  – ako
  Nov 20 '18 at 11:54
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @Aa Aaa i think your code is working perfect (i tried)
  
  – Jignesh Joisar
  Nov 20 '18 at 12:08
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  @JigneshJoisar its not work for me
  
  – Aa Aaa
  Nov 20 '18 at 12:47
  

  
  
  
  

members must have been sorted based on what you have written, but not posts.

– ako
Nov 20 '18 at 11:54

members must have been sorted based on what you have written, but not posts.

– ako
Nov 20 '18 at 11:54

@Aa Aaa i think your code is working perfect (i tried)

– Jignesh Joisar
Nov 20 '18 at 12:08

@Aa Aaa i think your code is working perfect (i tried)

– Jignesh Joisar
Nov 20 '18 at 12:08

@JigneshJoisar its not work for me

– Aa Aaa
Nov 20 '18 at 12:47

@JigneshJoisar its not work for me

– Aa Aaa
Nov 20 '18 at 12:47

add a comment | 

3 Answers
3

active

oldest

votes

0

You are collecting first 10 post with members

if you want data as members lastname ordered then the eloquent should be like this

 $members = Member::whereHas('Post' , function($q){

                $q->where('type','<>',0);

            })->orderBy('lastname','desc')

              ->paginate(10);

Note: i didn't run this in my pc, inform me if i wrote anything wrong. thanks

share|improve this answer

answered Nov 20 '18 at 11:55

Emtiaz ZahidEmtiaz Zahid

1,042516

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks I know this way but I want get Post order by member's lastname
  
  – Aa Aaa
  Nov 20 '18 at 12:43
  

  
  
  
  

add a comment | 

0

Try this

$post= POST::where('type','<>',0)

   ->with(['member'=>function($query){

    $query->latest('lastname')->first();

   }])->paginate(10);

share|improve this answer

answered Nov 20 '18 at 11:56

MD. Jubair MizanMD. Jubair Mizan

606511

add a comment | 

0

You should use join() or leftJoin():

$posts = POST::select('posts.*')

    ->join('members', 'members.id', '=', 'posts.member_id')

    ->where('posts.type','<>',0)

    ->orderByDesc('members.lastname')

    ->paginate(10);

share|improve this answer

answered Nov 20 '18 at 13:08

IndianCodingIndianCoding

1,044119

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
});


}
});

Thanks for contributing an answer to Stack Overflow!

• Please be sure to answer the question. Provide details and share your research!

But avoid …

• Asking for help, clarification, or responding to other answers.


• Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

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%2f53392236%2fsort-in-hasmany-relationship%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

3 Answers
3

active

oldest

votes

3 Answers
3

active

oldest

votes

active

oldest

votes

active

oldest

votes

0

You are collecting first 10 post with members

if you want data as members lastname ordered then the eloquent should be like this

 $members = Member::whereHas('Post' , function($q){

                $q->where('type','<>',0);

            })->orderBy('lastname','desc')

              ->paginate(10);

Note: i didn't run this in my pc, inform me if i wrote anything wrong. thanks

share|improve this answer

answered Nov 20 '18 at 11:55

Emtiaz ZahidEmtiaz Zahid

1,042516

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks I know this way but I want get Post order by member's lastname
  
  – Aa Aaa
  Nov 20 '18 at 12:43
  

  
  
  
  

add a comment | 

0

You are collecting first 10 post with members

if you want data as members lastname ordered then the eloquent should be like this

 $members = Member::whereHas('Post' , function($q){

                $q->where('type','<>',0);

            })->orderBy('lastname','desc')

              ->paginate(10);

Note: i didn't run this in my pc, inform me if i wrote anything wrong. thanks

share|improve this answer

answered Nov 20 '18 at 11:55

Emtiaz ZahidEmtiaz Zahid

1,042516

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks I know this way but I want get Post order by member's lastname
  
  – Aa Aaa
  Nov 20 '18 at 12:43
  

  
  
  
  

add a comment | 

0

0

0

You are collecting first 10 post with members

if you want data as members lastname ordered then the eloquent should be like this

 $members = Member::whereHas('Post' , function($q){

                $q->where('type','<>',0);

            })->orderBy('lastname','desc')

              ->paginate(10);

Note: i didn't run this in my pc, inform me if i wrote anything wrong. thanks

share|improve this answer

answered Nov 20 '18 at 11:55

Emtiaz ZahidEmtiaz Zahid

1,042516

You are collecting first 10 post with members

if you want data as members lastname ordered then the eloquent should be like this

 $members = Member::whereHas('Post' , function($q){

                $q->where('type','<>',0);

            })->orderBy('lastname','desc')

              ->paginate(10);

Note: i didn't run this in my pc, inform me if i wrote anything wrong. thanks

share|improve this answer

answered Nov 20 '18 at 11:55

Emtiaz ZahidEmtiaz Zahid

1,042516

share|improve this answer

share|improve this answer

answered Nov 20 '18 at 11:55

Emtiaz ZahidEmtiaz Zahid

1,042516

answered Nov 20 '18 at 11:55

Emtiaz ZahidEmtiaz Zahid

1,042516

answered Nov 20 '18 at 11:55

Emtiaz ZahidEmtiaz Zahid

1,042516

1,042516

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks I know this way but I want get Post order by member's lastname
  
  – Aa Aaa
  Nov 20 '18 at 12:43
  

  
  
  
  

add a comment | 

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  thanks I know this way but I want get Post order by member's lastname
  
  – Aa Aaa
  Nov 20 '18 at 12:43
  

  
  
  
  

thanks I know this way but I want get Post order by member's lastname

– Aa Aaa
Nov 20 '18 at 12:43

thanks I know this way but I want get Post order by member's lastname

– Aa Aaa
Nov 20 '18 at 12:43

add a comment | 

0

Try this

$post= POST::where('type','<>',0)

   ->with(['member'=>function($query){

    $query->latest('lastname')->first();

   }])->paginate(10);

share|improve this answer

answered Nov 20 '18 at 11:56

MD. Jubair MizanMD. Jubair Mizan

606511

add a comment | 

0

Try this

$post= POST::where('type','<>',0)

   ->with(['member'=>function($query){

    $query->latest('lastname')->first();

   }])->paginate(10);

share|improve this answer

answered Nov 20 '18 at 11:56

MD. Jubair MizanMD. Jubair Mizan

606511

add a comment | 

0

0

0

Try this

$post= POST::where('type','<>',0)

   ->with(['member'=>function($query){

    $query->latest('lastname')->first();

   }])->paginate(10);

share|improve this answer

answered Nov 20 '18 at 11:56

MD. Jubair MizanMD. Jubair Mizan

606511

Try this

$post= POST::where('type','<>',0)

   ->with(['member'=>function($query){

    $query->latest('lastname')->first();

   }])->paginate(10);

share|improve this answer

answered Nov 20 '18 at 11:56

MD. Jubair MizanMD. Jubair Mizan

606511

share|improve this answer

share|improve this answer

answered Nov 20 '18 at 11:56

MD. Jubair MizanMD. Jubair Mizan

606511

answered Nov 20 '18 at 11:56

MD. Jubair MizanMD. Jubair Mizan

606511

answered Nov 20 '18 at 11:56

MD. Jubair MizanMD. Jubair Mizan

606511

606511

add a comment | 

add a comment | 

0

You should use join() or leftJoin():

$posts = POST::select('posts.*')

    ->join('members', 'members.id', '=', 'posts.member_id')

    ->where('posts.type','<>',0)

    ->orderByDesc('members.lastname')

    ->paginate(10);

share|improve this answer

answered Nov 20 '18 at 13:08

IndianCodingIndianCoding

1,044119

add a comment | 

0

You should use join() or leftJoin():

$posts = POST::select('posts.*')

    ->join('members', 'members.id', '=', 'posts.member_id')

    ->where('posts.type','<>',0)

    ->orderByDesc('members.lastname')

    ->paginate(10);

share|improve this answer

answered Nov 20 '18 at 13:08

IndianCodingIndianCoding

1,044119

add a comment | 

0

0

0

You should use join() or leftJoin():

$posts = POST::select('posts.*')

    ->join('members', 'members.id', '=', 'posts.member_id')

    ->where('posts.type','<>',0)

    ->orderByDesc('members.lastname')

    ->paginate(10);

share|improve this answer

answered Nov 20 '18 at 13:08

IndianCodingIndianCoding

1,044119

You should use join() or leftJoin():

$posts = POST::select('posts.*')

    ->join('members', 'members.id', '=', 'posts.member_id')

    ->where('posts.type','<>',0)

    ->orderByDesc('members.lastname')

    ->paginate(10);

share|improve this answer

answered Nov 20 '18 at 13:08

IndianCodingIndianCoding

1,044119

share|improve this answer

share|improve this answer

answered Nov 20 '18 at 13:08

IndianCodingIndianCoding

1,044119

answered Nov 20 '18 at 13:08

IndianCodingIndianCoding

1,044119

answered Nov 20 '18 at 13:08

IndianCodingIndianCoding

1,044119

1,044119

add a comment | 

add a comment | 

Thanks for contributing an answer to Stack Overflow!

• Please be sure to answer the question. Provide details and share your research!

But avoid …

• Asking for help, clarification, or responding to other answers.


• Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

• Please be sure to answer the question. Provide details and share your research!

But avoid …

• Asking for help, clarification, or responding to other answers.


• Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

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%2f53392236%2fsort-in-hasmany-relationship%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

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

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

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

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

Name

Name

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

Name

Name

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

This page is only for reference, If you need detailed information, please check here