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 at 1:27
Josh
267
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 at 1:27
Josh
267
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 at 1:27
Josh
267
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 at 1:27
Josh
267
asked Nov 20 at 1:27
Josh
267
asked Nov 20 at 1:27
Josh
267
asked Nov 20 at 1:27
Josh
267
asked Nov 20 at 1:27
Josh
267
267
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 at 1:35
TsaiKoga
42838
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 at 1:43
Please post that code
– TsaiKoga
Nov 20 at 1:53
public function user() { return $this->hasOne('AppUser'); }
– Josh
Nov 20 at 1:54
can I order by user name without joining?
– Josh
Nov 20 at 1:55
No, you need to join users
– TsaiKoga
Nov 20 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 at 22:36
Josh
267
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 at 1:35
TsaiKoga
42838
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 at 1:43
Please post that code
– TsaiKoga
Nov 20 at 1:53
public function user() { return $this->hasOne('AppUser'); }
– Josh
Nov 20 at 1:54
can I order by user name without joining?
– Josh
Nov 20 at 1:55
No, you need to join users
– TsaiKoga
Nov 20 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 at 1:35
TsaiKoga
42838
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 at 1:43
Please post that code
– TsaiKoga
Nov 20 at 1:53
public function user() { return $this->hasOne('AppUser'); }
– Josh
Nov 20 at 1:54
can I order by user name without joining?
– Josh
Nov 20 at 1:55
No, you need to join users
– TsaiKoga
Nov 20 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 at 1:35
TsaiKoga
42838
I think you can sort the results first, and then paginate
$sorted = Model::orderBy('name')->paginate(10);
answered Nov 20 at 1:35
TsaiKoga
42838
answered Nov 20 at 1:35
TsaiKoga
42838
answered Nov 20 at 1:35
TsaiKoga
42838
answered Nov 20 at 1:35
TsaiKoga
42838
42838
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 at 1:43
Please post that code
– TsaiKoga
Nov 20 at 1:53
public function user() { return $this->hasOne('AppUser'); }
– Josh
Nov 20 at 1:54
can I order by user name without joining?
– Josh
Nov 20 at 1:55
No, you need to join users
– TsaiKoga
Nov 20 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 at 1:43
Please post that code
– TsaiKoga
Nov 20 at 1:53
public function user() { return $this->hasOne('AppUser'); }
– Josh
Nov 20 at 1:54
can I order by user name without joining?
– Josh
Nov 20 at 1:55
No, you need to join users
– TsaiKoga
Nov 20 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 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 at 1:43
Please post that code
– TsaiKoga
Nov 20 at 1:53
Please post that code
– TsaiKoga
Nov 20 at 1:53
public function user() { return $this->hasOne('AppUser'); }
– Josh
Nov 20 at 1:54
public function user() { return $this->hasOne('AppUser'); }
– Josh
Nov 20 at 1:54
can I order by user name without joining?
– Josh
Nov 20 at 1:55
can I order by user name without joining?
– Josh
Nov 20 at 1:55
No, you need to join users
– TsaiKoga
Nov 20 at 1:56
No, you need to join users
– TsaiKoga
Nov 20 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 at 22:36
Josh
267
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 at 22:36
Josh
267
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 at 22:36
Josh
267
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 at 22:36
Josh
267
answered Nov 24 at 22:36
Josh
267
answered Nov 24 at 22:36
Josh
267
answered Nov 24 at 22:36
Josh
267
267
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.
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.
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
