sort in hasMany relationship
up vote
0
down vote
favorite
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
asked Nov 20 at 11:40
Aa Aaa
153
add a comment |
up vote
0
down vote
favorite
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
asked Nov 20 at 11:40
Aa Aaa
153
membersmust have been sorted based on what you have written, but notposts.
– ako
Nov 20 at 11:54
@Aa Aaa i think your code is working perfect(i tried)
– Jignesh Joisar
Nov 20 at 12:08
@JigneshJoisar its not work for me
– Aa Aaa
Nov 20 at 12:47
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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
asked Nov 20 at 11:40
Aa 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
asked Nov 20 at 11:40
Aa Aaa
153
asked Nov 20 at 11:40
Aa Aaa
153
asked Nov 20 at 11:40
Aa Aaa
153
asked Nov 20 at 11:40
Aa Aaa
153
asked Nov 20 at 11:40
Aa Aaa
153
153
membersmust have been sorted based on what you have written, but notposts.
– ako
Nov 20 at 11:54
@Aa Aaa i think your code is working perfect(i tried)
– Jignesh Joisar
Nov 20 at 12:08
@JigneshJoisar its not work for me
– Aa Aaa
Nov 20 at 12:47
add a comment |
membersmust have been sorted based on what you have written, but notposts.
– ako
Nov 20 at 11:54
@Aa Aaa i think your code is working perfect(i tried)
– Jignesh Joisar
Nov 20 at 12:08
@JigneshJoisar its not work for me
– Aa Aaa
Nov 20 at 12:47
members must have been sorted based on what you have written, but not posts.– ako
Nov 20 at 11:54
members must have been sorted based on what you have written, but not posts.– ako
Nov 20 at 11:54
@Aa Aaa i think your code is working perfect
(i tried)– Jignesh Joisar
Nov 20 at 12:08
@Aa Aaa i think your code is working perfect
(i tried)– Jignesh Joisar
Nov 20 at 12:08
@JigneshJoisar its not work for me
– Aa Aaa
Nov 20 at 12:47
@JigneshJoisar its not work for me
– Aa Aaa
Nov 20 at 12:47
add a comment |
3 Answers
3
active
oldest
votes
up vote
0
down vote
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
answered Nov 20 at 11:55
Emtiaz Zahid
1,045516
thanks I know this way but I want get Post order by member's lastname
– Aa Aaa
Nov 20 at 12:43
add a comment |
up vote
0
down vote
Try this
$post= POST::where('type','<>',0)
->with(['member'=>function($query){
$query->latest('lastname')->first();
}])->paginate(10);
answered Nov 20 at 11:56
MD. Jubair Mizan
588411
add a comment |
up vote
0
down vote
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);
answered Nov 20 at 13:08
IndianCoding
7299
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',
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
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
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
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
answered Nov 20 at 11:55
Emtiaz Zahid
1,045516
thanks I know this way but I want get Post order by member's lastname
– Aa Aaa
Nov 20 at 12:43
add a comment |
up vote
0
down vote
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
answered Nov 20 at 11:55
Emtiaz Zahid
1,045516
thanks I know this way but I want get Post order by member's lastname
– Aa Aaa
Nov 20 at 12:43
add a comment |
up vote
0
down vote
up vote
0
down vote
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
answered Nov 20 at 11:55
Emtiaz Zahid
1,045516
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
answered Nov 20 at 11:55
Emtiaz Zahid
1,045516
answered Nov 20 at 11:55
Emtiaz Zahid
1,045516
answered Nov 20 at 11:55
Emtiaz Zahid
1,045516
answered Nov 20 at 11:55
Emtiaz Zahid
1,045516
1,045516
thanks I know this way but I want get Post order by member's lastname
– Aa Aaa
Nov 20 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 at 12:43
thanks I know this way but I want get Post order by member's lastname
– Aa Aaa
Nov 20 at 12:43
thanks I know this way but I want get Post order by member's lastname
– Aa Aaa
Nov 20 at 12:43
add a comment |
up vote
0
down vote
Try this
$post= POST::where('type','<>',0)
->with(['member'=>function($query){
$query->latest('lastname')->first();
}])->paginate(10);
answered Nov 20 at 11:56
MD. Jubair Mizan
588411
add a comment |
up vote
0
down vote
Try this
$post= POST::where('type','<>',0)
->with(['member'=>function($query){
$query->latest('lastname')->first();
}])->paginate(10);
answered Nov 20 at 11:56
MD. Jubair Mizan
588411
add a comment |
up vote
0
down vote
up vote
0
down vote
Try this
$post= POST::where('type','<>',0)
->with(['member'=>function($query){
$query->latest('lastname')->first();
}])->paginate(10);
answered Nov 20 at 11:56
MD. Jubair Mizan
588411
Try this
$post= POST::where('type','<>',0)
->with(['member'=>function($query){
$query->latest('lastname')->first();
}])->paginate(10);
answered Nov 20 at 11:56
MD. Jubair Mizan
588411
answered Nov 20 at 11:56
MD. Jubair Mizan
588411
answered Nov 20 at 11:56
MD. Jubair Mizan
588411
answered Nov 20 at 11:56
MD. Jubair Mizan
588411
588411
add a comment |
add a comment |
up vote
0
down vote
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);
answered Nov 20 at 13:08
IndianCoding
7299
add a comment |
up vote
0
down vote
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);
answered Nov 20 at 13:08
IndianCoding
7299
add a comment |
up vote
0
down vote
up vote
0
down vote
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);
answered Nov 20 at 13:08
IndianCoding
7299
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);
answered Nov 20 at 13:08
IndianCoding
7299
answered Nov 20 at 13:08
IndianCoding
7299
answered Nov 20 at 13:08
IndianCoding
7299
answered Nov 20 at 13:08
IndianCoding
7299
7299
add a comment |
add a comment |
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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
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
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
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
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
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
membersmust have been sorted based on what you have written, but notposts.– ako
Nov 20 at 11:54
@Aa Aaa i think your code is working perfect
(i tried)– Jignesh Joisar
Nov 20 at 12:08
@JigneshJoisar its not work for me
– Aa Aaa
Nov 20 at 12:47