How to combine output columns into one using hibernate?

Question

I need to retrieve results and put fname and lname as single values of name column, how can I do that?

     ProjectionList pl = Projections.projectionList();
            pl.add(Projections.property("user.id").as("id"));
            pl.add(Projections.property("user.fname").as("fname"));
            pl.add(Projections.property("user.lname").as("lname"));

Current output

id  fname  lname
17  Alex   Moore
34  Jack   Segal

Output should be

id  name
17  Alex Moore
34  Jack Segal

System.out.println(user.getFirstName() + " " + user.getLastName()). Your database queries shouldn't mess with pure presentation logic. — JB Nizet
– JB Nizet, Commented Nov 21, 2013 at 7:33

Jack · Accepted Answer · 2014-06-16 06:47:45Z

2

The best solution for you would be to use either HQL or SQL queries as explained here

select 
cat.weight + sum(kitten.weight)
from Cat cat
    join cat.kittens kitten
group by cat.id, cat.weight

answered Jun 16, 2014 at 6:47

Jack

6,70629 gold badges87 silver badges154 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to combine output columns into one using hibernate?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related