I have entity where I have fisrtName and lastname but in search I need to implement search for fullName. How can I combine this two fields in search in JPA
right now I have something like this:
Query query = em.createQuery("SELECT u from Client u where u.firstName like :firstName or u.lastName like :lastName or u.documentID like :documentID");
I guess it is very commonly used feature but I don't know how to do that. Please help