Hibernate "Like" expressions on two sides Criteria

Question

I'd like to use criteria and create something like this but with hibernate criterias:

WHERE concat(X, Y) like '%Some Value%'

I don't want to do it using query concatenation, but using Restrictions because I am making a dynamic library that gets the left and right side of the like operator? Am I clear? Please if not ask me to give more clarification.

Thank you!

[This SO post](http://stackoverflow.com/questions/11328403/implement-sql-like-in-criteria-hibernate) recommends not using a Criteria object. — Tim Biegeleisen, Aug 04 '15 at 08:22
.add( Restrictions.like("name", "%"+yourValue+"%") ) is not enough? — bryce, Aug 04 '15 at 08:25
@bryce what I want is that the "name" is a concatenation, not a column property. — Mohammed R. El-Khoudary, Aug 04 '15 at 08:27
@TimBiegeleisen you're right, thank you, but unfortunately at the current time I can't change. Query would make it much easier for me in many other aspects. — Mohammed R. El-Khoudary, Aug 04 '15 at 08:28

score 1 · Answer 1 · edited May 23 '17 at 12:08

1

Hope it may works.

Criteria crit = session.createCriteria(Table.class);
crit.add(Restrictions.ilike("param1 || param2", "%" + dniWithLetter + "%"));

If the above code not working, please go through the following link.

Can we concatenate two properties in Hibernate HQL query?

edited May 23 '17 at 12:08

Community

1
1

answered Jul 26 '16 at 03:23

AppHouze

206
3
10

hmrojas.p · Answer 2 · 2015-08-05T17:52:34.000

I think that the best solution for your problem is the following

...
Object[] params = {objX, objY, someValue};
Type[] typeOfParams = {Hibernate.STRING, Hibernate.STRING, Hibernate.STRING};
Criteria crit = session.createCriteria(Table.class);
crit.add(Restrictions.sqlRestriction("concat(?, ?) like '%?%'", params, typeOfParams));
...

When you use Restrictions.sqlRestriction, you can build a complex query with multiple parameters, you just have to set the parameters and type of each parameter, this is done with params array and typeOfparams array.

I hope this information helps you.

Good luck.

Hibernate "Like" expressions on two sides Criteria

2 Answers2