Spring Data jpa query with Join with where condition

Question

I have two tables

RoleMasterLink with userId and RoleId
RoleMaster with RoleId and FunctionalRole

I need to achive

Select rm.FunctionalRole from RoleMaster rm join RoleMasterLink rml on rml.RoleId = rm.RoleId where rml.userId='yesh'

User can have many roleIds, I need to get FunctionalRole based on RoleId

How to achive this with Spring Data Jpa, gone through many links but exactly couldn't get.

Return type will be List of Strings , say User ID has three RoleIds, we should match and get the Functional Roles. Looks like simple requirement but I am missing some annotations in model class. — yeswanth a
– yeswanth a, Commented Dec 17, 2017 at 14:31

Simon Martinelli · Accepted Answer · 2017-12-16 14:13:07Z

2

Simply add your query in a @Query annotation in your Repository interface:

@Query("Select rm.FunctionalRole from RoleMaster rm join RoleMasterLink rml on rml.RoleId = rm.RoleId where rml.userId= :userId")
String findFunctionalRole(String userId);

answered Dec 16, 2017 at 14:13

Simon Martinelli

36.6k6 gold badges62 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

yeswanth a Over a year ago

I tried same query , can you give code, like in RoleMasterLink and RoleMaster which annotations should I give to achive this, like join Column () and one-to-one and mapping by...

Simon Martinelli Over a year ago

Can you please post the classes RoleMaster and RoleMasterLink ?

Collectives™ on Stack Overflow

Spring Data jpa query with Join with where condition

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related