0 Replies Latest reply on Nov 11, 2008 6:56 AM by alex rozario

    SQL Query for Collection object [OneToMany]

    alex rozario Newbie

      Hi every one

      I have three tables Post, Reply and Abuse

      One Post may have more than one reply.
      Post table and Reply tables have OneToMany relationship.
      So when we fetch any Post from DB it also fetches its replies.

      If any one the reply is abused by users. It will be saved in Abuse table

      Here my problem is,
      Now, I need to hide those abused reply from my replies collection.But I can't hide that particular reply, though it is coming from collection.

      How to leave that reply through sql where condition?
      Is it possible to do through annotation?
      Is there any other way to achieve this?