How to set projection for concatenated result of two columns in Hibernate Criteria

Question

I have a problem to get concatenated result of two columns into single result in Hibernate Criteria.

SQL Query:

SELECT firstName || ' ' || lastName FROM person WHERE active_yn='Y'

How to set projection for concatenated result of two columns in Hibernate Criteria?

what is that problem? can you give more details? – Chaitanya Oct 28 '14 at 07:12 — Chaitanya, Oct 28 '14 at 07:12
I want to write above SQL query in Hibernate Criteria – Pravin Oct 30 '14 at 06:15 — Pravin, Oct 30 '14 at 06:15

score 0 · Answer 1 · answered Oct 28 '14 at 06:53

/ an elegant alternative?
criteria.like(Expression.concat(firstname, ' ', lastName), input);
// an sql-like function?
criteria.like("concat(firstName, ' ', lastName)", input);
// perhaps a database-dependent concatenator?
criteria.like("firstName + ' ' + lastName");
criteria.like("firstName || ' ' || lastName");

More ref

How to set projection for concatenated result of two columns in Hibernate Criteria

1 Answers1

Linked