List<Human> findByPhoneContaining(String phoneMask, Pageable pageable);

List<Human> findByPhoneContainingAndFirstNameContaining(String phoneMask, String nameMask, Pageable pageable);

 if(nameParam != null){
   query.add(" AND NAME <> :name");
 }

if (!isEmpty(nameParam)){
    c.add(Restrictions.eq("name", nameParam));
}

QClient q = QClient.client;
Predicate predicate = q.phone.contains(phoneMask).and(q.email.contains(emailMask));
List<Client> clientList = clientRepository.findAll(predicate, new PageRequest(fromPosition, countItems)).getContent();

Predicate predicate = q.phone.contains(phoneMask));

Predicate predicate = q.phone.contains(phoneMask).and(q.email.contains(emailMask));

id                email                   phone
17          nat@bla.com	         12345678
21          user@bla.com    	 76030322

Predicate predicate = q.phone.contains(phoneMask).and(q.email.contains(emailMask));
List<Client> clientList = clientRepository.findAll(predicate, new PageRequest(fromPosition, countItems)).getContent();

phoneMask="0322"

emailMask="nat"

21          user@bla.com    	 76030322

Hibernate: select count(client0_.id) as col_0_0_ from client client0_ where (client0_.email like ? escape '!') and (client0_.phone like ? escape '!') limit ?