How to use @Where in Hibernate

by

Try something like:

@Column(name="POSTS_REF")
@Where(clause="state="PostPublished"")
private List<Posts> userPosts;

or 

@Column(name="POSTS_REF")
@Where(clause="PostPublished=true")
private List<Posts> userPosts;

depending on the status field type on your Post entity.

More Related Contents:

  1. Mapping many-to-many association table with extra column(s)
  2. How to generate Custom Id using hibernate while it must be primary key of table
  3. How does JPA orphanRemoval=true differ from the ON DELETE CASCADE DML clause
  4. JPA 2.0 many-to-many with extra column
  5. How to mix inheritance strategies with JPA annotations and Hibernate?
  6. Does the JPA specification allow references to non-primary key columns?
  7. Hibernate: comparing current & previous record
  8. Struggling to understand EntityManager proper use
  9. Hibernate problem – “Use of @OneToMany or @ManyToMany targeting an unmapped class”
  10. How to use the Java 8 LocalDateTime with JPA and Hibernate
  11. JPQL Constructor Expression – org.hibernate.hql.ast.QuerySyntaxException:Table is not mapped
  12. Hibernate throws org.hibernate.AnnotationException: No identifier specified for entity: com..domain.idea.MAE_MFEView
  13. What is referencedColumnName used for in JPA?
  14. Using JPA entities in JSF. Which is the best strategy to prevent LazyInitializationException?
  15. JPA/Hibernate remove entity sometimes not working
  16. Hibernate: How specify custom sequence generator class name using annotations?
  17. How to configure Spring to make JPA (Hibernate) and JDBC (JdbcTemplate or MyBatis) share the same transaction
  18. Deleted object would be re-saved by cascade (remove deleted object from associations)
  19. Invalidating JPA EntityManager session
  20. Hibernate ID Generator
  21. JPA Uppercase table names
  22. what is the right path to refer a jar file in jpa persistence.xml in a web app?
  23. JPA CriteriaBuilder – How to use “IN” comparison operator
  24. Hibernate/JPA ManyToOne vs OneToMany
  25. inverse=true in JPA annotations
  26. Persist java.time.Instant (JDK8) with JPA2/Hibernate
  27. In Spring with jpa/hibernate, how do I keep a session open to avoid lazy initialization exceptions?
  28. Should Hibernate be able to handle overlapping foreign keys?
  29. createEntityManager throws java.lang.NullPointerException at org.hibernate.engine.transaction.internal.jta.JtaStatusHelper.getStatus
  30. New object with HQL

Leave a Comment