Hi,
I am working on an application where most of the queries are complex and there where clause is dynamic based on the the search criteria. Some queries only involve equal comparison and i used query by example in that cases but in most of other cases other operators (>,<,Or,and) are used. In the second case i have to make a dynamic query myself by checking null in search critera and appending not null to my where clause. What i intend to ask is ,Can query by criteria and query by example can be used together. So i specify the operators using Expression API and queruy is build dynamically by using Example object?

Please help me asap

Regards,
Shoaib Akhtar

Hello,
Thanks michael for your answer, but probably you dont get my question right. I have read the documentation already. What i am asking is that can i use expressions and example at the same time for one query.Mean to say that i give an expression telling that where to use which operator and also give an Example. So that i tell that betwwen the two properties use between for some other i specify equality and for other > and give it an example so that hibernate makes dynamic where clause ignoring the criteria for null values.
Or is there is any way to tell Expression or Criteria APi to ignore null values in query.

Regards,
Shoaib Akhtar

Yes, you can. Why not just try it out?

Hello,
Thanks michael for your answer, but probably you dont get my question right. I have read the documentation already. What i am asking is that can i use expressions and example at the same time for one query.Mean to say that i give an expression telling that where to use which operator and also give an Example. So that i tell that betwwen the two properties use between for some other i specify equality and for other > and give it an example so that hibernate makes dynamic where clause ignoring the criteria for null values.
Or is there is any way to tell Expression or Criteria APi to ignore null values in query.

Regards,
Shoaib Akhtar