안녕하세요!&nbsp;
Order와 OrderItem을 가져올 때 N+1, 페이징 처리와 더불어
OrderItem 데이터 컬럼을 기준으로 동적 정렬조건이
필요하다면 어떤식으로 처리해야 할까요?
&nbsp;

<span style="font-size: 12pt; font-family: Arial;" data-sheets-value="{&quot;1&quot;:2,&quot;2&quot;:&quot;안녕하세요. 님, 공식 서포터즈 David입니다.\n.\n\n.\n감사합니다.&quot;}" data-sheets-userformat="{&quot;2&quot;:1063747,&quot;3&quot;:{&quot;1&quot;:0},&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215},&quot;9&quot;:0,&quot;11&quot;:0,&quot;12&quot;:0,&quot;14&quot;:{&quot;1&quot;:2,&quot;2&quot;:0},&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:12,&quot;23&quot;:1}" data-sheets-textstyleruns="{&quot;1&quot;:0}{&quot;1&quot;:10,&quot;2&quot;:{&quot;2&quot;:{&quot;1&quot;:2,&quot;2&quot;:1136076},&quot;9&quot;:1}}{&quot;1&quot;:17}" data-sheets-hyperlinkruns="{&quot;1&quot;:10,&quot;2&quot;:&quot;https://www.inflearn.com/blogs/617&quot;}{&quot;1&quot;:17}">안녕하세요.&nbsp;김넋둘님, <a class="in-cell-link" href="https://www.inflearn.com/blogs/617" target="_blank" rel="noopener">공식 서포터즈</a> David입니다.
<span data-sheets-value="{&quot;1&quot;:2,&quot;2&quot;:&quot;안녕하세요. 님, 공식 서포터즈 David입니다.\n.\n\n.\n감사합니다.&quot;}" data-sheets-userformat="{&quot;2&quot;:1063747,&quot;3&quot;:{&quot;1&quot;:0},&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215},&quot;9&quot;:0,&quot;11&quot;:0,&quot;12&quot;:0,&quot;14&quot;:{&quot;1&quot;:2,&quot;2&quot;:0},&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:12,&quot;23&quot;:1}" data-sheets-textstyleruns="{&quot;1&quot;:0}{&quot;1&quot;:10,&quot;2&quot;:{&quot;2&quot;:{&quot;1&quot;:2,&quot;2&quot;:1136076},&quot;9&quot;:1}}{&quot;1&quot;:17}" data-sheets-hyperlinkruns="{&quot;1&quot;:10,&quot;2&quot;:&quot;https://www.inflearn.com/blogs/617&quot;}{&quot;1&quot;:17}">.
<span data-sheets-value="{&quot;1&quot;:2,&quot;2&quot;:&quot;안녕하세요. 님, 공식 서포터즈 David입니다.\n.\n\n.\n감사합니다.&quot;}" data-sheets-userformat="{&quot;2&quot;:1063747,&quot;3&quot;:{&quot;1&quot;:0},&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215},&quot;9&quot;:0,&quot;11&quot;:0,&quot;12&quot;:0,&quot;14&quot;:{&quot;1&quot;:2,&quot;2&quot;:0},&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:12,&quot;23&quot;:1}" data-sheets-textstyleruns="{&quot;1&quot;:0}{&quot;1&quot;:10,&quot;2&quot;:{&quot;2&quot;:{&quot;1&quot;:2,&quot;2&quot;:1136076},&quot;9&quot;:1}}{&quot;1&quot;:17}" data-sheets-hyperlinkruns="{&quot;1&quot;:10,&quot;2&quot;:&quot;https://www.inflearn.com/blogs/617&quot;}{&quot;1&quot;:17}">N+1은 fetch join으로, <span data-sheets-value="{&quot;1&quot;:2,&quot;2&quot;:&quot;안녕하세요. 님, 공식 서포터즈 David입니다.\n.\n\n.\n감사합니다.&quot;}" data-sheets-userformat="{&quot;2&quot;:1063747,&quot;3&quot;:{&quot;1&quot;:0},&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215},&quot;9&quot;:0,&quot;11&quot;:0,&quot;12&quot;:0,&quot;14&quot;:{&quot;1&quot;:2,&quot;2&quot;:0},&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:12,&quot;23&quot;:1}" data-sheets-textstyleruns="{&quot;1&quot;:0}{&quot;1&quot;:10,&quot;2&quot;:{&quot;2&quot;:{&quot;1&quot;:2,&quot;2&quot;:1136076},&quot;9&quot;:1}}{&quot;1&quot;:17}" data-sheets-hyperlinkruns="{&quot;1&quot;:10,&quot;2&quot;:&quot;https://www.inflearn.com/blogs/617&quot;}{&quot;1&quot;:17}">페이징은 Pageable으로, <span data-sheets-value="{&quot;1&quot;:2,&quot;2&quot;:&quot;안녕하세요. 님, 공식 서포터즈 David입니다.\n.\n\n.\n감사합니다.&quot;}" data-sheets-userformat="{&quot;2&quot;:1063747,&quot;3&quot;:{&quot;1&quot;:0},&quot;4&quot;:{&quot;1&quot;:2,&quot;2&quot;:16777215},&quot;9&quot;:0,&quot;11&quot;:0,&quot;12&quot;:0,&quot;14&quot;:{&quot;1&quot;:2,&quot;2&quot;:0},&quot;15&quot;:&quot;Arial&quot;,&quot;16&quot;:12,&quot;23&quot;:1}" data-sheets-textstyleruns="{&quot;1&quot;:0}{&quot;1&quot;:10,&quot;2&quot;:{&quot;2&quot;:{&quot;1&quot;:2,&quot;2&quot;:1136076},&quot;9&quot;:1}}{&quot;1&quot;:17}" data-sheets-hyperlinkruns="{&quot;1&quot;:10,&quot;2&quot;:&quot;https://www.inflearn.com/blogs/617&quot;}{&quot;1&quot;:17}">정렬은 fetch join하실 때 쿼리 내 order by를 적용하시면 될 것 같습니다. <a href="https://cheese10yun.github.io/jpa-fetch-paging/">https://cheese10yun.github.io/jpa-fetch-paging/</a> . 감사합니다.

인프런 커뮤니티 질문&답변

OneToMany 데이터 조회 시