Home » Questions » Computers [ Ask a new question ]

java - Do left outer join only if condition satisfies in JPA -

java - Do left outer join only if condition satisfies in JPA -

"I am new to JPA. I am trying to do a left outer join only if a condition is satisfied.
Ther is a query as below in my JPA repository. Here I would like to do A left outer join B with the where condition, only if a given flag toJoin is true in application:
select a.id, a.name from A left outer join B on A.id = B.aid where b.name=""some_name""
I am not sure, how will I accommodate the toJoin application flag in the above JPA query in my JPA repository.
Could anyone please help here? Thanks.





java mysql spring-boot jpa spring-data-jpa












ShareShare a link to this question Copy linkCC BY-SA 4.0




Follow
Follow this question to receive notifications











edited 1 min ago





Joy









asked 5 mins ago





JoyJoy

3,5481111 gold badges4040 silver badges8383 bronze badges"

Asked by: Guest | Views: 98
Total answers/comments: 0