I have two tables as mentioned below.

<class table="QUESTION" name="Question">
<id column="QUESTION_ID" length="10" name="questionId" type="integer">
<generator class="sequence">
<param name="sequence">QUESTION_ID_SEQ</param>
</generator>
</id>
<property column="IS_OBJECTIVE_TYPE" length="1" name="isObjectiveType" not-null="false" type="boolean" />
<property column="QUESTION_DESC" length="500" name="questionDesc" not-null="false" type="string" />
<set cascade="none" lazy="true" name="answersSet" order-by="ANSWER_ID asc">
<key>
<column name="QUESTION_ID" />
</key>
<one-to-many class="Answers" />
</set>
</class>

<class table="ANSWER" name="Answers">
<id column="ANSWER_ID" length="10" name="answerId" type="integer">
<generator class="sequence">
<param name="sequence">ANSWER_ID_SEQ</param>
</generator>
</id>
<property column="IS_OBJECTIVE_TYPE" length="1" name="isObjectiveType" not-null="false" type="boolean" />
<property column="ANSWER_DESC" length="500" name="answerDesc" not-null="false" type="string" />
</class>

I have more than one answer for the given question. here i want to fetch the questions along with the answers those are objective type.

Session session = this.getSessionFactory().getCurrentSession();
Criteria objCriteria = session.createCriteria(Question.class);
objCriteria.add(Restrictions.eq("isObjectiveType", Boolean.TRUE));
List<Question> questionList = (List<Question>) objCriteria.list();

Above list gives objective type question with all answers irrespective of "isObjectiveType" in ANSWER.
Here i want to filter the answers based on "isObjectiveType" in Question entity.

How to filter child records based on additional column other than foreign key reference.
Please help me on this

What is the datatype of isObjectiveType??

its Boolean. Based on that i want the child records.

You are not tracing your queries generated by hibernate?? If yes can you paste the query which is generated so that it is easier to know whats the problem is.

You put your Criteria Restriction directly on the Question class so your result is normal and expected!
Take a look at this, it will help you understand how to use Criteria API in your case:

http://docs.jboss.org/hibernate/core/3. ... sociations

Pls find the queries generated by hibernate
Hibernate: select this_.QUESTIONS_ID as QUESTIONS1_21_0_, this_.IS_OBJECTIVE_TYPE as IS2_21_0_, this_.QUESTION_DESC as QUESTION3_21_0_ from QUESTIONS this_ where this_.IS_OBJECTIVE_TYPE=?

overmeulen,
Parent table has nearly '6' one to many child relationship. they were getting the childs on need basis. Application had been built already and i am trying to customize the HBM file to do this. Will you please suggest any idea to solve my problem

Can you tell us exactly what is the SQL query you are trying to achieve? Which data you want to extract and with which conditions? It is not very clear right now given that you have the same field "IS_OBJECTIVE_TYPE" in both your objects.
By the way, which version of Hibernate are you using?

I am using Hibernate 3.2.

Actually i have two tables "Question" and "Answer". It has one to many set relationship based question_id (foreign key for "Answer" entity). As of now i can get questions along with their no of answers.
When i fetch the records from "Question" basedon on "Objective_Type" it gives the filtered records from "Question" entity with unfiltered(all irrespective of "Objective_Type" in Answer) records from "Answer" entity. So i wanted to have one more condition in set relationship for "Objective_Type".
Here i cant able to create criteria with filter expression to get the records since the application has been built already. they are getting the childs from the parent entity instead of seperate criteria/hql query.

Is it possible to use filter in set relation to filter the child records? if so what will be the scope of filter.

Hi,

Right now your query looks like this:

from Question as q where q.isObjectiveType = TRUE

If I understood what you want to achieve, you should create a query like this one:

from Question as q left join q.answersSet answers with answers.isObjectiveType = TRUE where q.isObjectiveType = TRUE

Yes. Correct i want to get details based on "isObjectiveType" from "Question" and "Answer" entity(like Questions.isObjectiveType = Answers.isObjectiveType).
Here the problem is the application already gone to production environment and they asked us to add "isObjectiveType" field and this question entity is used in many places accross application. Is it possible to achieve the same using configuring hbm files by defining set relation conditions or some filters.