I have tow fields for 1st name and last name, I use formula to concat them. Im using Pageable to sort the results, but I cant sort with the Formula field.
- When no colum name is specified the the concat is named as formula1
- when name is specified as ‘as’ in query fragment the name of concat is also formula1
- when colum name is specified the name in query is created as a combination of entity class name
and field name in camal case
when I use the generated name it throws PropertyReferenceException
does anyone know how to handle this situation properly