Api-platform order for children
I just begin to use api-platform to GET some entities and all their children.
There is a self-join here, SQL looks like
entity e0_
LEFT JOIN
entity e1_ ON e0_.id = e1_.parent_id
I found the result records are sorted by id ORDER BY e0_.id ASC, while their children are not sorted.
My question is how to sort their children also ORDER BY e0_.id ASC, e1_.id ASC
I viewed the document, seems not mentioned.
https://api-platform.com/docs/core/default-order
thanks
sorting children api-platform.com
asked Nov 26 '18 at 4:07
BingbingBingbing
31
add a comment |
I just begin to use api-platform to GET some entities and all their children.
There is a self-join here, SQL looks like
entity e0_
LEFT JOIN
entity e1_ ON e0_.id = e1_.parent_id
I found the result records are sorted by id ORDER BY e0_.id ASC, while their children are not sorted.
My question is how to sort their children also ORDER BY e0_.id ASC, e1_.id ASC
I viewed the document, seems not mentioned.
https://api-platform.com/docs/core/default-order
thanks
sorting children api-platform.com
asked Nov 26 '18 at 4:07
BingbingBingbing
31
add a comment |
I just begin to use api-platform to GET some entities and all their children.
There is a self-join here, SQL looks like
entity e0_
LEFT JOIN
entity e1_ ON e0_.id = e1_.parent_id
I found the result records are sorted by id ORDER BY e0_.id ASC, while their children are not sorted.
My question is how to sort their children also ORDER BY e0_.id ASC, e1_.id ASC
I viewed the document, seems not mentioned.
https://api-platform.com/docs/core/default-order
thanks
sorting children api-platform.com
asked Nov 26 '18 at 4:07
BingbingBingbing
31
I just begin to use api-platform to GET some entities and all their children.
There is a self-join here, SQL looks like
entity e0_
LEFT JOIN
entity e1_ ON e0_.id = e1_.parent_id
I found the result records are sorted by id ORDER BY e0_.id ASC, while their children are not sorted.
My question is how to sort their children also ORDER BY e0_.id ASC, e1_.id ASC
I viewed the document, seems not mentioned.
https://api-platform.com/docs/core/default-order
thanks
sorting children api-platform.com
sorting children api-platform.com
asked Nov 26 '18 at 4:07
BingbingBingbing
31
asked Nov 26 '18 at 4:07
BingbingBingbing
31
asked Nov 26 '18 at 4:07
BingbingBingbing
31
asked Nov 26 '18 at 4:07
BingbingBingbing
31
asked Nov 26 '18 at 4:07
BingbingBingbing
31
31
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Default order in ORM:
https://www.doctrine-project.org/projects/doctrine-orm/en/2.6/tutorials/ordered-associations.html
Default order in API platform:
* @ApiResource(attributes={"order"={"related.id": "ASC"}})
Order by query param in API platform:
https://api-platform.com/docs/core/filters/#filtering-on-nested-properties
answered Nov 28 '18 at 6:14
GonZOOGonZOO
7613
Thanks a lot! it works! By the way, another case is that children only exist when a parameter like group=hierarchy, if group=read, no children. Is there any way that I can define in api platform yaml file like if group=hierarchy, then order: ['id']; if group=read, then order: ['id', 'related.id'] ?
– Bingbing
Dec 5 '18 at 3:19
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%2f53474659%2fapi-platform-order-for-children%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Default order in ORM:
https://www.doctrine-project.org/projects/doctrine-orm/en/2.6/tutorials/ordered-associations.html
Default order in API platform:
* @ApiResource(attributes={"order"={"related.id": "ASC"}})
Order by query param in API platform:
https://api-platform.com/docs/core/filters/#filtering-on-nested-properties
answered Nov 28 '18 at 6:14
GonZOOGonZOO
7613
Thanks a lot! it works! By the way, another case is that children only exist when a parameter like group=hierarchy, if group=read, no children. Is there any way that I can define in api platform yaml file like if group=hierarchy, then order: ['id']; if group=read, then order: ['id', 'related.id'] ?
– Bingbing
Dec 5 '18 at 3:19
add a comment |
Default order in ORM:
https://www.doctrine-project.org/projects/doctrine-orm/en/2.6/tutorials/ordered-associations.html
Default order in API platform:
* @ApiResource(attributes={"order"={"related.id": "ASC"}})
Order by query param in API platform:
https://api-platform.com/docs/core/filters/#filtering-on-nested-properties
answered Nov 28 '18 at 6:14
GonZOOGonZOO
7613
Thanks a lot! it works! By the way, another case is that children only exist when a parameter like group=hierarchy, if group=read, no children. Is there any way that I can define in api platform yaml file like if group=hierarchy, then order: ['id']; if group=read, then order: ['id', 'related.id'] ?
– Bingbing
Dec 5 '18 at 3:19
add a comment |
Default order in ORM:
https://www.doctrine-project.org/projects/doctrine-orm/en/2.6/tutorials/ordered-associations.html
Default order in API platform:
* @ApiResource(attributes={"order"={"related.id": "ASC"}})
Order by query param in API platform:
https://api-platform.com/docs/core/filters/#filtering-on-nested-properties
answered Nov 28 '18 at 6:14
GonZOOGonZOO
7613
Default order in ORM:
https://www.doctrine-project.org/projects/doctrine-orm/en/2.6/tutorials/ordered-associations.html
Default order in API platform:
* @ApiResource(attributes={"order"={"related.id": "ASC"}})
Order by query param in API platform:
https://api-platform.com/docs/core/filters/#filtering-on-nested-properties
answered Nov 28 '18 at 6:14
GonZOOGonZOO
7613
answered Nov 28 '18 at 6:14
GonZOOGonZOO
7613
answered Nov 28 '18 at 6:14
GonZOOGonZOO
7613
answered Nov 28 '18 at 6:14
GonZOOGonZOO
7613
7613
Thanks a lot! it works! By the way, another case is that children only exist when a parameter like group=hierarchy, if group=read, no children. Is there any way that I can define in api platform yaml file like if group=hierarchy, then order: ['id']; if group=read, then order: ['id', 'related.id'] ?
– Bingbing
Dec 5 '18 at 3:19
add a comment |
Thanks a lot! it works! By the way, another case is that children only exist when a parameter like group=hierarchy, if group=read, no children. Is there any way that I can define in api platform yaml file like if group=hierarchy, then order: ['id']; if group=read, then order: ['id', 'related.id'] ?
– Bingbing
Dec 5 '18 at 3:19
Thanks a lot! it works! By the way, another case is that children only exist when a parameter like group=hierarchy, if group=read, no children. Is there any way that I can define in api platform yaml file like if group=hierarchy, then order: ['id']; if group=read, then order: ['id', 'related.id'] ?
– Bingbing
Dec 5 '18 at 3:19
Thanks a lot! it works! By the way, another case is that children only exist when a parameter like group=hierarchy, if group=read, no children. Is there any way that I can define in api platform yaml file like if group=hierarchy, then order: ['id']; if group=read, then order: ['id', 'related.id'] ?
– Bingbing
Dec 5 '18 at 3:19
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%2f53474659%2fapi-platform-order-for-children%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
