Issue
I have a requirement where I need to pass a global WHERE condition dynamically to all the queries?
We have data in the tables for multiple organizations. So, I need to pass ORG_ID = ? while retrieving data.
I don't want to write finder methods like findBy..AndOrgId(... Integer orgId). Is there a better way to do this? To apply a Global WHERE clause or a Predicate?
I receive this orgId as part of the request attribute in RestController. Since it is dynamic, I can't use the hibernate annotation @Where on the entity classes.
Solution
Spring Data (I assume you are using Spring Data based on your post tags) doesn't support query augmentation (at time of writing). There is a long standing request for that feature here that also describes some alternatives that others have tried.
Good luck!
Answered By - Paul Warren
Answer Checked By - Pedro (JavaFixing Volunteer)
