질문&답변
조회질문
바쁘신와중에도 답변 정말 감사드립니다. 말씀하신것으로 코드를 짜봤는데 원하는 데이터는 나오지만 크로스 조인이 나서 이렇게 짜는 것이 맞는지 의문이 들어 여쭤보고싶습니다. 검색조건은 위에서 말씀드린 country와 language에서 language와 hopeLanguage로 변경하였습니다. Hibernate: select distinct user3_.id as col_0_0_, user3_.image_url as col_1_0_, user3_.content as col_2_0_, user3_.reg_date as col_3_0_, user3_.views as col_4_0_, (select count(tofollows6_.user_to_id) from follow tofollows6_ where user3_.id = tofollows6_.user_to_id) as col_5_0_ from user_language userlangua0_ cross join user_hope_language userhopela1_ inner join language language2_ on userlangua0_.language_id=language2_.id inner join user user3_ on userlangua0_.user_id=user3_.id inner join user user4_ on userhopela1_.user_id=user4_.id inner join language language5_ on userhopela1_.hope_language_id=language5_.id where user3_.id=user4_.id order by user3_.reg_date desc QUser user2 = new QUser( "user2" ) ; QLanguage language2 = new QLanguage( "language2" ) ; @Override public List usersList (UserSearch userSearch , String school) { List usersList = queryFactory .select(Projections. constructor (UsersDto. class, user . id , user . imageUrl , user . content , user . regDate , user . views , user . toFollows .size())).distinct().from( userLanguage , userHopeLanguage ) .join( userLanguage . language , language ) .join( userLanguage . user , user ) .join( userHopeLanguage . user , user2 ) .join( userHopeLanguage . hopeLanguage , language2 ) .where( hopeLanguageEq(userSearch.getHopeLanguage()) , languageEq(userSearch.getLanguage()) , nameEq(userSearch.getName()) , schoolEq(school) , user . id .eq( user2 . id ) ).orderBy(searchOrder(userSearch.getOrder())) .fetch() ; return usersList ; }
- 좋아요수
- 0
- 댓글수
- 4
- 조회수
- 316