Question on creating criteria

ve1224 · **Joined:** Tue Jun 14, 2005 10:54 am **Posts:** 4

Hi,
I am trying to create a sql expression that looks like

SELECT qualValue FROM QUALIFIER_VALUES WHERE type_id IN (SELECT qualTypeId FROM FUNCTION WHERE function_id='?')

Criteria criteriaValues = session.createCriteria(QualifierValues.class);
Criteria criteriaTypes = criteriaValues.createCriteria("qualifierTypes");
Criteria criteriaFunctions = criteriaTypes.
add(Expression.eq("id", new Integer(arg_functionId)));

As you would notice it would give me back types whose id i supply in. How would i include the type_id in the criteria query.

Basilio · **Posted:** Tue Aug 16, 2005 7:22 pm

ve1224 wrote:

Hi,
I am trying to create a sql expression that looks like

SELECT qualValue FROM QUALIFIER_VALUES WHERE type_id IN (SELECT qualTypeId FROM FUNCTION WHERE function_id='?')

Criteria criteriaValues = session.createCriteria(QualifierValues.class);
Criteria criteriaTypes = criteriaValues.createCriteria("qualifierTypes");
Criteria criteriaFunctions = criteriaTypes.
add(Expression.eq("id", new Integer(arg_functionId)));

As you would notice it would give me back types whose id i supply in. How would i include the type_id in the criteria query.

just add:

Code:

criteriaTypes.add(Expression.eq("type_id", typeId)); //any other expressions can be used

you do not need to assign result of this call to anything. You will have what you need

Basilio · **Posted:** Tue Aug 16, 2005 7:32 pm

Quote:

just add:

Code:

criteriaTypes.add(Expression.eq("type_id", typeId)); //any other expressions can be used

you do not need to assign result of this call to anything. You will have what you need

Sorry, I missed part with SQL
Actually, your code already provides you same result as SQL above.

Also you can write something like that:

Code:

Criteria criteriaValues = session.createCriteria(QualifierValues.class); 
Criteria criteriaTypes = criteriaValues.createCriteria("qualifierTypes"); 

Criteria criteriaFunctions = session.createCriteria(Function.class)
add(Expression.eq("id", new Integer(arg_functionId)));
criteriaTypes.add(Expression.in("type_id", criteriaValues.list()));

But first one is faster