You have the EntityManager.find(Class entityClass, Object primaryKey) method to find a specific row with a primary key.

But how do I find a value in a column that just have unique values and is not a primary key?

Edit
Report