How to paginate and sort results in Laravel?
I need to paginate the results and sort them using sortBy(), without losing the pagination links. I also need to use a resource to return the results.
$sorted = Model::paginate(10)->sortBy('name');
$results = AppHttpResourcesMyResource::collection($sorted);
Doing this breaks the pagination links (I get only the data part).
$paginated = Model::paginate(10);
$results = AppHttpResourcesMyResource::collection($paginated);
return $results->sortBy('name');
This also doesn't work.
Any ideas?
laravel laravel-5
asked Nov 20 '18 at 1:27
JoshJosh
268
add a comment |
I need to paginate the results and sort them using sortBy(), without losing the pagination links. I also need to use a resource to return the results.
$sorted = Model::paginate(10)->sortBy('name');
$results = AppHttpResourcesMyResource::collection($sorted);
Doing this breaks the pagination links (I get only the data part).
$paginated = Model::paginate(10);
$results = AppHttpResourcesMyResource::collection($paginated);
return $results->sortBy('name');
This also doesn't work.
Any ideas?
laravel laravel-5
asked Nov 20 '18 at 1:27
JoshJosh
268
add a comment |
I need to paginate the results and sort them using sortBy(), without losing the pagination links. I also need to use a resource to return the results.
$sorted = Model::paginate(10)->sortBy('name');
$results = AppHttpResourcesMyResource::collection($sorted);
Doing this breaks the pagination links (I get only the data part).
$paginated = Model::paginate(10);
$results = AppHttpResourcesMyResource::collection($paginated);
return $results->sortBy('name');
This also doesn't work.
Any ideas?
laravel laravel-5
asked Nov 20 '18 at 1:27
JoshJosh
268
I need to paginate the results and sort them using sortBy(), without losing the pagination links. I also need to use a resource to return the results.
$sorted = Model::paginate(10)->sortBy('name');
$results = AppHttpResourcesMyResource::collection($sorted);
Doing this breaks the pagination links (I get only the data part).
$paginated = Model::paginate(10);
$results = AppHttpResourcesMyResource::collection($paginated);
return $results->sortBy('name');
This also doesn't work.
Any ideas?
laravel laravel-5
laravel laravel-5
asked Nov 20 '18 at 1:27
JoshJosh
268
asked Nov 20 '18 at 1:27
JoshJosh
268
asked Nov 20 '18 at 1:27
JoshJosh
268
asked Nov 20 '18 at 1:27
JoshJosh
268
asked Nov 20 '18 at 1:27
JoshJosh
268
268
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
I think you can sort the results first, and then paginate
$sorted = Model::orderBy('name')->paginate(10);
answered Nov 20 '18 at 1:35
TsaiKogaTsaiKoga
43838
But I have a hasOne relationship with the column I want to sort. I tried doing orderBy(‘user.name’) but it doesn’t work.
– Josh
Nov 20 '18 at 1:43
Please post that code
– TsaiKoga
Nov 20 '18 at 1:53
public function user() { return $this->hasOne('AppUser'); }
– Josh
Nov 20 '18 at 1:54
can I order by user name without joining?
– Josh
Nov 20 '18 at 1:55
No, you need to join users
– TsaiKoga
Nov 20 '18 at 1:56
|
show 6 more comments
I've solved the problem with this solution:
$sorted = Model::get()
->sortBy('example_function') //appended attribute
->pluck('id')
->toArray();
$orderedIds = implode(',', $sorted);
$result = DB::table('model')
->orderByRaw(DB::raw("FIELD(id, ".$orderedIds." )"))
->paginate(10);
I've appended example_function attribute to the model, to be used by sortBy. With this solution I was able to use orderBy to order by an appended attribute of the model. And also I was able to use pagination.
answered Nov 24 '18 at 22:36
JoshJosh
268
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
});
}
});
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%2f53384956%2fhow-to-paginate-and-sort-results-in-laravel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
I think you can sort the results first, and then paginate
$sorted = Model::orderBy('name')->paginate(10);
answered Nov 20 '18 at 1:35
TsaiKogaTsaiKoga
43838
But I have a hasOne relationship with the column I want to sort. I tried doing orderBy(‘user.name’) but it doesn’t work.
– Josh
Nov 20 '18 at 1:43
Please post that code
– TsaiKoga
Nov 20 '18 at 1:53
public function user() { return $this->hasOne('AppUser'); }
– Josh
Nov 20 '18 at 1:54
can I order by user name without joining?
– Josh
Nov 20 '18 at 1:55
No, you need to join users
– TsaiKoga
Nov 20 '18 at 1:56
|
show 6 more comments
I think you can sort the results first, and then paginate
$sorted = Model::orderBy('name')->paginate(10);
answered Nov 20 '18 at 1:35
TsaiKogaTsaiKoga
43838
But I have a hasOne relationship with the column I want to sort. I tried doing orderBy(‘user.name’) but it doesn’t work.
– Josh
Nov 20 '18 at 1:43
Please post that code
– TsaiKoga
Nov 20 '18 at 1:53
public function user() { return $this->hasOne('AppUser'); }
– Josh
Nov 20 '18 at 1:54
can I order by user name without joining?
– Josh
Nov 20 '18 at 1:55
No, you need to join users
– TsaiKoga
Nov 20 '18 at 1:56
|
show 6 more comments
I think you can sort the results first, and then paginate
$sorted = Model::orderBy('name')->paginate(10);
answered Nov 20 '18 at 1:35
TsaiKogaTsaiKoga
43838
I think you can sort the results first, and then paginate
$sorted = Model::orderBy('name')->paginate(10);
answered Nov 20 '18 at 1:35
TsaiKogaTsaiKoga
43838
answered Nov 20 '18 at 1:35
TsaiKogaTsaiKoga
43838
answered Nov 20 '18 at 1:35
TsaiKogaTsaiKoga
43838
answered Nov 20 '18 at 1:35
TsaiKogaTsaiKoga
43838
43838
But I have a hasOne relationship with the column I want to sort. I tried doing orderBy(‘user.name’) but it doesn’t work.
– Josh
Nov 20 '18 at 1:43
Please post that code
– TsaiKoga
Nov 20 '18 at 1:53
public function user() { return $this->hasOne('AppUser'); }
– Josh
Nov 20 '18 at 1:54
can I order by user name without joining?
– Josh
Nov 20 '18 at 1:55
No, you need to join users
– TsaiKoga
Nov 20 '18 at 1:56
|
show 6 more comments
But I have a hasOne relationship with the column I want to sort. I tried doing orderBy(‘user.name’) but it doesn’t work.
– Josh
Nov 20 '18 at 1:43
Please post that code
– TsaiKoga
Nov 20 '18 at 1:53
public function user() { return $this->hasOne('AppUser'); }
– Josh
Nov 20 '18 at 1:54
can I order by user name without joining?
– Josh
Nov 20 '18 at 1:55
No, you need to join users
– TsaiKoga
Nov 20 '18 at 1:56
But I have a hasOne relationship with the column I want to sort. I tried doing orderBy(‘user.name’) but it doesn’t work.
– Josh
Nov 20 '18 at 1:43
But I have a hasOne relationship with the column I want to sort. I tried doing orderBy(‘user.name’) but it doesn’t work.
– Josh
Nov 20 '18 at 1:43
Please post that code
– TsaiKoga
Nov 20 '18 at 1:53
Please post that code
– TsaiKoga
Nov 20 '18 at 1:53
public function user() { return $this->hasOne('AppUser'); }
– Josh
Nov 20 '18 at 1:54
public function user() { return $this->hasOne('AppUser'); }
– Josh
Nov 20 '18 at 1:54
can I order by user name without joining?
– Josh
Nov 20 '18 at 1:55
can I order by user name without joining?
– Josh
Nov 20 '18 at 1:55
No, you need to join users
– TsaiKoga
Nov 20 '18 at 1:56
No, you need to join users
– TsaiKoga
Nov 20 '18 at 1:56
|
show 6 more comments
I've solved the problem with this solution:
$sorted = Model::get()
->sortBy('example_function') //appended attribute
->pluck('id')
->toArray();
$orderedIds = implode(',', $sorted);
$result = DB::table('model')
->orderByRaw(DB::raw("FIELD(id, ".$orderedIds." )"))
->paginate(10);
I've appended example_function attribute to the model, to be used by sortBy. With this solution I was able to use orderBy to order by an appended attribute of the model. And also I was able to use pagination.
answered Nov 24 '18 at 22:36
JoshJosh
268
add a comment |
I've solved the problem with this solution:
$sorted = Model::get()
->sortBy('example_function') //appended attribute
->pluck('id')
->toArray();
$orderedIds = implode(',', $sorted);
$result = DB::table('model')
->orderByRaw(DB::raw("FIELD(id, ".$orderedIds." )"))
->paginate(10);
I've appended example_function attribute to the model, to be used by sortBy. With this solution I was able to use orderBy to order by an appended attribute of the model. And also I was able to use pagination.
answered Nov 24 '18 at 22:36
JoshJosh
268
add a comment |
I've solved the problem with this solution:
$sorted = Model::get()
->sortBy('example_function') //appended attribute
->pluck('id')
->toArray();
$orderedIds = implode(',', $sorted);
$result = DB::table('model')
->orderByRaw(DB::raw("FIELD(id, ".$orderedIds." )"))
->paginate(10);
I've appended example_function attribute to the model, to be used by sortBy. With this solution I was able to use orderBy to order by an appended attribute of the model. And also I was able to use pagination.
answered Nov 24 '18 at 22:36
JoshJosh
268
I've solved the problem with this solution:
$sorted = Model::get()
->sortBy('example_function') //appended attribute
->pluck('id')
->toArray();
$orderedIds = implode(',', $sorted);
$result = DB::table('model')
->orderByRaw(DB::raw("FIELD(id, ".$orderedIds." )"))
->paginate(10);
I've appended example_function attribute to the model, to be used by sortBy. With this solution I was able to use orderBy to order by an appended attribute of the model. And also I was able to use pagination.
answered Nov 24 '18 at 22:36
JoshJosh
268
answered Nov 24 '18 at 22:36
JoshJosh
268
answered Nov 24 '18 at 22:36
JoshJosh
268
answered Nov 24 '18 at 22:36
JoshJosh
268
268
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.
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%2f53384956%2fhow-to-paginate-and-sort-results-in-laravel%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
