How can I sort a field from Swagger if the query contains a Join?

Hi all,

I serve using Spring Boot via Swagger the following endpoint:

   @Query("select a from Table a " +
      " join a.team t " +
      " join a.user u " +
      " join a.role r " +
      " where lower(t.name) like lower(concat('%', :filter, '%'))" + SQLESCAPE +
      " or lower(t.field1) like lower(concat('%', :filter, '%'))" + SQLESCAPE +
      " or lower(t.field2) like lower(concat('%', :filter, '%'))" + SQLESCAPE +
      " or lower(u.field3) like lower(concat('%', :filter, '%'))" + SQLESCAPE +
      " or lower(r.field4) like lower(concat('%', :filter, '%'))" + SQLESCAPE)
   )
   Page<Role> findRolesByTypeInAndFilter(@Param("filter") String filter, Pageable pageable);

Select allOpen in new window

It works perfectly but when the user wants to sort I can only sort fields that are NOT in the joins (only fields available in Table).

If user specify the full field name (e.g. u.field3) it works perfectly,

What can I do to let the user just use, for examlpe, field3 for sorting?

Thanks!