title: Hibernate annotation @Where with parameter
body: <p>I currently have this class Product, annotated this way (I´m using soft delete): </p>
  
  <pre><code>@SQLDelete(sql = "UPDATE products SET active = '0' WHERE id_product = ? and last_modification_date = ?")
  @Where(clause = "active = '1'" )
  @Entity
  @Table(name = "products ")
  public class Product {
    .....
  }
  </code></pre>
  
  <p>What I want if to FILTER the beans (products), using the @Where clause, so that one user can only see the products from it own company. The company ID is in the session, and since the @SQLDelete receives parameters, I wanted to do something like:</p>
  
  <pre><code>@Where(clause = "active = '1' and id_company = ?" )
  </code></pre>
  
  <p>so that i can filter ALL the tables to fetch results according each user, without having to edit all the queries in the system. Is there any way to accomplish this?<br></p>
  
  <p>Any help will be very aprecciated. <br>Also, let me know if more info is needed to understand the problem.</p>